SCHEMA_EXPORT_OBJECTS
To INCLUDE or EXCLUDE specific object type in exporting or importing schemas, you should know what name of object type should be used.
To know what object type can be used to INCLUDE or EXCLUDE in schema mode, you may query the data dictionary view SCHEMA_EXPORT_OBJECTS to make sure.
OBJECT_PATH
Here is the exhausted list of object path in SCHEMA_EXPORT_OBJECTS for Oracle 19c.
SQL> set pagesize 10000;
SQL> select object_path from schema_export_objects order by 1;
OBJECT_PATH
--------------------------------------------------------------------------------
ALTER_FUNCTION
ALTER_PACKAGE_SPEC
ALTER_PROCEDURE
ANALYTIC_VIEW
AQ
ASSOCIATION
ATTRIBUTE_DIMENSION
AUDIT_OBJ
CLUSTER
CLUSTERING
CODE_BASE_GRANT
COMMENT
COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
CONSTRAINT
CONSTRAINT/REF_CONSTRAINT
DBFS
DB_LINK
DEFAULT_ROLE
DIMENSION
FGA_POLICY
FILE
FUNCTION
FUNCTION/ALTER_FUNCTION
FUNCTION/CODE_BASE_GRANT
GOLDENGATE
GRANT
GRANT/OWNER_GRANT/OBJECT_GRANT
GRANT/PROCDEPOBJ_GRANT
GRANT/PROCOBJ_GRANT
HIERARCHY
INDEX
INDEX/STATISTICS
INDEXTYPE
INSTANCE_CALLOUT
JAVA_CLASS
JAVA_RESOURCE
JAVA_SOURCE
JOB
JVM
LIBRARY
LOGMNR
LOGREP
MATERIALIZED_VIEW
MATERIALIZED_VIEW_LOG
MATERIALIZED_ZONEMAP
MATVW
OAA
OBJECT_GRANT
OLAPAW
OLAPC
OLTP
ON_USER_GRANT
OPERATOR
OWNER_GRANT/OBJECT_GRANT
PACKAGE
PACKAGE/CODE_BASE_GRANT
PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
PACKAGE/PACKAGE_BODY
PACKAGE/PACKAGE_SPEC
PACKAGE_BODY
PACKAGE_SPEC
PACKAGE_SPEC/ALTER_PACKAGE_SPEC
PASSWORD_HISTORY
POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
POST_INSTANCE/PROCDEPOBJ
POST_INSTANCE/PROCDEPOBJ_AUDIT
POST_SCHEMA
POST_TABLE_ACTION
PRE_SCHEMA
PRE_SCHEMA/GRANT/PROCOBJ_GRANT
PRE_SCHEMA/PROCACT_SCHEMA
PRE_SCHEMA/PROCOBJ
PRE_SCHEMA/PROCOBJ_AUDIT
PRE_SCHEMA/SCHEMA_CALLOUT
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
RADM_POLICY
REFRESH_GROUP
REF_CONSTRAINT
RLS_CONTEXT
RLS_GROUP
RLS_POLICY
RLS_POLICY/RLS_POLICY
RMGR
ROLE_GRANT
RULE
SCHEDULER
SCHEMA_CALLOUT
SCHEMA_EXPORT/ANALYTIC_VIEW
SCHEMA_EXPORT/ASSOCIATION
SCHEMA_EXPORT/ATTRIBUTE_DIMENSION
SCHEMA_EXPORT/CLUSTER
SCHEMA_EXPORT/DB_LINK
SCHEMA_EXPORT/DEFAULT_ROLE
SCHEMA_EXPORT/DIMENSION
SCHEMA_EXPORT/FUNCTION
SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
SCHEMA_EXPORT/FUNCTION/CODE_BASE_GRANT
SCHEMA_EXPORT/HIERARCHY
SCHEMA_EXPORT/INDEXTYPE
SCHEMA_EXPORT/JAVA_CLASS
SCHEMA_EXPORT/JAVA_RESOURCE
SCHEMA_EXPORT/JAVA_SOURCE
SCHEMA_EXPORT/JOB
SCHEMA_EXPORT/LIBRARY
SCHEMA_EXPORT/MATERIALIZED_VIEW
SCHEMA_EXPORT/MATERIALIZED_ZONEMAP
SCHEMA_EXPORT/ON_USER_GRANT
SCHEMA_EXPORT/OPERATOR
SCHEMA_EXPORT/PACKAGE
SCHEMA_EXPORT/PACKAGE/CODE_BASE_GRANT
SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
SCHEMA_EXPORT/PASSWORD_HISTORY
SCHEMA_EXPORT/POST_SCHEMA
SCHEMA_EXPORT/PRE_SCHEMA
SCHEMA_EXPORT/PRE_SCHEMA/GRANT/PROCOBJ_GRANT
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
SCHEMA_EXPORT/PRE_SCHEMA/PROCOBJ
SCHEMA_EXPORT/PRE_SCHEMA/PROCOBJ_AUDIT
SCHEMA_EXPORT/PRE_SCHEMA/SCHEMA_CALLOUT
SCHEMA_EXPORT/PROCEDURE
SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
SCHEMA_EXPORT/PROCEDURE/CODE_BASE_GRANT
SCHEMA_EXPORT/REFRESH_GROUP
SCHEMA_EXPORT/ROLE_GRANT
SCHEMA_EXPORT/SEQUENCE
SCHEMA_EXPORT/SYNONYM
SCHEMA_EXPORT/SYNONYM/FGA_POLICY
SCHEMA_EXPORT/SYNONYM/RLS_CONTEXT
SCHEMA_EXPORT/SYNONYM/RLS_GROUP
SCHEMA_EXPORT/SYNONYM/RLS_POLICY/RLS_POLICY
SCHEMA_EXPORT/SYSTEM_GRANT
SCHEMA_EXPORT/TABLE
SCHEMA_EXPORT/TABLE/AUDIT_OBJ
SCHEMA_EXPORT/TABLE/CLUSTERING
SCHEMA_EXPORT/TABLE/COMMENT
SCHEMA_EXPORT/TABLE/CONSTRAINT
SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
SCHEMA_EXPORT/TABLE/FGA_POLICY
SCHEMA_EXPORT/TABLE/GRANT
SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA_EXPORT/TABLE/INDEX
SCHEMA_EXPORT/TABLE/INDEX/STATISTICS
SCHEMA_EXPORT/TABLE/INSTANCE_CALLOUT
SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
SCHEMA_EXPORT/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ
SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT
SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
SCHEMA_EXPORT/TABLE/PRE_TABLE_ACTION
SCHEMA_EXPORT/TABLE/PROCACT_INSTANCE
SCHEMA_EXPORT/TABLE/RADM_POLICY
SCHEMA_EXPORT/TABLE/RLS_CONTEXT
SCHEMA_EXPORT/TABLE/RLS_GROUP
SCHEMA_EXPORT/TABLE/RLS_POLICY/RLS_POLICY
SCHEMA_EXPORT/TABLE/TRIGGER
SCHEMA_EXPORT/TABLESPACE_QUOTA
SCHEMA_EXPORT/TYPE
SCHEMA_EXPORT/TYPE/TYPE_BODY
SCHEMA_EXPORT/TYPE/TYPE_SPEC
SCHEMA_EXPORT/USER
SCHEMA_EXPORT/VIEW
SCHEMA_EXPORT/VIEW/RLS_POLICY/RLS_POLICY
SCHEMA_EXPORT/XMLSCHEMA
SCHEMA_EXPORT/XS_SECURITY
SCHEMA_EXPORT/XS_SECURITY/XS_ACL
SCHEMA_EXPORT/XS_SECURITY/XS_DATA_SECURITY
SCHEMA_EXPORT/XS_SECURITY/XS_SECURITY_CLASS
SEC
SEMANTIC
SEQUENCE
SERVERM
SQL
SRVR
STATISTICS
SYNONYM
SYNONYM/FGA_POLICY
SYNONYM/RLS_CONTEXT
SYNONYM/RLS_GROUP
SYNONYM/RLS_POLICY/RLS_POLICY
SYSTEM_GRANT
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_QUOTA
TRIGGER
TYPE
TYPE/TYPE_BODY
TYPE/TYPE_SPEC
TYPE_BODY
TYPE_SPEC
USER
VIEW
VIEW/RLS_POLICY/RLS_POLICY
XDB
XMLSCHEMA
XS_ACL
XS_DATA_SECURITY
XS_SECURITY
XS_SECURITY/XS_ACL
XS_SECURITY/XS_DATA_SECURITY
XS_SECURITY/XS_SECURITY_CLASS
XS_SECURITY_CLASS
236 rows selected.
There're 236 object paths in schema mode of data pump.
In practice, we don't INCLUDE or EXCLUDE specific object types in exporting schemas in order to have a complete dump, we usually use them to import desired data in a precise fashion.
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 EXCLUDE=STATISTICS in schema mode. We can see its meaning (comments) like this:
SQL> select comments from schema_export_objects where object_path = 'STATISTICS';
COMMENTS
--------------------------------------------------------------------------------
Precomputed statistics
Which means, all objects statistics will be excluded in schema mode.
Next, we perform the import.
[oracle@test ~]$ impdp system/password@orclpdb schemas=HR,OE,SH exclude=STATISTICS dumpfile=schemas.dmp logfile=schemas.log
Which indicates that it will not import statistics of tables and indexes, we'll gather database statistics by ourselves after data migration.
To have the ability to export / import the full database, you need more privileges: