Copy Schema
Go Up to Available object actions by DBMS
This action lets you quickly make copies of a database schema and its corresponding objects.
Platform Availability
To Copy a Schema
- In the data sources pane, right-click a data source and select Copy Schema from the context menu.
- Use the following table as a guide to understanding and choosing options the options in the Copying Schema dialog:
Pane | Options |
---|---|
Action Options |
Lets you specify Copying Schema, Target Schema, specify a Copy Mode of COPY, COPYNO, or DDL, specify a Log filename (COPY and COPYNO modes only), select an Object Owner, and Error table schema, provide an Error table name, and specify a Drop error table after action execution options. |
Tablespace mapping |
Lets you specify source and target tablespace options. |
Preview |
Displays the DDL generated to execute the operation. For more information, see Preview. |
- 3. Execute or Schedule the action.