Transfer of a schema.
If one or more schema’s need to be transferred between databases across platforms, you can use the USER (owner) level export mode.
Example:
– source database is 32-bit 11.2.0.2 database on Redhat Linux 5.6
– target database is 64-bit 11.2.0.2 database on Redhat Linux 5.6
– schema’s scott and hugo need to be transferred
a. On Windows 2000, export with the 9.0.1.4 export utility:
— Windows: type all parameters on one single line:
# exp system/manager FILE=exp_u.dmp LOG=exp_u.log RECORDLENGTH=65535 OWNER=scott,hugo
b. Transfer the file in binary mode to the HP-UX 11i Server.
c. On HP-Unix, import with the 9.2.0.8 import utility:
# imp system/manager FILE=exp_u.dmp LOG=imp_u.log RECORDLENGTH=65535 FROMUSER=scott,hugo TOUSER=scott,hugo
Notes:
1. The user names SCOTT and HUGO must exist in the target database prior to the import operation; otherwise an error is returned.
2. In Oracle10g when using export DataPump and import DataPump, you can use the import DataPump parameter REMAP_SCHEMA which loads all objects from a source schema into a target schema, and creates the target schema if it does not exist.