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