Oracle 18c Datapump-Content Parameter
Description:-
In this article we are going to see the Oracle 18c Datapump-Content Parameter
Let start the Demo:-
Default: ALL
Syntax and Description
CONTENT={ALL | DATA_ONLY | METADATA_ONLY}
ALL loads any data and metadata contained in the source. This is the default.
DATA_ONLY loads only table row data into existing tables; no database objects are created.
METADATA_ONLY loads only database object definitions; no table row data is loaded.
Demo:-ALL (Default-both data&metadata)
[oracle@testdb ~]$ expdp hari/hari@pdb1 tables=emp DIRECTORY=test_dir DUMPFILE=demo.dmp CONTENT=all Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:15:09 2018 Version 18.1.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 "HARI"."SYS_EXPORT_TABLE_01": hari/********@pdb1 tables=emp DIRECTORY=test_dir DUMPFILE=demo.dmp CONTENT=all Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "HARI"."EMP" 17.08 KB 107 rows Master table "HARI"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/datapump/demo.dmp Job "HARI"."SYS_EXPORT_TABLE_01" successfully completed at Sun Jul 15 03:15:26 2018 elapsed 0 00:00:16
Demo:-Metadata_only
[oracle@testdb ~]$ expdp hari/hari@pdb1 tables=emp DIRECTORY=test_dir DUMPFILE=demo1.dmp CONTENT=metadata_only
Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:12:42 2018
Version 18.1.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 "HARI"."SYS_EXPORT_TABLE_01": hari/********@pdb1 tables=emp DIRECTORY=test_dir DUMPFILE=demo1.dmp CONTENT=metadata_only
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Master table "HARI"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HARI.SYS_EXPORT_TABLE_01 is:
/u01/app/oracle/datapump/demo1.dmp
Job "HARI"."SYS_EXPORT_TABLE_01" successfully completed at Sun Jul 15 03:13:04 2018 elapsed 0 00:00:20
Demo:-DATA_ONLY
[oracle@testdb ~]$ expdp hari/hari@pdb1 tables=emp DIRECTORY=test_dir DUMPFILE=demo2.dmp CONTENT=data_only Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:14:37 2018 Version 18.1.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 "HARI"."SYS_EXPORT_TABLE_01": hari/********@pdb1 tables=emp DIRECTORY=test_dir DUMPFILE=demo2.dmp CONTENT=data_only Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . exported "HARI"."EMP" 17.08 KB 107 rows Master table "HARI"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/datapump/demo2.dmp Job "HARI"."SYS_EXPORT_TABLE_01" successfully completed at Sun Jul 15 03:14:44 2018 elapsed 0 00:00:06
Catch Me On:- Hariprasath Rajaram
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 Group:https://www.linkedin.com/groups/10387079 Twitter: https://twitter.com/hariprasathdba
