What can i extract with expdp (what can be added to the include= clause)

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



0 comments:

Post a Comment