Database Copy

This wizard is displayed if you click Tools, then Database Copy. You can copy objects, schemas, or a tablespace from a source connection to a destination connection. The specific options depend on what you are copying.

Some pages include Proceed to Summary, which lets you accept the default values for remaining pages and go directly to the Summary page by clicking Next.

Source/Destination page

Source Connection: Database connection from which to copy the objects, schemas, or tablespace.

Destination Connection: Database connection into which to copy the objects, schemas, or tablespace.

Note: For Schemas Copy or Tablespace Copy, the Source Connection user and the Destination Connection user must have DBA privileges. (DBA privileges are not required for Objects Copy.)

Copy Options: Specify whether to copy database objects, schemas, or tablespaces.

Objects Copy: Copies types of database objects and specific objects of those types.

Schemas Copy: Copies one or more schemas. If you select multiple schemas from the source connection, you can maintain the individual schemas in the destination connection or consolidate them all into one schema in the destination connection.

Tablespace Copy: Copies the objects from a source tablespace to a destination tablespace.

Copy DDL: Copies the object definitions. For destination objects with the same names as source objects of the same type (for example, if both contain a table named EMPLOYEES), specify whether to not perform the copy (that is, do not replace the destination objects) or to perform the copy (that is, replace the existing destination objects with the source objects).

Copy Data: Copies the data for any tables and views that are copied. If you do not select this option, any copied tables or views are empty in the destination connection.

Truncate Destination Data Before Copying: If a table or view of the same name already exists in the destination connection (for example, if an EMPLOYEES table exists in the source and destination), this option deletes any existing data in the destination object before copying the data from the source connection. If this option is not selected, the copied data is appended to the existing data in the destination object.

Object Types page

See Types under Shared Wizard Pages.

Select Schemas page

If you specified Schemas Copy, select one or more schemas from the Available Source Schemas list and click the right-arrow to move them to Selected Source Schemas.

Select Tablespace page

If you specified Tablespace Copy, select the Source Tablespace and Destination Tablespace. Objects in the source tablespace are copied into the destination tablespace.

Specify Objects page

See Specify Objects under Shared Wizard Pages.

Specify Data page

See Data under Shared Wizard Pages.

Summary page

See Summary under Shared Wizard Pages.

Related Topics

Database Connections

Database Objects