Description:-
Indicates whether the master table should be deleted or retained at the end of a Data Pump job that completes successfully. The master table is automatically retained for jobs that do not complete successfully.
Without Keep_master
[oracle@prod101:~ orcl101] expdp scott/tiger tables=emp,oracledbwr directory=TEST_DIR dumpfile=tbs.dmp logfile=tbs.log Job_name=oradbwr24 Export: Release 18.0.0.0.0 - Production on Sat Aug 25 00:12:03 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "SCOTT"."ORADBWR24": scott/******** tables=emp,oracledbwr directory=TEST_DIR dumpfile=tbs.dmp logfile=tbs.log Job_name=oradbwr24 Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX . . exported "SCOTT"."ORACLEDBWR" 3.067 MB 458752 rows . . exported "SCOTT"."EMP" 0 KB 0 rows ORA-39173: Encrypted data has been stored unencrypted in dump file set. Master table "SCOTT"."ORADBWR24" successfully loaded/unloaded ****************************************************************************** Dump file set for SCOTT.ORADBWR24 is: /u01/app/oracle/datapump/tbs.dmp Job "SCOTT"."ORADBWR24" successfully completed at Sat Aug 25 00:12:07 2018 elapsed 0 00:00:04
SQL> select owner,segment_name,segment_type,tablespace_name,(bytes/1024/1024)MB from dba_segments where segment_name=’ORADBWR24′;
no rows selected
With keep_master
[oracle@prod101:~ orcl101] expdp scott/tiger tables=emp,oracledbwr directory=TEST_DIR dumpfile=tbs1.dmp logfile=tbs1.log Job_name=oradbwr24 keep_master=y
Export: Release 18.0.0.0.0 - Production on Sat Aug 25 00:14:10 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "SCOTT"."ORADBWR24": scott/******** tables=emp,oracledbwr directory=TEST_DIR dumpfile=tbs1.dmp logfile=tbs1.log Job_name=oradbwr24 keep_master=y
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
. . exported "SCOTT"."ORACLEDBWR" 3.067 MB 458752 rows
. . exported "SCOTT"."EMP" 0 KB 0 rows
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "SCOTT"."ORADBWR24" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.ORADBWR24 is:
/u01/app/oracle/datapump/tbs1.dmp
Job "SCOTT"."ORADBWR24" successfully completed at Sat Aug 25 00:14:14 2018 elapsed 0 00:00:03
Master Table is not deleted after the job completes. The drop of the master table does not lead to any data dictionary corruption and if you keep the master table after the job completes, then a drop of the master table afterwards will not cause any corruption either.
SQL> select owner,segment_name,segment_type,tablespace_name,(bytes/1024/1024)MB from dba_segments where segment_name='ORADBWR24'; OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME MB --------------- -------------------- ------------------ -------------------- ---------- SCOTT ORADBWR24 TABLE USERS .1875
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
