1. Oracle GoldenGate Microservices Documentation
  2. Extract
  3. Oracle: DDL Replication
  4. Understanding DDL Scopes
  5. Unmapped Scope

Unmapped Scope

If a DDL operation is supported for use in a TABLE or MAP statement, but its base object name is not included in one of those parameters, it is of UNMAPPED scope.

An object name can be of UNMAPPED scope on the source (not in an Extract TABLE statement), but of MAPPED scope on the target (in a Replicat MAP statement), or the other way around. When Oracle DDL is of UNMAPPED scope in the Replicat configuration, Replicat will by default do the following:

  1. Set the current schema of the Replicat session to the schema of the source DDL object.

  2. Execute the DDL as that schema.

  3. Restore Replicat as the current schema of the Replicat session.