Misleading documentation about expdp full mode
According to docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-BA07401C-6261-4B07-AD2C-06CD0A6E0BE9
"A full export does not, by default, export system schemas that contain Oracle-managed data and metadata. Examples of system schemas that are not exported by default include SYS
, ORDSYS
, and MDSYS
."
I tested expdp full=y on a tiny 19.3.0.0 database (with no extra parameters other than dumpfile and logfile). The logfile shows exporting
"SYS"."KU$_USER_MAPPING_VIEW"
"AUDSYS"."AUD$UNIFIED":"SYS_P221"
"SYSTEM"."REDO_DB"
"SYS"."DAM_CONFIG_PARAM$"
"MDSYS"."RDF_PARAM$"
In older (e.g. 10g) documentation, we can find "The following system schemas are not exported as part of a Full export because the metadata they contain is exported as part of other objects in the dump file set: SYS, ORDSYS, EXFSYS, MDSYS, DMSYS, CTXSYS, ORDPLUGINS, LBACSYS, XDB, SI_INFORMTN_SCHEMA, DIP, DBSNMP, and WMSYS." Yunus-Oracle at community.oracle.com/thread/3976949 added that "but with 12c you can still see some of the sys related object being exported and this is due to new feature of 12c view as tables".