Datapump Is very flexible in allowing you to just extract certain object types – but what is the list of what can actually be exported – the details can be found from these 3 queries:
SELECT OBJECT_PATH, COMMENTS
FROM DATABASE_EXPORT_OBJECTS
WHERE OBJECT_PATH NOT LIKE '%/%';
SELECT OBJECT_PATH, COMMENTS
FROM TABLE_EXPORT_OBJECTS
WHERE OBJECT_PATH NOT LIKE '%/%';
SELECT OBJECT_PATH, COMMENTS
FROM SCHEMA_EXPORT_OBJECTS
WHERE OBJECT_PATH NOT LIKE '%/%';
Depending on the type of export you are doing (TABLE/SCHEMA/FULL) the results of the query above shows what can be specified. To list them all from one query we can run this:
select *
from (SELECT 'DB', OBJECT_PATH, COMMENTS
FROM DATABASE_EXPORT_OBJECTS
WHERE OBJECT_PATH NOT LIKE '%/%'
union
SELECT 'TABLE', OBJECT_PATH, COMMENTS
FROM TABLE_EXPORT_OBJECTS
WHERE OBJECT_PATH NOT LIKE '%/%'
union
SELECT 'SCHEMA', OBJECT_PATH, COMMENTS
FROM SCHEMA_EXPORT_OBJECTS
WHERE OBJECT_PATH NOT LIKE '%/%')
order by 1, 2;
This returns:
'DB'
|
OBJECT_PATH
|
COMMENTS
|
DB
|
ALTER_FUNCTION
|
Recompile functions
|
DB
|
ALTER_PACKAGE_SPEC
|
Recompile package specifications
|
DB
|
ALTER_PROCEDURE
|
Recompile procedures
|
DB
|
ASSOCIATION
|
Statistics type associations
|
DB
|
AUDIT
|
Audits of SQL statements
|
DB
|
AUDIT_DEFAULT
|
Procedural system privilege audits
|
DB
|
AUDIT_OBJ
|
Object audits on the selected tables
|
DB
|
CLUSTER
|
Clusters and their indexes
|
DB
|
COMMENT
|
Table and column comments on the selected tables
|
DB
|
CONSTRAINT
|
Constraints (including referential constraints)
|
DB
|
CONTEXT
|
Application contexts
|
DB
|
DB_LINK
|
Private and public database links
|
DB
|
DEFAULT_ROLE
|
Default roles granted to users in the database
|
DB
|
DIMENSION
|
Dimensions
|
DB
|
DIRECTORY
|
Directories and their dependent grants and audits
|
DB
|
DVPS_COMMAND_RULE
|
Database Vault Command Rule definitions
|
DB
|
DVPS_COMMAND_RULE_GROUP
|
Database Vault Command Rule-based security policy definitions
|
DB
|
DVPS_DROP_IMPORT_STAGING_REALM
|
Delete the Database Vault Import Staging Realm definitions
|
DB
|
DVPS_FACTOR
|
Database Vault Factor definitions
|
DB
|
DVPS_FACTOR_GROUP
|
Database Vault Factor definitions
|
DB
|
DVPS_FACTOR_LINK
|
Database Vault Factor Link definitions
|
DB
|
DVPS_FACTOR_TYPE
|
Database Vault Factor Type definitions
|
DB
|
DVPS_IDENTITY
|
Database Vault Identity definitions
|
DB
|
DVPS_IDENTITY_MAP
|
Database Vault Identity Map definitions
|
DB
|
DVPS_IMPORT_STAGING_REALM
|
Database Vault Import Staging Realm definitions
|
DB
|
DVPS_POLICY
|
Database Vault security policies
|
DB
|
DVPS_REALM
|
Database Vault Realm definitions
|
DB
|
DVPS_REALM_AUTHORIZATION
|
Database Vault Realm Authorization definitions
|
DB
|
DVPS_REALM_GROUP
|
Database Vault Realm-based security policy definitions
|
DB
|
DVPS_REALM_MEMBERSHIP
|
Database Vault Realm Membership definitions
|
DB
|
DVPS_ROLE
|
Database Vault Role definitions
|
DB
|
DVPS_RULE
|
Database Vault Rule definitions
|
DB
|
DVPS_RULE_SET
|
Database Vault Rule Set definitions
|
DB
|
DVPS_RULE_SET_MEMBERSHIP
|
Database Vault Rules in a Rule Set definitions
|
DB
|
DVPS_STAGING_REALM_MEMBERSHIP
|
Database Vault Import Staging Realm Membership
|
DB
|
END_PLUGTS_BLK
|
Post-import plugts anonymous block
|
DB
|
FGA_POLICY
|
Fine-grained auditing policies
|
DB
|
FUNCTION
|
Functions and their dependent grants and audits
|
DB
|
GRANT
|
Object grants on the selected tables
|
DB
|
INDEX
|
Indexes
|
DB
|
INDEXTYPE
|
Indextypes and their dependent grants and audits
|
DB
|
INSTANCE_CALLOUT
|
Instance callouts
|
DB
|
JAVA_CLASS
|
Java classes and their dependent grants and audits
|
DB
|
JAVA_RESOURCE
|
Java resources and their dependent grants and audits
|
DB
|
JAVA_SOURCE
|
Java sources and their dependent grants and audits
|
DB
|
JOB
|
Jobs
|
DB
|
LIBRARY
|
External procedure libraries and their dependent grants and audits
|
DB
|
MATERIALIZED_VIEW
|
Materialized views
|
DB
|
MATERIALIZED_VIEW_LOG
|
Materialized view logs
|
DB
|
OBJECT_GRANT
|
Object grants on the selected tables
|
DB
|
OPERATOR
|
Operators and their dependent grants and audits
|
DB
|
PACKAGE
|
Packages (both specification and body) and their dependent grants and audits
|
DB
|
PACKAGE_BODY
|
Package bodies
|
DB
|
PACKAGE_SPEC
|
Package specifications
|
DB
|
PASSWORD_HISTORY
|
Password histories for database users
|
DB
|
PASSWORD_VERIFY_FUNCTION
|
The password complexity verification function
|
DB
|
PLUGTS_BEGIN
|
Call dbms_plugts.beginExport
|
DB
|
PLUGTS_BLK
|
Pre-import anonymous block
|
DB
|
PLUGTS_CHECKPL
|
Call dbms_plugts.checkPluggable
|
DB
|
POST_SCHEMA
|
Post-schema procedural actions and objects and their dependent grants and audits
|
DB
|
POST_SYSTEM
|
Post-system callouts
|
DB
|
POST_SYSTEM_ACTIONS
|
Post-system procedural actions
|
DB
|
POST_TABLE_ACTION
|
Post-table actions
|
DB
|
PRE_SYSTEM
|
Pre-system callouts
|
DB
|
PRE_SYSTEM_ACTIONS
|
Pre-system procedural actions
|
DB
|
PRE_TABLE_ACTION
|
Pre-table actions
|
DB
|
PROCACT_INSTANCE
|
Instance procedural actions
|
DB
|
PROCACT_SCHEMA
|
Schema procedural actions in the selected schemas
|
DB
|
PROCDEPOBJ
|
Instance procedural objects
|
DB
|
PROCDEPOBJ_AUDIT
|
Audits on instance procedural objects
|
DB
|
PROCDEPOBJ_GRANT
|
Grants on instance procedural objects
|
DB
|
PROCEDURE
|
Procedures and their dependent grants and audits
|
DB
|
PROCOBJ
|
Procedural objects in the selected schemas
|
DB
|
PROCOBJ_AUDIT
|
Schema procedural object audits in the selected schemas
|
DB
|
PROCOBJ_GRANT
|
Schema procedural object grants in the selected schemas
|
DB
|
PROC_SYSTEM_GRANT
|
Procedural system privilege grants
|
DB
|
PROFILE
|
Profiles
|
DB
|
PROXY
|
Proxy authentications
|
DB
|
REFRESH_GROUP
|
Refresh groups
|
DB
|
REF_CONSTRAINT
|
Referential constraints
|
DB
|
RESOURCE_COST
|
Resource cost information
|
DB
|
RLS_CONTEXT
|
Fine-grained access control contexts
|
DB
|
RLS_GROUP
|
Fine-grained access control policy groups
|
DB
|
RLS_POLICY
|
Fine-grained access control policies
|
DB
|
ROLE
|
Roles
|
DB
|
ROLE_GRANT
|
Role grants to users in the database
|
DB
|
ROLLBACK_SEGMENT
|
Rollback segments
|
DB
|
SCHEMA
|
Database schemas including related and dependent objects
|
DB
|
SCHEMA
|
Pre-schema procedural actions and objects and their dependent grants and audits
|
DB
|
SCHEMA_CALLOUT
|
Schema callouts in the selected schemas
|
DB
|
SEQUENCE
|
Sequences and their dependent grants and audits
|
DB
|
STATISTICS
|
Precomputed statistics
|
DB
|
SYNONYM
|
Public and private synonyms
|
DB
|
SYSTEM_CALLOUT
|
System callouts
|
DB
|
SYSTEM_PROCOBJACT
|
System procedural actions and objects and their dependent grants and audits
|
DB
|
TABLE
|
Tables and their dependent objects
|
DB
|
TABLESPACE
|
Tablespace definitions
|
DB
|
TABLESPACE_QUOTA
|
Tablespace quota granted to users in the database
|
DB
|
TRIGGER
|
Triggers
|
DB
|
TYPE
|
Types (both specification and body) and their dependent grants and audits
|
DB
|
TYPE_BODY
|
Type bodies
|
DB
|
TYPE_SPEC
|
Type specifications
|
DB
|
USER
|
User definitions
|
DB
|
VIEW
|
Views and their dependent objects
|
DB
|
XMLSCHEMA
|
Xmlschemas
|
SCHEMA
|
ALTER_FUNCTION
|
Recompile functions
|
SCHEMA
|
ALTER_PACKAGE_SPEC
|
Recompile package specifications
|
SCHEMA
|
ALTER_PROCEDURE
|
Recompile procedures
|
SCHEMA
|
ASSOCIATION
|
Statistics type associations
|
SCHEMA
|
AUDIT_OBJ
|
Object audits on the selected tables
|
SCHEMA
|
CLUSTER
|
Clusters in the selected schemas and their indexes
|
SCHEMA
|
COMMENT
|
Table and column comments on the selected tables
|
SCHEMA
|
CONSTRAINT
|
Constraints (including referential constraints)
|
SCHEMA
|
DB_LINK
|
Private database links in the selected schemas
|
SCHEMA
|
DEFAULT_ROLE
|
Default roles granted to users associated with the selected schemas
|
SCHEMA
|
DIMENSION
|
Dimensions in the selected schemas
|
SCHEMA
|
FGA_POLICY
|
Fine-grained auditing policies
|
SCHEMA
|
FUNCTION
|
Functions and their dependent grants and audits
|
SCHEMA
|
GRANT
|
Object grants on the selected tables
|
SCHEMA
|
INDEX
|
Indexes
|
SCHEMA
|
INDEXTYPE
|
Indextypes and their dependent grants and audits
|
SCHEMA
|
INSTANCE_CALLOUT
|
Instance callouts
|
SCHEMA
|
JAVA_CLASS
|
Java classes and their dependent grants and audits
|
SCHEMA
|
JAVA_RESOURCE
|
Java resources and their dependent grants and audits
|
SCHEMA
|
JAVA_SOURCE
|
Java sources and their dependent grants and audits
|
SCHEMA
|
JOB
|
Jobs in the selected schemas
|
SCHEMA
|
LIBRARY
|
External procedure libraries in the selected schemas and their dependent grants and audits
|
SCHEMA
|
MATERIALIZED_VIEW
|
Materialized views
|
SCHEMA
|
MATERIALIZED_VIEW_LOG
|
Materialized view logs
|
SCHEMA
|
OBJECT_GRANT
|
Object grants on the selected tables
|
SCHEMA
|
OPERATOR
|
Operators and their dependent grants and audits
|
SCHEMA
|
PACKAGE
|
Packages (both specification and body) and their dependent grants and audits
|
SCHEMA
|
PACKAGE_BODY
|
Package bodies
|
SCHEMA
|
PACKAGE_SPEC
|
Package specifications
|
SCHEMA
|
PASSWORD_HISTORY
|
The password history for users associated with the selected schemas
|
SCHEMA
|
POST_SCHEMA
|
Post-schema procedural actions and objects and their dependent grants and audits
|
SCHEMA
|
POST_TABLE_ACTION
|
Post-table actions
|
SCHEMA
|
PRE_SCHEMA
|
Pre-schema procedural actions and objects in the selected schemas and their dependent grants and audits
|
SCHEMA
|
PRE_TABLE_ACTION
|
Pre-table actions
|
SCHEMA
|
PROCACT_INSTANCE
|
Instance procedural actions
|
SCHEMA
|
PROCACT_SCHEMA
|
Schema procedural actions in the selected schemas
|
SCHEMA
|
PROCDEPOBJ
|
Instance procedural objects
|
SCHEMA
|
PROCDEPOBJ_AUDIT
|
Audits on instance procedural objects
|
SCHEMA
|
PROCDEPOBJ_GRANT
|
Grants on instance procedural objects
|
SCHEMA
|
PROCEDURE
|
Procedures and their dependent grants and audits
|
SCHEMA
|
PROCOBJ
|
Procedural objects in the selected schemas
|
SCHEMA
|
PROCOBJ_AUDIT
|
Schema procedural object audits in the selected schemas
|
SCHEMA
|
PROCOBJ_GRANT
|
Schema procedural object grants in the selected schemas
|
SCHEMA
|
REFRESH_GROUP
|
Refresh groups in the selected schemas
|
SCHEMA
|
REF_CONSTRAINT
|
Referential constraints
|
SCHEMA
|
RLS_CONTEXT
|
Fine-grained access control contexts
|
SCHEMA
|
RLS_GROUP
|
Fine-grained access control policy groups
|
SCHEMA
|
RLS_POLICY
|
Fine-grained access control policies
|
SCHEMA
|
ROLE_GRANT
|
Role grants to users associated with the selected schemas
|
SCHEMA
|
SCHEMA_CALLOUT
|
Schema callouts in the selected schemas
|
SCHEMA
|
SEQUENCE
|
Sequences in the selected schemas and their dependent grants and audits
|
SCHEMA
|
STATISTICS
|
Precomputed statistics
|
SCHEMA
|
SYNONYM
|
Private synonyms in the selected schemas
|
SCHEMA
|
SYSTEM_GRANT
|
System privileges granted to users associated with the selected schemas
|
SCHEMA
|
TABLE
|
Tables in the selected schemas and their dependent objects
|
SCHEMA
|
TABLESPACE_QUOTA
|
Tablespace quotas granted to users associated with the selected schemas
|
SCHEMA
|
TRIGGER
|
Triggers
|
SCHEMA
|
TYPE
|
Types (both specification and body) and their dependent grants and audits
|
SCHEMA
|
TYPE_BODY
|
Type bodies
|
SCHEMA
|
TYPE_SPEC
|
Type specifications
|
SCHEMA
|
USER
|
User definitions for users associated with the selected schemas
|
SCHEMA
|
VIEW
|
Views and their dependent objects
|
SCHEMA
|
XMLSCHEMA
|
XMLSCHEMAS
|
TABLE
|
AUDIT_OBJ
|
Object audits on the selected tables
|
TABLE
|
COMMENT
|
Table and column comments on the selected tables
|
TABLE
|
CONSTRAINT
|
Constraints (including referential constraints)
|
TABLE
|
END_PLUGTS_BLK
|
Post-import plugts anonymous block
|
TABLE
|
FGA_POLICY
|
Fine-grained auditing policies
|
TABLE
|
GRANT
|
Object grants on the selected tables
|
TABLE
|
INDEX
|
Indexes
|
TABLE
|
INDEX
|
control index export for table-transportable with exclude=index
|
TABLE
|
INSTANCE_CALLOUT
|
Instance callouts
|
TABLE
|
OBJECT_GRANT
|
Object grants on the selected tables
|
TABLE
|
PLUGTS_BEGIN
|
Call dbms_plugts.beginExport
|
TABLE
|
PLUGTS_BLK
|
Pre-import anonymous block
|
TABLE
|
PLUGTS_CHECKPL
|
Call dbms_plugts.checkPluggable
|
TABLE
|
PLUGTS_TSNAME_INDEX
|
Call dbms_plugts.beginExpTablespace for entire indexes
|
TABLE
|
PLUGTS_TSNAME_INDEXP
|
Call dbms_plugts.beginExpTablespace for index partitions
|
TABLE
|
PLUGTS_TSNAME_TABLE
|
Call dbms_plugts.beginExpTablespace for table partitions
|
TABLE
|
POST_TABLE_ACTION
|
Post-table actions
|
TABLE
|
PRE_TABLE_ACTION
|
Pre-table actions
|
TABLE
|
PROCACT_INSTANCE
|
Instance procedural actions
|
TABLE
|
PROCDEPOBJ
|
Instance procedural objects
|
TABLE
|
PROCDEPOBJ_AUDIT
|
Audits on instance procedural objects
|
TABLE
|
PROCDEPOBJ_GRANT
|
Grants on instance procedural objects
|
TABLE
|
REF_CONSTRAINT
|
Referential constraints
|
TABLE
|
RLS_CONTEXT
|
Fine-grained access control contexts
|
TABLE
|
RLS_GROUP
|
Fine-grained access control policy groups
|
TABLE
|
RLS_POLICY
|
Fine-grained access control policies
|
TABLE
|
STATISTICS
|
Precomputed statistics
|
TABLE
|
TRIGGER
|
Triggers on the selected tables
|
Comments
Post a Comment