Home > SQL Developer Dialog Boxes ... > Copy Objects
This dialog box is displayed if you click the Copy Objects icon in the Cart window, which is explained in Using the Cart.
Open Configuration icon: Opens a previously saved XML configuration file, to use its settings as defaults for this use of the dialog box (see Save or Open Cart Tool Configuration).
Save Configuration icon: Saves the current settings in the dialog box to an XML file, which you can later open to use for Cart operations of this type (see Save or Open Cart Tool Configuration).
Destination Connection: Database connection into which to copy the objects.
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.
Related Topics