Database Utilities (MOSC)

MOSC Banner

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".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center