expdp content=metadata_only , exporting sys,ORDDATA,WMSYS,SYSTEM tables in12.1.0.2.0

Feb 9, 2019 2:17PM

Hi all,

I am using expdp to take full database metadata and used the following expdp statement

expdp \'/ as sysdba\' DIRECTORY=export_backups DUMPFILE=exp_schema_nodata_$database-$TIMESTAMP.dmp LOGFILE=exp_schema_nodata_$database-$TIMESTAMP.log CONTENT=metadata_only full=y EXCLUDE=STATISTICS

why expdp exported of sys,ORDDATA,WMSYS,SYSTEM tables. Please see the log file

######expdp logfile contents########

oracle@dshld11:/project/db_ops_backups/ATSE/export_backups/EBXD1$ tail -100f exp_schema_nodata_EBXD1-20190209_1248.log

;;;

Export: Release 12.1.0.2.0 - Production on Sat Feb 9 12:48:01 2019

;;;

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Database Utilities (MOSC)

expdp content=metadata_only , exporting sys,ORDDATA,WMSYS,SYSTEM tables in12.1.0.2.0

Howdy, Stranger!

Category Leaderboard

Top contributors this month