CONTENT :
The CONTENT parameter allows you to alter the contents of the export.
- ALL unloads both data and metadata. This is the default.
- METADATA_ONLY parameter value to export the contents of the schema without the data.
[oracle@18c ~]$ expdp hari/oracle directory=test_dir dumpfile=hari.dmp logfile=hari.log schemas=hari CONTENT=METADATA_ONLY Export: Release 18.0.0.0.0 - Production on Tue Aug 21 23:11:49 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 "HARI"."SYS_EXPORT_SCHEMA_02": hari/******** directory=test_dir dumpfile=hari.dmp logfile=hari.log schemas=hari CONTENT=METADATA_ONLY Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Master table "HARI"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_SCHEMA_02 is: /u01/empdata/hari.dmp Job "HARI"."SYS_EXPORT_SCHEMA_02" successfully completed at Tue Aug 21 23:12:22 2018 elapsed 0 00:00:32
- DATA_ONLY parameter to capture the data without the metadata.
- Here only data only taking exporting
[oracle@18c ~]$ expdp hari/oracle directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log schemas=hari CONTENT=DATA_ONLY Export: Release 18.0.0.0.0 - Production on Tue Aug 21 23:14:42 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 "HARI"."SYS_EXPORT_SCHEMA_02": hari/******** directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log schemas=hari CONTENT=DATA_ONLY Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . exported "HARI"."EMP" 873.1 KB 100000 rows . . exported "HARI"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows Master table "HARI"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_SCHEMA_02 is: /u01/empdata/hari_data.dmp Job "HARI"."SYS_EXPORT_SCHEMA_02" successfully completed at Tue Aug 21 23:14:49 2018 elapsed 0 00:00:06
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