DB-hub Technology Oracle datapump with query

datapump with query

Create DIR:

CREATE [OR REPLACE] DIRECTORY directory_name AS 'path_name'

Export:

nohup expdp \'/ as sysdba\' parfile=archive.par > archive_nohup.log &

cat archive.par

query=config.archive:"where archive_id > 256786 and archive_id <=387650"
tables=config.archive
directory=EXPDIR
dumpfile=archive_%U.dmp
logfile=archive.log
paralle=8

Import:

nohup impdp \'/ as sysdba\' parfile=archive.par > archive_nohup.log &

cat archive.par

tables=config.archive
remap_table=config.archive:archive_bk
table_exists_action=append
directory=IMPDIR
dumpfile=archive_%U.dmp
logfile=archive.log
paralle=8
cluster=N

Leave a Reply

您的邮箱地址不会被公开。 必填项已用 * 标注

Related Post