Skip to content
Home » Oracle Database » Data Migration » Data Pump » DATABASE_EXPORT_OBJECTS, How and Why

DATABASE_EXPORT_OBJECTS, How and Why

DATABASE_EXPORT_OBJECTS

To INCLUDE or EXCLUDE specific object type in exporting or importing the full database, you should know what name of object type should be used.

To know what object type can be used to INCLUDE or EXCLUDE in full mode, you may query the data dictionary view DATABASE_EXPORT_OBJECTS to make sure.

OBJECT_PATH

Here is the exhausted list of object path in DATABASE_EXPORT_OBJECTS for Oracle 19c.

SQL> set pagesize 1000;
SQL> select object_path from database_export_objects order by 1;

OBJECT_PATH
--------------------------------------------------------------------------------
ALTER_FUNCTION
ALTER_PACKAGE_SPEC
ALTER_PROCEDURE
ANALYTIC_VIEW
AQ
ASSOCIATION
ATTRIBUTE_DIMENSION
AUDIT
AUDIT_CONTEXT
AUDIT_DEFAULT
AUDIT_OBJ
AUDIT_POLICY
AUDIT_POLICY_ENABLE
AUDIT_TRAILS
AUDIT_UNIFIED
AUDIT_UNIFIED/AUDIT_CONTEXT
AUDIT_UNIFIED/AUDIT_POLICY
AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
CLUSTER
CLUSTERING
CODE_BASE_GRANT
COMMENT
COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
CONSTRAINT
CONSTRAINT/REF_CONSTRAINT
CONTEXT
DATABASE_EXPORT/AUDIT
DATABASE_EXPORT/AUDIT_DEFAULT
DATABASE_EXPORT/AUDIT_UNIFIED
DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_CONTEXT
DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY
DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
DATABASE_EXPORT/CONTEXT
DATABASE_EXPORT/DIRECTORY/DIRECTORY
DATABASE_EXPORT/DVPS_IMPORT_STAGING_REALM
DATABASE_EXPORT/DVPS_POLICY
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE_ALTS
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_ROLE
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_MEMBERSHIP
DATABASE_EXPORT/DVPS_POLICY/DVPS_DROP_IMPORT_STAGING_REALM
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_ACCTS
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_AP
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DBCAPTURE
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DBREPLAY
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DDL
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DIAG
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DP
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_JOB
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_MAINT
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_PREP
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_PROXY
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_TTS
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_INDEX_FUNC
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_ORADEBUG
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_POLICY_GROUP
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_C
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_C_ALTS
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_R
DATABASE_EXPORT/DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OWNER
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZATION
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP
DATABASE_EXPORT/EARLY_OPTIONS/CLUSTERING
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TYPE_BODY
DATABASE_EXPORT/EARLY_OPTIONS/RADM_POLICY
DATABASE_EXPORT/END_PLUGTS_BLK
DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
DATABASE_EXPORT/NORMAL_OPTIONS/CLUSTERING
DATABASE_EXPORT/NORMAL_OPTIONS/RADM_POLICY
DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BEGIN
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_CHECKPL
DATABASE_EXPORT/POST_SYSTEM
DATABASE_EXPORT/PRE_SYSTEM
DATABASE_EXPORT/PRE_SYSTEM/SYSTEM_CALLOUT
DATABASE_EXPORT/PROFILE
DATABASE_EXPORT/PROXY
DATABASE_EXPORT/RADM_FPTM
DATABASE_EXPORT/RADM_POLICY_EXPR
DATABASE_EXPORT/RESOURCE_COST
DATABASE_EXPORT/ROLE
DATABASE_EXPORT/ROLLBACK_SEGMENT
DATABASE_EXPORT/SCHEMA
DATABASE_EXPORT/SCHEMA
DATABASE_EXPORT/SCHEMA/ANALYTIC_VIEW
DATABASE_EXPORT/SCHEMA/ASSOCIATION
DATABASE_EXPORT/SCHEMA/ATTRIBUTE_DIMENSION
DATABASE_EXPORT/SCHEMA/CLUSTER
DATABASE_EXPORT/SCHEMA/DB_LINK
DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
DATABASE_EXPORT/SCHEMA/DIMENSION
DATABASE_EXPORT/SCHEMA/DVPS_STAGING_REALM_MEMBERSHIP
DATABASE_EXPORT/SCHEMA/FUNCTION
DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
DATABASE_EXPORT/SCHEMA/FUNCTION/CODE_BASE_GRANT
DATABASE_EXPORT/SCHEMA/GRANT/PROCOBJ_GRANT
DATABASE_EXPORT/SCHEMA/HIERARCHY
DATABASE_EXPORT/SCHEMA/INDEXTYPE
DATABASE_EXPORT/SCHEMA/JAVA_CLASS
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE
DATABASE_EXPORT/SCHEMA/JOB
DATABASE_EXPORT/SCHEMA/LIBRARY
DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
DATABASE_EXPORT/SCHEMA/MATERIALIZED_ZONEMAP
DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
DATABASE_EXPORT/SCHEMA/OPERATOR
DATABASE_EXPORT/SCHEMA/PACKAGE
DATABASE_EXPORT/SCHEMA/PACKAGE/CODE_BASE_GRANT
DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
DATABASE_EXPORT/SCHEMA/PASSWORD_HISTORY
DATABASE_EXPORT/SCHEMA/POST_SCHEMA
DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
DATABASE_EXPORT/SCHEMA/PROCEDURE
DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
DATABASE_EXPORT/SCHEMA/PROCEDURE/CODE_BASE_GRANT
DATABASE_EXPORT/SCHEMA/PROCOBJ
DATABASE_EXPORT/SCHEMA/PROCOBJ_AUDIT
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
DATABASE_EXPORT/SCHEMA/REFRESH_GROUP
DATABASE_EXPORT/SCHEMA/ROLE_GRANT
DATABASE_EXPORT/SCHEMA/SCHEMA_CALLOUT
DATABASE_EXPORT/SCHEMA/SEQUENCE
DATABASE_EXPORT/SCHEMA/TABLE
DATABASE_EXPORT/SCHEMA/TABLE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/TABLE/CLUSTERING
DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT
DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
DATABASE_EXPORT/SCHEMA/TABLE/FGA_POLICY
DATABASE_EXPORT/SCHEMA/TABLE/GRANT
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
DATABASE_EXPORT/SCHEMA/TABLE/INDEX
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS
DATABASE_EXPORT/SCHEMA/TABLE/INSTANCE_CALLOUT
DATABASE_EXPORT/SCHEMA/TABLE/MATERIALIZED_VIEW_LOG
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT
DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
DATABASE_EXPORT/SCHEMA/TABLE/RADM_POLICY
DATABASE_EXPORT/SCHEMA/TABLE/RLS_CONTEXT
DATABASE_EXPORT/SCHEMA/TABLE/RLS_GROUP
DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY/RLS_POLICY
DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
DATABASE_EXPORT/SCHEMA/TYPE
DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
DATABASE_EXPORT/SCHEMA/USER
DATABASE_EXPORT/SCHEMA/VIEW
DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY/RLS_POLICY
DATABASE_EXPORT/SCHEMA/XMLSCHEMA
DATABASE_EXPORT/SYSTEM_PROCOBJACT
DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS
DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS
DATABASE_EXPORT/TABLESPACE
DATABASE_EXPORT/TABLESPACE_ILM_POLICY
DATABASE_EXPORT/XS_SECURITY
DATABASE_EXPORT/XS_SECURITY/SCHEMA/XS_ACL
DATABASE_EXPORT/XS_SECURITY/SCHEMA/XS_DATA_SECURITY
DATABASE_EXPORT/XS_SECURITY/SCHEMA/XS_SECURITY_CLASS
DATABASE_EXPORT/XS_SECURITY/XS_ACL_PARAM
DATABASE_EXPORT/XS_SECURITY/XS_GRANT
DATABASE_EXPORT/XS_SECURITY/XS_NAMESPACE
DATABASE_EXPORT/XS_SECURITY/XS_ROLE
DATABASE_EXPORT/XS_SECURITY/XS_ROLESET
DATABASE_EXPORT/XS_SECURITY/XS_ROLE_GRANT
DATABASE_EXPORT/XS_SECURITY/XS_USER
DBFS
DB_LINK
DEFAULT_ROLE
DIMENSION
DIRECTORY
DIRECTORY/DIRECTORY
DVPS_COMMAND_RULE
DVPS_COMMAND_RULE_ALTS
DVPS_COMMAND_RULE_GROUP
DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE
DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE_ALTS
DVPS_COMMAND_RULE_GROUP/DVPS_ROLE
DVPS_COMMAND_RULE_GROUP/DVPS_RULE
DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET
DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_MEMBERSHIP
DVPS_DROP_IMPORT_STAGING_REALM
DVPS_DV_ACCTS
DVPS_DV_AUTH_AP
DVPS_DV_AUTH_DBCAPTURE
DVPS_DV_AUTH_DBREPLAY
DVPS_DV_AUTH_DDL
DVPS_DV_AUTH_DIAG
DVPS_DV_AUTH_DP
DVPS_DV_AUTH_GROUP
DVPS_DV_AUTH_GROUP/DVPS_DV_ACCTS
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_AP
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DBCAPTURE
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DBREPLAY
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DDL
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DIAG
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DP
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_JOB
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_MAINT
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_PREP
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_PROXY
DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_TTS
DVPS_DV_AUTH_GROUP/DVPS_DV_INDEX_FUNC
DVPS_DV_AUTH_GROUP/DVPS_DV_ORADEBUG
DVPS_DV_AUTH_JOB
DVPS_DV_AUTH_MAINT
DVPS_DV_AUTH_PREP
DVPS_DV_AUTH_PROXY
DVPS_DV_AUTH_TTS
DVPS_DV_INDEX_FUNC
DVPS_DV_ORADEBUG
DVPS_DV_POLICY
DVPS_DV_POLICY_GROUP
DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY
DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_C
DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_C_ALTS
DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_R
DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OWNER
DVPS_DV_POLICY_OBJ_C
DVPS_DV_POLICY_OBJ_C_ALTS
DVPS_DV_POLICY_OBJ_R
DVPS_DV_POLICY_OWNER
DVPS_FACTOR
DVPS_FACTOR_GROUP
DVPS_FACTOR_GROUP/DVPS_FACTOR
DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK
DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE
DVPS_FACTOR_GROUP/DVPS_IDENTITY
DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP
DVPS_FACTOR_LINK
DVPS_FACTOR_TYPE
DVPS_IDENTITY
DVPS_IDENTITY_MAP
DVPS_IMPORT_STAGING_REALM
DVPS_POLICY
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE_ALTS
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_ROLE
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_MEMBERSHIP
DVPS_POLICY/DVPS_DROP_IMPORT_STAGING_REALM
DVPS_POLICY/DVPS_DV_AUTH_GROUP
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_ACCTS
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_AP
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DBCAPTURE
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DBREPLAY
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DDL
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DIAG
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_DP
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_JOB
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_MAINT
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_PREP
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_PROXY
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_AUTH_TTS
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_INDEX_FUNC
DVPS_POLICY/DVPS_DV_AUTH_GROUP/DVPS_DV_ORADEBUG
DVPS_POLICY/DVPS_DV_POLICY_GROUP
DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY
DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_C
DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_C_ALTS
DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OBJ_R
DVPS_POLICY/DVPS_DV_POLICY_GROUP/DVPS_DV_POLICY_OWNER
DVPS_POLICY/DVPS_FACTOR_GROUP
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP
DVPS_POLICY/DVPS_REALM_GROUP
DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM
DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZATION
DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP
DVPS_REALM
DVPS_REALM_AUTHORIZATION
DVPS_REALM_GROUP
DVPS_REALM_GROUP/DVPS_REALM
DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZATION
DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP
DVPS_REALM_MEMBERSHIP
DVPS_ROLE
DVPS_RULE
DVPS_RULE_SET
DVPS_RULE_SET_MEMBERSHIP
DVPS_STAGING_REALM_MEMBERSHIP
EARLY_OPTIONS/CLUSTERING
EARLY_OPTIONS/OPTION_TYPE/TYPE_BODY
EARLY_OPTIONS/RADM_POLICY
END_PLUGTS_BLK
FGA_POLICY
FILE
FUNCTION
FUNCTION/ALTER_FUNCTION
FUNCTION/CODE_BASE_GRANT
GOLDENGATE
GRANT
GRANT/OWNER_GRANT/OBJECT_GRANT
GRANT/PROCDEPOBJ_GRANT
GRANT/PROCOBJ_GRANT
GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
HIERARCHY
INDEX
INDEX/STATISTICS
INDEXTYPE
INSTANCE_CALLOUT
JAVA_CLASS
JAVA_RESOURCE
JAVA_SOURCE
JOB
JVM
LABEL_SECURITY
LIBRARY
LOGMNR
LOGREP
MATERIALIZED_VIEW
MATERIALIZED_VIEW_LOG
MATERIALIZED_ZONEMAP
MATVW
NETWORK_ACL
NORMAL_OPTIONS/CLUSTERING
NORMAL_OPTIONS/RADM_POLICY
OAA
OBJECT_GRANT
OLAPAW
OLAPC
OLTP
ON_USER_GRANT
OPERATOR
OPTION_TYPE/TYPE_BODY
OWNER_GRANT/OBJECT_GRANT
PACKAGE
PACKAGE/CODE_BASE_GRANT
PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
PACKAGE/PACKAGE_BODY
PACKAGE/PACKAGE_SPEC
PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
PACKAGE_BODY
PACKAGE_SPEC
PACKAGE_SPEC/ALTER_PACKAGE_SPEC
PASSWORD_HISTORY
PASSWORD_VERIFY_FUNCTION
PLUGTS_BEGIN
PLUGTS_BLK
PLUGTS_CHECKPL
PLUGTS_FULL/PLUGTS_BEGIN
PLUGTS_FULL/PLUGTS_BLK
PLUGTS_FULL/PLUGTS_CHECKPL
POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
POST_INSTANCE/PROCDEPOBJ
POST_INSTANCE/PROCDEPOBJ_AUDIT
POST_SCHEMA
POST_SYSTEM
POST_SYSTEM_ACTIONS
POST_TABLE_ACTION
PRE_SYSTEM
PRE_SYSTEM/SYSTEM_CALLOUT
PRE_SYSTEM_ACTIONS
PRE_TABLE_ACTION
PROCACT_INSTANCE
PROCACT_SCHEMA
PROCDEPOBJ
PROCDEPOBJ_AUDIT
PROCDEPOBJ_GRANT
PROCEDURE
PROCEDURE/ALTER_PROCEDURE
PROCEDURE/CODE_BASE_GRANT
PROCOBJ
PROCOBJ_AUDIT
PROCOBJ_GRANT
PROC_SYSTEM_GRANT
PROFILE
PROXY
PSTDY
PUBLIC_SYNONYM/SYNONYM
RADM_FPTM
RADM_POLICY
RADM_POLICY_EXPR
REFRESH_GROUP
REF_CONSTRAINT
RESOURCE_COST
RLS_CONTEXT
RLS_GROUP
RLS_POLICY
RLS_POLICY/RLS_POLICY
RMGR
ROLE
ROLE_GRANT
ROLLBACK_SEGMENT
RULE
SCHEDULER
SCHEMA
SCHEMA
SCHEMA/ANALYTIC_VIEW
SCHEMA/ASSOCIATION
SCHEMA/ATTRIBUTE_DIMENSION
SCHEMA/CLUSTER
SCHEMA/DB_LINK
SCHEMA/DEFAULT_ROLE
SCHEMA/DIMENSION
SCHEMA/DVPS_STAGING_REALM_MEMBERSHIP
SCHEMA/FUNCTION
SCHEMA/FUNCTION/ALTER_FUNCTION
SCHEMA/FUNCTION/CODE_BASE_GRANT
SCHEMA/GRANT/PROCOBJ_GRANT
SCHEMA/HIERARCHY
SCHEMA/INDEXTYPE
SCHEMA/JAVA_CLASS
SCHEMA/JAVA_RESOURCE
SCHEMA/JAVA_SOURCE
SCHEMA/JOB
SCHEMA/LIBRARY
SCHEMA/MATERIALIZED_VIEW
SCHEMA/MATERIALIZED_ZONEMAP
SCHEMA/ON_USER_GRANT
SCHEMA/OPERATOR
SCHEMA/PACKAGE
SCHEMA/PACKAGE/CODE_BASE_GRANT
SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
SCHEMA/PACKAGE/PACKAGE_SPEC
SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
SCHEMA/PASSWORD_HISTORY
SCHEMA/POST_SCHEMA
SCHEMA/PROCACT_SCHEMA
SCHEMA/PROCEDURE
SCHEMA/PROCEDURE/ALTER_PROCEDURE
SCHEMA/PROCEDURE/CODE_BASE_GRANT
SCHEMA/PROCOBJ
SCHEMA/PROCOBJ_AUDIT
SCHEMA/PUBLIC_SYNONYM/SYNONYM
SCHEMA/REFRESH_GROUP
SCHEMA/ROLE_GRANT
SCHEMA/SCHEMA_CALLOUT
SCHEMA/SEQUENCE
SCHEMA/TABLE
SCHEMA/TABLE/AUDIT_OBJ
SCHEMA/TABLE/CLUSTERING
SCHEMA/TABLE/COMMENT
SCHEMA/TABLE/CONSTRAINT
SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
SCHEMA/TABLE/FGA_POLICY
SCHEMA/TABLE/GRANT
SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/TABLE/INDEX
SCHEMA/TABLE/INDEX/STATISTICS
SCHEMA/TABLE/INSTANCE_CALLOUT
SCHEMA/TABLE/MATERIALIZED_VIEW_LOG
SCHEMA/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT
SCHEMA/TABLE/POST_TABLE_ACTION
SCHEMA/TABLE/PRE_TABLE_ACTION
SCHEMA/TABLE/PROCACT_INSTANCE
SCHEMA/TABLE/RADM_POLICY
SCHEMA/TABLE/RLS_CONTEXT
SCHEMA/TABLE/RLS_GROUP
SCHEMA/TABLE/RLS_POLICY/RLS_POLICY
SCHEMA/TABLE/TRIGGER
SCHEMA/TABLESPACE_QUOTA
SCHEMA/TYPE
SCHEMA/TYPE/TYPE_BODY
SCHEMA/TYPE/TYPE_SPEC
SCHEMA/USER
SCHEMA/VIEW
SCHEMA/VIEW/RLS_POLICY/RLS_POLICY
SCHEMA/XMLSCHEMA
SCHEMA/XS_ACL
SCHEMA/XS_DATA_SECURITY
SCHEMA/XS_SECURITY_CLASS
SCHEMA_CALLOUT
SEC
SEMANTIC
SEQUENCE
SERVERM
SMB
SQL
SRVR
STATISTICS
SYNONYM
SYSTEM_CALLOUT
SYSTEM_GRANT/PROC_SYSTEM_GRANT
SYSTEM_PROCOBJACT
SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS
SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS
TABLE
TABLE/AUDIT_OBJ
TABLE/CLUSTERING
TABLE/COMMENT
TABLE/CONSTRAINT
TABLE/CONSTRAINT/REF_CONSTRAINT
TABLE/FGA_POLICY
TABLE/GRANT
TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
TABLE/INDEX
TABLE/INDEX/STATISTICS
TABLE/INSTANCE_CALLOUT
TABLE/MATERIALIZED_VIEW_LOG
TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
TABLE/POST_INSTANCE/PROCDEPOBJ
TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT
TABLE/POST_TABLE_ACTION
TABLE/PRE_TABLE_ACTION
TABLE/PROCACT_INSTANCE
TABLE/RADM_POLICY
TABLE/RLS_CONTEXT
TABLE/RLS_GROUP
TABLE/RLS_POLICY/RLS_POLICY
TABLE/TRIGGER
TABLESPACE
TABLESPACE_ILM_POLICY
TABLESPACE_QUOTA
TRIGGER
TSDP
TYPE
TYPE/TYPE_BODY
TYPE/TYPE_SPEC
TYPE_BODY
TYPE_SPEC
USER
VIEW
VIEW/RLS_POLICY/RLS_POLICY
WMSYS
XDB
XMLSCHEMA
XS_ACL
XS_ACL_PARAM
XS_DATA_SECURITY
XS_GRANT
XS_NAMESPACE
XS_ROLE
XS_ROLESET
XS_ROLE_GRANT
XS_SECURITY
XS_SECURITY/SCHEMA/XS_ACL
XS_SECURITY/SCHEMA/XS_DATA_SECURITY
XS_SECURITY/SCHEMA/XS_SECURITY_CLASS
XS_SECURITY/XS_ACL_PARAM
XS_SECURITY/XS_GRANT
XS_SECURITY/XS_NAMESPACE
XS_SECURITY/XS_ROLE
XS_SECURITY/XS_ROLESET
XS_SECURITY/XS_ROLE_GRANT
XS_SECURITY/XS_USER
XS_SECURITY_CLASS
XS_USER

566 rows selected.

There're 566 object paths in database mode of data pump. In which, DATABASE_EXPORT/SCHEMA and SCHEMA have duplicated items in the result, furthermore, they are synonyms in database mode.

In practice, we don't INCLUDE or EXCLUDE specific object types in exporting a full database in order to have a complete dump set, while we use them to import only desired data.

The rule is that, once you explicitly include or exclude an object type, all dependent object types in the path will be also included or excluded.

COMMENTS

For example, we'd like to INCLUDE=SCHEMA in full mode. We can see its meaning (comments) like this:

SQL> select comments from database_export_objects where object_path = 'SCHEMA';

COMMENTS
--------------------------------------------------------------------------------
Database schemas including related and dependent objects
Pre-schema procedural actions and objects and their dependent grants and audits

Next, we perform the import.

[oracle@test ~]$ impdp system/password@orclpdb full=yes include=SCHEMA dumpfile=full.dmp logfile=full.log

Which indicates that it will import only normal user's content (i.e. metadata and data), whereas native schemas will not be imported.

To have the ability to export / import the full database, you need more privileges:

Leave a Reply

Your email address will not be published. Required fields are marked *