Remember that the database link proddb01 must be correctly defined and working before you import the data.
userid='system/yourpassword network_link=proddb1.mydomain.com logfile=DATA_PUMP_DIR:user_definitions.log full=Y include=USER
To import a specific user only:
INCLUDE=USER:"='SCOTT'"
To include a specific user and remap it to another user name during import:
REMAP_SCHEMA=SCOTT:JIM INCLUDE=USER:"='SCOTT'"
Remember to check if the SCOTT user is assigned a default tablespace that doesn't exist in the target database.
If this is the case, you need to use remap_schema directive to make it work:
REMAP_TABLESPACE=SCOTT_DATA:JIM_DATA... or potentiall pre-create the tablespace SCOTT_DATA in the target database, but this may not be what you wish.
No comments:
Post a Comment