We can copy database objects like table, view, procedure, function etc from one database to the other database or between two users in the same database using Database Copy Wizard of SQL Developer. Follow these steps to copy database objects inside HR user to the SYSTEM user in the sample database available in Oracle Database 11g Express Edition database.
Setp 1: Open Oracle SQL Developer
Step 2: Click on Tools -> Database Copy to open Database Copy Wizard
Step 3: Select source and destination connection, and click on Next
Here, we have option to enable or disable copying DDL and other option like truncating destination data before copying.
Step 4: Select object types you want to copy and click on Next
Step 5: Click on Lookup to list all the database objects or search specific object using the Textbox. Then click on the double left arrow to select all the listed database objects and click on Next
Step 6: Here, in Specify Data tab, you can specify the data you want to copy. Click on Lookup button to list all the tables and views and click on double lower arrow to select all the tables and views
Step 7: By default all the data of the tables are selected to copy using *. You can specify specific columns and apply WHERE condition by clicking in the Columns and Object Where cells against the table name. Then click on Next
Step 8: Here, in Copy Summary tab you can view a summary of all the objects that will be copied along with other options
Step 9: Progress of coping database objects are shown in a dialog box with an option to run it in background