Configure different names at source and target

Owned by Copy Space for Confluence
Last updated: Jan 27, 2016 by Donna Zehl (Deactivated)

During the setup wizard the following rename question is asked. By answering yes, a rename for the schema can be given.
Specify rename name for any of the specified schemas (yes/no): [yes]
Rename name for schema AVI (empty means no rename): []

 

DDL replication is not supported when replicating from one schema to another schema as the objects will have a different names.

Additionally if tables are renamed DDL is also not supported.

Additionally it is only supported in 11g and higher to rename both the schema & the table on the target. This is a limitation of 10g impdp command. You however still rename the schema on the target just not both due to this remap_table command is an 11g feature.