Copy Schema

From DBArtisan
Jump to: navigation, search

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

  1. In the data sources pane, right-click a data source and select Copy Schema from the context menu.
  2. 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.


Displays the DDL generated to execute the operation. For more information, see Preview.

3. Execute or Schedule the action.