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.
To export an Oracle schema:
On the Options page, set options for exporting a schema. Click Next.
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.
To import an Oracle schema:
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;