Copying Oracle Schema

The topic describes how to copy an Oracle schema to another server or schema.

To copy an Oracle schema, you need to export it with help of the Schema Export Wizard. Once the schema is exported, you can start importing it to another server or schema using the Schema Import Wizard.

Exporting Oracle schema

To export an Oracle schema:

In the Database menu, point to Export & Import, and then click Schema Export on the shortcut menu.
On the General page, select a connection, a schema to export, and a filename for the export script. Click Next.
On the Export Content page, select data to export. Click Next.
On the Options page, set options for exporting a schema. Click Next.

Note

If you export a schema with the Include SET CURRENT SCHEMA option, then, in case you are importing it afterwards with the Schema field being set to other than , the previously set Include SET CURRENT SCHEMA option will be ignored

If you enable Prefix object names with a schema name option, you will not be able to import the script to another schema.
On the Errors Handling page, specify errors processing behavior and logging options. Click Export.

Importing Oracle schema

To import an Oracle schema:

In the Database menu, point to Export & Import, and then click Schema Import on the shortcut menu.
On the Schema Script File page, choose a connection, a schema to export, a filename for the export script, and an SQL file encoding.

If you import a schema to the same server as it was exported from and the Schema field is set to in the **Schema Import Wizard**, make sure the empty schema with the same name exists on the sever. Otherwise, you can execute the following script to create it:
```
 CREATE USER schema_name IDENTIFIED BY pass;
 GRANT CONNECT TO schema_name;
 GRANT RESOURCE TO schema_name;
```
Click Import.