Creating a Copy of Schema Object

Last modified: October 30, 2023

dbForge Studio for Oracle gives you the duplicate object feature. You can make an exact copy of a database object in the same or different database of the same server. It can be very useful for database designers.

To copy an object, right-click its node and select Duplicate Object on the shortcut menu. Then select destination database and type a new object name. If the selected object is a table, you can copy data from it or create an empty table copy.

Note that if you copy a table with foreign key constraints, these constraints will not be copied because there may be no referenced tables in the target database.

You can copy objects of following types:

• Tables
• Views
• Sequences
• Array and table types