Skip to content

Data pump Export Import

Import Specific table only

impdp userid=xyz/****@orcl directory=dbexport dumpfile=exp_xyz_orcl.dmp logfile=imp_xyz_orcl_tbl.log table_exists_action=replace Tables=”xyz”.”table1″

Import: Release 12.2.0.1.0 – Production on Mon Aug 16 09:16:22 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
Master table “xyz”.”SYS_IMPORT_TABLE_01″ successfully loaded/unloaded
Starting “xyz”.”SYS_IMPORT_TABLE_01″: userid=xyz/@orcl directory=dbexport dumpfile=exp_xyz_orcl.dmp logfile=imp_xyz_orcl_tbl.log table_exists_action=replace Tables=xyz.table1


Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported “xyz”.”table1″ 10.63 KB 3 rows
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job “xyz”.”SYS_IMPORT_TABLE_01″ successfully completed at Mon Aug 16 09:17:38 2021 elapsed 0 00:01:08

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: