Friday, August 10, 2012

Datapump exclude/include object types.

datapump object types can be found in following tables

databse_export_objects
schema_export_objects
table_export_objects.

schema_export_objects table content.
OBJECT_PATH COMMENTS NAMED
ALTER_FUNCTION Recompile functions Y
ALTER_PACKAGE_SPEC Recompile package specifications Y
ALTER_PROCEDURE Recompile procedures Y
ASSOCIATION Statistics type associations
AUDIT_OBJ Object audits on the selected tables
CLUSTER Clusters in the selected schemas and their indexes Y
COMMENT Table and column comments on the selected tables
COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Recompile package specifications
CONSTRAINT Constraints (including referential constraints) Y
CONSTRAINT/REF_CONSTRAINT Referential constraints
DB_LINK Private database links in the selected schemas Y
DEFAULT_ROLE Default roles granted to users associated with the selected schemas
DIMENSION Dimensions in the selected schemas Y
FGA_POLICY Fine-grained auditing policies
FUNCTION Functions and their dependent grants and audits Y
FUNCTION/ALTER_FUNCTION Recompile functions
GRANT Object grants on the selected tables
GRANT/OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
GRANT/PROCOBJ_GRANT Schema procedural object grants in the selected schemas
INDEX Indexes Y
INDEX/STATISTICS Precomputed statistics
INDEXTYPE Indextypes and their dependent grants and audits Y
INSTANCE_CALLOUT Instance callouts
JAVA_CLASS Java classes and their dependent grants and audits Y
JAVA_RESOURCE Java resources and their dependent grants and audits Y
JAVA_SOURCE Java sources and their dependent grants and audits Y
JOB Jobs in the selected schemas
LIBRARY External procedure libraries in the selected schemas and their dependent grants and audits Y
MATERIALIZED_VIEW Materialized views Y
MATERIALIZED_VIEW_LOG Materialized view logs Y
OBJECT_GRANT Object grants on the selected tables
OPERATOR Operators and their dependent grants and audits Y
OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
PACKAGE Packages (both specification and body) and their dependent grants and audits Y
PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Recompile package specifications
PACKAGE/PACKAGE_BODY Package bodies
PACKAGE/PACKAGE_SPEC Package specifications
PACKAGE_BODY Package bodies Y
PACKAGE_SPEC Package specifications Y
PACKAGE_SPEC/ALTER_PACKAGE_SPEC Recompile package specifications
PASSWORD_HISTORY The password history for users associated with the selected schemas
POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
POST_INSTANCE/PROCDEPOBJ Instance procedural objects
POST_INSTANCE/PROCDEPOBJ_AUDIT Audits on instance procedural objects
POST_SCHEMA Post-schema procedural actions and objects and their dependent grants and audits
POST_TABLE_ACTION Post-table actions
PRE_SCHEMA Pre-schema procedural actions and objects in the selected schemas and their dependent grants and audits
PRE_SCHEMA/GRANT/PROCOBJ_GRANT Schema procedural object grants in the selected schemas
PRE_SCHEMA/PROCACT_SCHEMA Schema procedural actions in the selected schemas
PRE_SCHEMA/PROCOBJ Procedural objects in the selected schemas
PRE_SCHEMA/PROCOBJ_AUDIT Schema procedural object audits in the selected schemas
PRE_SCHEMA/SCHEMA_CALLOUT Schema callouts in the selected schemas
PRE_TABLE_ACTION Pre-table actions
PROCACT_INSTANCE Instance procedural actions
PROCACT_SCHEMA Schema procedural actions in the selected schemas
PROCDEPOBJ Instance procedural objects Y
PROCDEPOBJ_AUDIT Audits on instance procedural objects
PROCDEPOBJ_GRANT Grants on instance procedural objects
PROCEDURE Procedures and their dependent grants and audits Y
PROCEDURE/ALTER_PROCEDURE Recompile procedures
PROCOBJ Procedural objects in the selected schemas Y
PROCOBJ_AUDIT Schema procedural object audits in the selected schemas
PROCOBJ_GRANT Schema procedural object grants in the selected schemas
REFRESH_GROUP Refresh groups in the selected schemas Y
REF_CONSTRAINT Referential constraints Y
RLS_CONTEXT Fine-grained access control contexts
RLS_GROUP Fine-grained access control policy groups
RLS_POLICY Fine-grained access control policies
RLS_POLICY/RLS_POLICY Fine-grained access control policies
ROLE_GRANT Role grants to users associated with the selected schemas
SCHEMA_CALLOUT Schema callouts in the selected schemas
SCHEMA_EXPORT/ASSOCIATION Statistics type associations
SCHEMA_EXPORT/CLUSTER Clusters in the selected schemas and their indexes
SCHEMA_EXPORT/DB_LINK Private database links in the selected schemas
SCHEMA_EXPORT/DEFAULT_ROLE Default roles granted to users associated with the selected schemas
SCHEMA_EXPORT/DIMENSION Dimensions in the selected schemas
SCHEMA_EXPORT/FUNCTION Functions and their dependent grants and audits
SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Recompile functions
SCHEMA_EXPORT/INDEXTYPE Indextypes and their dependent grants and audits
SCHEMA_EXPORT/JAVA_CLASS Java classes and their dependent grants and audits
SCHEMA_EXPORT/JAVA_RESOURCE Java resources and their dependent grants and audits
SCHEMA_EXPORT/JAVA_SOURCE Java sources and their dependent grants and audits
SCHEMA_EXPORT/JOB Jobs in the selected schemas
SCHEMA_EXPORT/LIBRARY External procedure libraries in the selected schemas and their dependent grants and audits
SCHEMA_EXPORT/MATERIALIZED_VIEW Materialized views
SCHEMA_EXPORT/OPERATOR Operators and their dependent grants and audits
SCHEMA_EXPORT/PACKAGE Packages (both specification and body) and their dependent grants and audits
SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Recompile package specifications
SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Package bodies
SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Package specifications
SCHEMA_EXPORT/PASSWORD_HISTORY The password history for users associated with the selected schemas
SCHEMA_EXPORT/POST_SCHEMA Post-schema procedural actions and objects and their dependent grants and audits
SCHEMA_EXPORT/PRE_SCHEMA Pre-schema procedural actions and objects in the selected schemas and their dependent grants and audits
SCHEMA_EXPORT/PRE_SCHEMA/GRANT/PROCOBJ_GRANT Schema procedural object grants in the selected schemas
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Schema procedural actions in the selected schemas
SCHEMA_EXPORT/PRE_SCHEMA/PROCOBJ Procedural objects in the selected schemas
SCHEMA_EXPORT/PRE_SCHEMA/PROCOBJ_AUDIT Schema procedural object audits in the selected schemas
SCHEMA_EXPORT/PRE_SCHEMA/SCHEMA_CALLOUT Schema callouts in the selected schemas
SCHEMA_EXPORT/PROCEDURE Procedures and their dependent grants and audits
SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Recompile procedures
SCHEMA_EXPORT/REFRESH_GROUP Refresh groups in the selected schemas
SCHEMA_EXPORT/ROLE_GRANT Role grants to users associated with the selected schemas
SCHEMA_EXPORT/SEQUENCE Sequences in the selected schemas and their dependent grants and audits
SCHEMA_EXPORT/SYNONYM Private synonyms in the selected schemas
SCHEMA_EXPORT/SYNONYM/FGA_POLICY Fine-grained auditing policies
SCHEMA_EXPORT/SYNONYM/RLS_CONTEXT Fine-grained access control contexts
SCHEMA_EXPORT/SYNONYM/RLS_GROUP Fine-grained access control policy groups
SCHEMA_EXPORT/SYNONYM/RLS_POLICY/RLS_POLICY Fine-grained access control policies
SCHEMA_EXPORT/SYSTEM_GRANT System privileges granted to users associated with the selected schemas
SCHEMA_EXPORT/TABLE Tables in the selected schemas and their dependent objects
SCHEMA_EXPORT/TABLE/AUDIT_OBJ Object audits on the selected tables
SCHEMA_EXPORT/TABLE/COMMENT Table and column comments on the selected tables
SCHEMA_EXPORT/TABLE/CONSTRAINT Constraints (including referential constraints)
SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Referential constraints
SCHEMA_EXPORT/TABLE/FGA_POLICY Fine-grained auditing policies
SCHEMA_EXPORT/TABLE/GRANT Object grants on the selected tables
SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
SCHEMA_EXPORT/TABLE/INDEX Indexes
SCHEMA_EXPORT/TABLE/INDEX/STATISTICS Precomputed statistics
SCHEMA_EXPORT/TABLE/INSTANCE_CALLOUT Instance callouts
SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG Materialized view logs
SCHEMA_EXPORT/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ Instance procedural objects
SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT Audits on instance procedural objects
SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION Post-table actions
SCHEMA_EXPORT/TABLE/PRE_TABLE_ACTION Pre-table actions
SCHEMA_EXPORT/TABLE/PROCACT_INSTANCE Instance procedural actions
SCHEMA_EXPORT/TABLE/RLS_CONTEXT Fine-grained access control contexts
SCHEMA_EXPORT/TABLE/RLS_GROUP Fine-grained access control policy groups
SCHEMA_EXPORT/TABLE/RLS_POLICY/RLS_POLICY Fine-grained access control policies
SCHEMA_EXPORT/TABLE/TRIGGER Triggers
SCHEMA_EXPORT/TABLESPACE_QUOTA Tablespace quotas granted to users associated with the selected schemas
SCHEMA_EXPORT/TYPE Types (both specification and body) and their dependent grants and audits
SCHEMA_EXPORT/TYPE/TYPE_BODY Type bodies
SCHEMA_EXPORT/TYPE/TYPE_SPEC Type specifications
SCHEMA_EXPORT/USER User definitions for users associated with the selected schemas
SCHEMA_EXPORT/VIEW Views and their dependent objects
SCHEMA_EXPORT/VIEW/RLS_POLICY/RLS_POLICY Fine-grained access control policies
SCHEMA_EXPORT/XMLSCHEMA XMLSCHEMAS
SEQUENCE Sequences in the selected schemas and their dependent grants and audits Y
STATISTICS Precomputed statistics
SYNONYM Private synonyms in the selected schemas Y
SYNONYM/FGA_POLICY Fine-grained auditing policies
SYNONYM/RLS_CONTEXT Fine-grained access control contexts
SYNONYM/RLS_GROUP Fine-grained access control policy groups
SYNONYM/RLS_POLICY/RLS_POLICY Fine-grained access control policies
SYSTEM_GRANT System privileges granted to users associated with the selected schemas
TABLE Tables in the selected schemas and their dependent objects Y
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/CONSTRAINT/REF_CONSTRAINT Referential constraints
TABLE/FGA_POLICY Fine-grained auditing policies
TABLE/GRANT Object grants on the selected tables
TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
TABLE/INDEX Indexes
TABLE/INDEX/STATISTICS Precomputed statistics
TABLE/INSTANCE_CALLOUT Instance callouts
TABLE/MATERIALIZED_VIEW_LOG Materialized view logs
TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
TABLE/POST_INSTANCE/PROCDEPOBJ Instance procedural objects
TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT Audits on instance procedural objects
TABLE/POST_TABLE_ACTION Post-table actions
TABLE/PRE_TABLE_ACTION Pre-table actions
TABLE/PROCACT_INSTANCE Instance procedural actions
TABLE/RLS_CONTEXT Fine-grained access control contexts
TABLE/RLS_GROUP Fine-grained access control policy groups
TABLE/RLS_POLICY/RLS_POLICY Fine-grained access control policies
TABLE/TRIGGER Triggers
TABLESPACE_QUOTA Tablespace quotas granted to users associated with the selected schemas
TRIGGER Triggers Y
TYPE Types (both specification and body) and their dependent grants and audits Y
TYPE/TYPE_BODY Type bodies
TYPE/TYPE_SPEC Type specifications
TYPE_BODY Type bodies Y
TYPE_SPEC Type specifications Y
USER User definitions for users associated with the selected schemas Y
VIEW Views and their dependent objects Y
VIEW/RLS_POLICY/RLS_POLICY Fine-grained access control policies
XMLSCHEMA XMLSCHEMAS Y

2 comments: