This tutorial shows how to use the Database Copy feature using
Oracle SQL Developer 3.1
Time to Complete
Approximately 15 minutes
Oracle SQL Developer is a free graphical tool that enhances
productivity and simplifies database development tasks. Using
SQL Developer, you can browse database objects, run SQL
statements, edit and debug PL/SQL statements and run reports,
whether provided or created.
Developed in Java, SQL Developer runs on Windows, Linux and the Mac OS X. This is a great advantage to the increasing number of developers using alternative platforms. Multiple platform support also means that you can install SQL Developer on the Database Server and connect remotely from their desktops, thus avoiding client server network traffic.
The Database Copy feature in SQL Developer 3.1 is a new feature that is used to copy objects and data from one database or schema to another. In this example, 'HR' database schema objects are copied to another database schema named 'HR_COPY'.
Hardware and Software Requirements
The following is a list of software requirements:
Before starting this tutorial, you should:
- Install Oracle SQL Developer 3.1 from OTN. Follow the readme instructions here.
- Install Oracle Database 11g with the Sample schema.
Note: The Database Copy feature can also work on a 10g instance.
- Unlock the HR user. Login
to SQL Developer as the SYS user
and execute the following command:
alter user hr identified by hr account unlock;
Creating a Database Connection to the Source and Destination Database Schema
The first step to managing database objects using Oracle SQL
Developer 3.1 is to create a database connection.
Perform the following steps to create database connections for the source and destination database schema:
Note: If you have already created a source and destination database connection, then you may move to Using the Database Copy Feature topic.
Using the Database Copy Feature
The Database Copy feature opens a Database Copy Wizard Window which consists of five steps.
Viewing the Copied Data in the Destination Database Schema
You may view the objects in the destination schema that were
In this tutorial, you have learned how to:
- Create a Database Connection for the Source and Destination Schema
- Use the Database Copy feature to copy data from one database schema to another
- View the copied data in the Destination Schema
- To learn more about SQL Developer 3.1, refer to additional OBEs in the OLL Web site
- Lead Curriculum Developer: Anupama Mandya
- Other Contributors: Jeff Smith, Ashley Chen
To help navigate this Oracle by Example, note the following:
- Hiding Header Buttons:
- Click the Title to hide the buttons in the header. To show the buttons again, simply click the Title again.
- Topic List Button:
- A list of all the topics. Click one of the topics to navigate to that section.
- Expand/Collapse All Topics:
- To show/hide all the detail for all the sections. By default, all topics are collapsed
- Show/Hide All Images:
- To show/hide all the screenshots. By default, all images are displayed.
- To print the content. The content currently displayed or hidden will be printed.
To navigate to a particular section in this tutorial, select the topic from the list.