Exaple: expdp&impdp in parfile

impdp_tab01_user.par
directory=DMPDIR
dumpfile=expdp_tab01_user.dmp
logfile=impdp_tab01_user.log
parallel=4
cluster=n
EXCLUDE=INDEX
EXCLUDE=TABLE_STATISTICS
EXCLUDE=INDEX_STATISTICS
TABLE_EXISTS_ACTION=REPLACE
transform=disable_archive_logging:y
transform=storage:n
TABLES=USER.tab01
remap_schema=USER:USER
remap_tablespace=USERS:USERS

impdp c##ogg_user@ORCLPDB1 parfile=impdp_tab01_user.par

vi expdp_tab01_user.par
DIRECTORY=DMPDIR
DUMPFILE=expdp_tab01_user.dmp
LOGFILE=expdp_tab01_user.log
CLUSTER=N
PARALLEL=4
TABLES=
USER.tab01

expdp c##ogg_user@pstg parfile=expdp_tab01_user.par

vi expdp_orcl_preprod_data_schemas.par
DIRECTORY=DMPDIR
DUMPFILE=expdp_orcl_preprod_data_schemas_%U.dmp
LOGFILE=expdp_orcl_preprod_data_schemas.log
FLASHBACK_SCN=1197898541013
CLUSTER=N
PARALLEL=4
SCHEMAS=USER,OGG
EXCLUDE=TABLE_STATISTICS
EXCLUDE=INDEX_STATISTICS

vi impdp_orcl_preprod_data_schemas.par
directory=DMPDIR
dumpfile=expdp_orcl_preprod_data_schemas_1111.dmp
logfile=imppdp_orcl_preprod_data_schemas_.log
PARALLEL=10
CLUSTER=N
SCHEMAS=USER,OGG
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
TRANSFORM=STORAGE:N

vi expdp_orcl_preprod_data_user.par
DIRECTORY=DMPDIR
DUMPFILE=expdp_orcl_preprod_data_user_%U.dmp
LOGFILE=expdp_orcl_preprod_data_user.log
CLUSTER=N
PARALLEL=4
SCHEMAS=USER
EXCLUDE=TABLE_STATISTICS
EXCLUDE=INDEX_STATISTICS

nohup expdp c##ogg_user@pstg parfile=expdp_orcl_preprod_data_user.par &

vi impdp_orcl_preprod_data_user.par
directory=DMPDIR
dumpfile=expdp_orcl_preprod_data_user_1111.dmp
logfile=impdp_orcl_preprod_data_user.log
PARALLEL=4
CLUSTER=N
SCHEMAS=USER
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
TRANSFORM=STORAGE:N
compression=all
remap_schema=USER:TARGET
remap_tablespace=USERS:USERS

nohup impdp c##ogg_user/****@ORCLPDB1 parfile=impdp_orcl_preprod_data_user.par &

CREATE DIRECTORY DMPDIR AS ‘/u01/app/oracle/dump’;
GRANT READ, WRITE ON DIRECTORY DMPDIR TO c##ogg_user;

expdp c##ogg_user/oracle@pstg directory=dmpdir dumpfile=user001.dmp logfile=expdp_user001.log compression=all SCHEMAS=USER
expdp c##ogg_user/oracle@pstg directory=dmpdir dumpfile=user001.dmp logfile=expdp_user001.log compression=all TABLES=USER.TAB01
expdp user/oracle@pstg directory=dmpdir dumpfile=user001.dmp logfile=expdp_user001.log compression=all TABLES=USER.TAB01

expdp c##ogg_user/oracle@pstg directory=dmpdir dumpfile=user001.dmp logfile=expdp_user001.log compression=all SCHEMAS=USER
expdp user/oracle@pdch directory=dmpdir dumpfile=user001.dmp logfile=expdp_user001.log compression=all TABLES=USER.TAB01

vi expdp_orcl_preprod_data_user_tables.par
DIRECTORY=DMPDIR
DUMPFILE=expdp_orcl_preprod_data_user_tables_%U.dmp
LOGFILE=expdp_orcl_preprod_data_user_tables.log
CLUSTER=N
PARALLEL=4
EXCLUDE=TABLE_STATISTICS
EXCLUDE=INDEX_STATISTICS
compression=all
TABLES=
user.argo_ar_carrier_visit
,user.tab01
,user.tab02

vi impdp_orcl_preprod_data_user_tables.par
directory=DMPDIR
dumpfile=expdp_orcl_preprod_data_user_tables_%U.dmp
logfile=impdp_orcl_preprod_data_user_tables.log
CONTENT=DATA_ONLY
PARALLEL=4
CLUSTER=N
SCHEMAS=USER
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
TRANSFORM=STORAGE:N
remap_schema=USER:TARGET
remap_tablespace=USERS:USERS

nohup impdp c##ogg_user/****@ORCLPDB1 parfile=impdp_orcl_preprod_data_user.par &

Leave a Reply

Your email address will not be published. Required fields are marked *