Friday, August 8, 2014

Datapump import filters

Type Comment
ALTER_FUNCTION Recompile functions
ALTER_PACKAGE_SPEC Recompile package specifications
ALTER_PROCEDURE Recompile procedures
ASSOCIATION Statistics type associations
AUDIT Audits of SQL statements
AUDIT_DEFAULT Procedural system privilege audits
AUDIT_OBJ Object audits on the selected tables
AUDIT_OBJ
BITMAP_INDEX
BITMAP_INDEX/INDEX
BITMAP_INDEX/INDEX_STATISTICS
CLUSTER
CLUSTER Clusters and their indexes
CLUSTER/CLUSTER
CLUSTER/INDEX
COMMENT Table and column comments on the selected tables
COMMENT
COMPILE_PACKAGE
COMPILE_PACKAGE/PACKAGE_SPEC
COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Recompile package specifications
CONSTRAINT
CONSTRAINT Constraints (including referential constraints)
CONSTRAINT/CONSTRAINT
CONSTRAINT/REF_CONSTRAINT Referential constraints
CONTEXT Application contexts
CROSS_SCHEMA
CROSS_SCHEMA/OBJECT_GRANT
DATABASE_EXPORT/AUDIT Audits of SQL statements
DATABASE_EXPORT/AUDIT_DEFAULT Procedural system privilege audits
DATABASE_EXPORT/CONTEXT Application contexts
DATABASE_EXPORT/DIRECTORY
DATABASE_EXPORT/DIRECTORY/AUDIT_OBJ
DATABASE_EXPORT/DIRECTORY/DIRECTORY Directories and their dependent grants and audits
DATABASE_EXPORT/DIRECTORY/GRANT
DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJEC
DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT
DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT
DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION
DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION/
DATABASE_EXPORT/DVPS_IMPORT_STAGING_REALM Database Vault Import Staging Realm definitions
DATABASE_EXPORT/DVPS_POLICY Database Vault security policies
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU Database Vault Command Rule-based security policy definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU Database Vault Command Rule definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU Database Vault Role definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU Database Vault Rule definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU Database Vault Rule Set definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU Database Vault Rules in a Rule Set definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_DROP_IMPORT_STAGI Delete the Database Vault Import Staging Realm definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP Database Vault Factor definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS Database Vault Factor definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS Database Vault Factor Link definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS Database Vault Factor Type definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS Database Vault Identity definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS Database Vault Identity Map definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP Database Vault Realm-based security policy definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_ Database Vault Realm definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_ Database Vault Realm Authorization definitions
DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_ Database Vault Realm Membership definitions
DATABASE_EXPORT/EARLY_OPTIONS
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_OBJNUM
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE/OPTIO
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE/PACKA
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE/PACKA
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/OPTION_O
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/SORT_TYP
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TABTYPE_
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TYPE_BOD Type bodies
DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TYPE_SPE
DATABASE_EXPORT/EARLY_OPTIONS/POST_DATA_TABLE
DATABASE_EXPORT/EARLY_OPTIONS/PROCEDURE
DATABASE_EXPORT/EARLY_OPTIONS/TABLE
DATABASE_EXPORT/EARLY_OPTIONS/TABLE_DATA
DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES
DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABL
DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABL
DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/VAT_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/AUDIT_OBJ Object audits on the selected tables
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/COMMENT Table and column comments on the selected tables
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/CONSTRAINT
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FGA_POLICY Fine-grained auditing policies
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT Object grants on the selected tables
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/CROSS
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/CROSS
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/OWNER
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/OWNER Object grants on the selected tables
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/WITH_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/WITH_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/INDEX
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/INDEX_STATI
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/OPTION_OBJN
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/POST_DATA_T
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/REF_CONSTRA
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_CONTEXT Fine-grained access control contexts
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_GROUP Fine-grained access control policy groups
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_POLICY Fine-grained access control policies
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_POLICY_
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/TABLE
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/TABLE_DATA
DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/TRIGGER
DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT
DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MAR
DATABASE_EXPORT/END_PLUGTS_BLK Post-import plugts anonymous block
DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT
DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MAR
DATABASE_EXPORT/GRANT
DATABASE_EXPORT/GRANT/SYSTEM_GRANT
DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRA Procedural system privilege grants
DATABASE_EXPORT/NORMAL_OPTIONS
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_OBJNUM
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE/OPTI
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE/PACK
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE/PACK
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/OPTION_
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/SORT_TY
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/TABTYPE
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/TYPE_BO Type bodies
DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/TYPE_SP
DATABASE_EXPORT/NORMAL_OPTIONS/POST_DATA_TABLE
DATABASE_EXPORT/NORMAL_OPTIONS/PROCEDURE
DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES
DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TAB
DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TAB
DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/VAT
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/AUDIT_OBJ Object audits on the selected tables
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/COMMENT Table and column comments on the selected tables
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/CONSTRAINT
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FGA_POLICY Fine-grained auditing policies
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT Object grants on the selected tables
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/CROS
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/CROS
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/OWNE
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/OWNE Object grants on the selected tables
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/WITH
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/WITH
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/INDEX
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/INDEX_STAT
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/OPTION_OBJ
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/POST_DATA_
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/REF_CONSTR
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_CONTEX Fine-grained access control contexts
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_GROUP Fine-grained access control policy groups
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_POLICY Fine-grained access control policies
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_POLICY
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/TABLE
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/TABLE_DATA
DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/TRIGGER
DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU
DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MAR
DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION The password complexity verification function
DATABASE_EXPORT/PLUGTS_FULL
DATABASE_EXPORT/PLUGTS_FULL/EARLY
DATABASE_EXPORT/PLUGTS_FULL/EARLY/PLUGTS_TABLESPAC
DATABASE_EXPORT/PLUGTS_FULL/FULL
DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BEGIN Call dbms_plugts.beginExport
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK Pre-import anonymous block
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_CHECKPL Call dbms_plugts.checkPluggable
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_EARLY_TABLESPAC
DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_TSNAME_FULL
DATABASE_EXPORT/PLUGTS_FULL/TABLESPACE
DATABASE_EXPORT/POST_SYSTEM Post-system callouts
DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT
DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
DATABASE_EXPORT/POST_SYSTEM/SYSTEM_CALLOUT
DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT
DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
DATABASE_EXPORT/PRE_SYSTEM Pre-system callouts
DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT
DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
DATABASE_EXPORT/PRE_SYSTEM/SYSTEM_CALLOUT System callouts
DATABASE_EXPORT/PROCOBJ_OBJNUM
DATABASE_EXPORT/PROFILE Profiles
DATABASE_EXPORT/PROXY Proxy authentications
DATABASE_EXPORT/RESOURCE_COST Resource cost information
DATABASE_EXPORT/ROLE Roles
DATABASE_EXPORT/ROLLBACK_SEGMENT Rollback segments
DATABASE_EXPORT/SCHEMA
DATABASE_EXPORT/SCHEMA Pre-schema procedural actions and objects and their dependent grants and audits
DATABASE_EXPORT/SCHEMA Database schemas including related and dependent objects
DATABASE_EXPORT/SCHEMA/ASSOCIATION Statistics type associations
DATABASE_EXPORT/SCHEMA/CLUSTER Clusters and their indexes
DATABASE_EXPORT/SCHEMA/CLUSTER/CLUSTER
DATABASE_EXPORT/SCHEMA/CLUSTER/INDEX
DATABASE_EXPORT/SCHEMA/DB_LINK Private and public database links
DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE Default roles granted to users in the database
DATABASE_EXPORT/SCHEMA/DIMENSION Dimensions
DATABASE_EXPORT/SCHEMA/DVPS_STAGING_REALM_MEMBERSH Database Vault Import Staging Realm Membership
DATABASE_EXPORT/SCHEMA/EVENT
DATABASE_EXPORT/SCHEMA/EVENT/TRIGGER
DATABASE_EXPORT/SCHEMA/FUNCTION Functions and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/FUNCTION
DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION Recompile functions
DATABASE_EXPORT/SCHEMA/FUNCTION/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/WITH_GRANT_O
DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/WITH_GRANT_O
DATABASE_EXPORT/SCHEMA/GRANT
DATABASE_EXPORT/SCHEMA/GRANT/PROCOBJ_GRANT Schema procedural object grants in the selected schemas
DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
DATABASE_EXPORT/SCHEMA/INDEXTYPE Indextypes and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/INDEXTYPE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/INDEXTYPE/COMMENT
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEM
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEM
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_
DATABASE_EXPORT/SCHEMA/INDEXTYPE/INDEXTYPE
DATABASE_EXPORT/SCHEMA/JAVA_CLASS Java classes and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHE
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHE
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/OWNER_GRAN
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/OWNER_GRAN
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT
DATABASE_EXPORT/SCHEMA/JAVA_CLASS/JAVA_CLASS
DATABASE_EXPORT/SCHEMA/JAVA_OBJNUM
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE Java resources and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/CROSS_S
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/CROSS_S
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/OWNER_G
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/OWNER_G
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/WITH_GR
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/WITH_GR
DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/JAVA_RESOURCE
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE Java sources and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCH
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCH
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRA
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRA
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/WITH_GRAN
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/WITH_GRAN
DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/JAVA_SOURCE
DATABASE_EXPORT/SCHEMA/JOB Jobs
DATABASE_EXPORT/SCHEMA/LIBRARY External procedure libraries and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/LIBRARY/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA/
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/OWNER_GRANT/O
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/WITH_GRANT_OP
DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/WITH_GRANT_OP
DATABASE_EXPORT/SCHEMA/LIBRARY/LIBRARY
DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW Materialized views
DATABASE_EXPORT/SCHEMA/OPERATOR Operators and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/OPERATOR/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/OPERATOR/COMMENT
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/OWNER_GRANT/
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/WITH_GRANT_O
DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/WITH_GRANT_O
DATABASE_EXPORT/SCHEMA/OPERATOR/OPERATOR
DATABASE_EXPORT/SCHEMA/PACKAGE
DATABASE_EXPORT/SCHEMA/PACKAGE Packages (both specification and body) and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/PACKAGE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES
DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE
DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACK Package bodies
DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE
DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PAC
DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PAC Recompile package specifications
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA/
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/O
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/WITH_GRANT_OP
DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/WITH_GRANT_OP
DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_OBJNUM
DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC Package specifications
DATABASE_EXPORT/SCHEMA/PASSWORD_HISTORY Password histories for database users
DATABASE_EXPORT/SCHEMA/POST_SCHEMA Post-schema procedural actions and objects and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/POST_SCHEMA/GRANT
DATABASE_EXPORT/SCHEMA/POST_SCHEMA/GRANT/PROCOBJ_G
DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ_AUDIT
DATABASE_EXPORT/SCHEMA/POST_SCHEMA/SCHEMA_CALLOUT
DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA Schema procedural actions in the selected schemas
DATABASE_EXPORT/SCHEMA/PROCEDURE
DATABASE_EXPORT/SCHEMA/PROCEDURE Procedures and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE Recompile procedures
DATABASE_EXPORT/SCHEMA/PROCEDURE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/CROSS_SCHEM
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/CROSS_SCHEM
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/WITH_GRANT_
DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/WITH_GRANT_
DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
DATABASE_EXPORT/SCHEMA/PROCOBJ Procedural objects in the selected schemas
DATABASE_EXPORT/SCHEMA/PROCOBJ_AUDIT Schema procedural object audits in the selected schemas
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/FGA_POLICY
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_CONTEXT
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_GROUP
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_POLICY
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/R
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/R
DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM Public and private synonyms
DATABASE_EXPORT/SCHEMA/REFRESH_GROUP Refresh groups
DATABASE_EXPORT/SCHEMA/ROLE_GRANT Role grants to users in the database
DATABASE_EXPORT/SCHEMA/SCHEMA_CALLOUT Schema callouts in the selected schemas
DATABASE_EXPORT/SCHEMA/SEQUENCE Sequences and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/SEQUENCE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/WITH_GRANT_O
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/WITH_GRANT_O
DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
DATABASE_EXPORT/SCHEMA/SYNONYM
DATABASE_EXPORT/SCHEMA/SYNONYM/FGA_POLICY
DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_CONTEXT
DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_GROUP
DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_POLICY
DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_POLICY/RLS_POLI
DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_POLICY/RLS_POLI
DATABASE_EXPORT/SCHEMA/TABLE Tables and their dependent objects
DATABASE_EXPORT/SCHEMA/TABLE
DATABASE_EXPORT/SCHEMA/TABLE/AUDIT_OBJ Object audits on the selected tables
DATABASE_EXPORT/SCHEMA/TABLE/COMMENT Table and column comments on the selected tables
DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT
DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT Constraints (including referential constraints)
DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTR Referential constraints
DATABASE_EXPORT/SCHEMA/TABLE/DEPTABLE_OBJNUM
DATABASE_EXPORT/SCHEMA/TABLE/FGA_POLICY Fine-grained auditing policies
DATABASE_EXPORT/SCHEMA/TABLE/GRANT Object grants on the selected tables
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OB
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJ Object grants on the selected tables
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTI
DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTI
DATABASE_EXPORT/SCHEMA/TABLE/INDEX Indexes
DATABASE_EXPORT/SCHEMA/TABLE/INDEX
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/IN
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/IN
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMIDX_OBJNUM
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDE
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDE
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS Precomputed statistics
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITM
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITM
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNC
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNC
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDE
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/TABLE
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/TABLE_DATA
DATABASE_EXPORT/SCHEMA/TABLE/INSTANCE_CALLOUT Instance callouts
DATABASE_EXPORT/SCHEMA/TABLE/MATERIALIZED_VIEW_LOG Materialized view logs
DATABASE_EXPORT/SCHEMA/TABLE/NTABLE_OBJNUM
DATABASE_EXPORT/SCHEMA/TABLE/POST_DATA_TABLE
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/GRANT
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/GRANT/P Grants on instance procedural objects
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/INSTANC
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEP Instance procedural objects
DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEP Audits on instance procedural objects
DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION Post-table actions
DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION Pre-table actions
DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE Instance procedural actions
DATABASE_EXPORT/SCHEMA/TABLE/RLS_CONTEXT Fine-grained access control contexts
DATABASE_EXPORT/SCHEMA/TABLE/RLS_GROUP Fine-grained access control policy groups
DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY
DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY/RLS_POLICY Fine-grained access control policies
DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY/RLS_POLICY
DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA Tablespace quota granted to users in the database
DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS
DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STAT
DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/USER_PREF_
DATABASE_EXPORT/SCHEMA/TABLE/TABLE
DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
DATABASE_EXPORT/SCHEMA/TABLE/TABLE_OBJNUM
DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER Triggers
DATABASE_EXPORT/SCHEMA/TYPE Types (both specification and body) and their dependent grants and audits
DATABASE_EXPORT/SCHEMA/TYPE
DATABASE_EXPORT/SCHEMA/TYPE/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/TYPE/GRANT
DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJ
DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJE
DATABASE_EXPORT/SCHEMA/TYPE/GRANT/WITH_GRANT_OPTIO
DATABASE_EXPORT/SCHEMA/TYPE/GRANT/WITH_GRANT_OPTIO
DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
DATABASE_EXPORT/SCHEMA/TYPE/SORT_TYPES
DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY Type bodies
DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC Type specifications
DATABASE_EXPORT/SCHEMA/USER User definitions
DATABASE_EXPORT/SCHEMA/VIEW Views and their dependent objects
DATABASE_EXPORT/SCHEMA/VIEW
DATABASE_EXPORT/SCHEMA/VIEW/AUDIT_OBJ
DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
DATABASE_EXPORT/SCHEMA/VIEW/CONSTRAINT
DATABASE_EXPORT/SCHEMA/VIEW/FGA_POLICY
DATABASE_EXPORT/SCHEMA/VIEW/GRANT
DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA
DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJ
DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT
DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJE
DATABASE_EXPORT/SCHEMA/VIEW/GRANT/WITH_GRANT_OPTIO
DATABASE_EXPORT/SCHEMA/VIEW/GRANT/WITH_GRANT_OPTIO
DATABASE_EXPORT/SCHEMA/VIEW/RLS_CONTEXT
DATABASE_EXPORT/SCHEMA/VIEW/RLS_GROUP
DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY
DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY/RLS_POLICY Fine-grained access control policies
DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY/RLS_POLICY_
DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
DATABASE_EXPORT/SCHEMA/VIEW/VIEW
DATABASE_EXPORT/SCHEMA/VIEW/VIEW_OBJNUM
DATABASE_EXPORT/SCHEMA/XMLSCHEMA Xmlschemas
DATABASE_EXPORT/SCHEMA/XMLSCHEMA/EXP_XMLSCHEMA
DATABASE_EXPORT/SYSTEM_PROCOBJACT System procedural actions and objects and their dependent grants and audits
DATABASE_EXPORT/SYSTEM_PROCOBJACT/GRANT
DATABASE_EXPORT/SYSTEM_PROCOBJACT/GRANT/PROCOBJ_GR
DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTI Post-system procedural actions
DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTI
DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIO Pre-system procedural actions
DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIO
DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ_AUDIT
DATABASE_EXPORT/SYS_USER
DATABASE_EXPORT/SYS_USER/USER
DATABASE_EXPORT/TABLESPACE Tablespace definitions
DATABASE_EXPORT/TRUSTED_DB_LINK
DB_LINK Private and public database links
DEFAULT_ROLE Default roles granted to users in the database
DEPTABLE_OBJNUM
DIMENSION Dimensions
DIRECTORY
DIRECTORY Directories and their dependent grants and audits
DIRECTORY/AUDIT_OBJ
DIRECTORY/DIRECTORY Directories and their dependent grants and audits
DIRECTORY/GRANT
DIRECTORY/GRANT/CROSS_SCHEMA
DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT
DIRECTORY/GRANT/OWNER_GRANT
DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
DIRECTORY/GRANT/WITH_GRANT_OPTION
DIRECTORY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
DOMAIN_INDEX
DOMAIN_INDEX/INDEX
DOMIDX_OBJNUM
DVPS_COMMAND_RULE Database Vault Command Rule definitions
DVPS_COMMAND_RULE_GROUP Database Vault Command Rule-based security policy definitions
DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE Database Vault Command Rule definitions
DVPS_COMMAND_RULE_GROUP/DVPS_ROLE Database Vault Role definitions
DVPS_COMMAND_RULE_GROUP/DVPS_RULE Database Vault Rule definitions
DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET Database Vault Rule Set definitions
DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_MEMBERSHIP Database Vault Rules in a Rule Set definitions
DVPS_DROP_IMPORT_STAGING_REALM Delete the Database Vault Import Staging Realm definitions
DVPS_FACTOR Database Vault Factor definitions
DVPS_FACTOR_GROUP Database Vault Factor definitions
DVPS_FACTOR_GROUP/DVPS_FACTOR Database Vault Factor definitions
DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK Database Vault Factor Link definitions
DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE Database Vault Factor Type definitions
DVPS_FACTOR_GROUP/DVPS_IDENTITY Database Vault Identity definitions
DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP Database Vault Identity Map definitions
DVPS_FACTOR_LINK Database Vault Factor Link definitions
DVPS_FACTOR_TYPE Database Vault Factor Type definitions
DVPS_IDENTITY Database Vault Identity definitions
DVPS_IDENTITY_MAP Database Vault Identity Map definitions
DVPS_IMPORT_STAGING_REALM Database Vault Import Staging Realm definitions
DVPS_POLICY Database Vault security policies
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP Database Vault Command Rule-based security policy definitions
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_R Database Vault Command Rule definitions
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_ROLE Database Vault Role definitions
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE Database Vault Rule definitions
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET Database Vault Rule Set definitions
DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_ Database Vault Rules in a Rule Set definitions
DVPS_POLICY/DVPS_DROP_IMPORT_STAGING_REALM Delete the Database Vault Import Staging Realm definitions
DVPS_POLICY/DVPS_FACTOR_GROUP Database Vault Factor definitions
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR Database Vault Factor definitions
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK Database Vault Factor Link definitions
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE Database Vault Factor Type definitions
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY Database Vault Identity definitions
DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP Database Vault Identity Map definitions
DVPS_POLICY/DVPS_REALM_GROUP Database Vault Realm-based security policy definitions
DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM Database Vault Realm definitions
DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZAT Database Vault Realm Authorization definitions
DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP Database Vault Realm Membership definitions
DVPS_REALM Database Vault Realm definitions
DVPS_REALM_AUTHORIZATION Database Vault Realm Authorization definitions
DVPS_REALM_GROUP Database Vault Realm-based security policy definitions
DVPS_REALM_GROUP/DVPS_REALM Database Vault Realm definitions
DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZATION Database Vault Realm Authorization definitions
DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP Database Vault Realm Membership definitions
DVPS_REALM_MEMBERSHIP Database Vault Realm Membership definitions
DVPS_ROLE Database Vault Role definitions
DVPS_RULE Database Vault Rule definitions
DVPS_RULE_SET Database Vault Rule Set definitions
DVPS_RULE_SET_MEMBERSHIP Database Vault Rules in a Rule Set definitions
DVPS_STAGING_REALM_MEMBERSHIP Database Vault Import Staging Realm Membership
EARLY
EARLY_OPTIONS
EARLY_OPTIONS/OPTION_OBJNUM
EARLY_OPTIONS/OPTION_PACKAGE
EARLY_OPTIONS/OPTION_PACKAGE/OPTION_OBJNUM
EARLY_OPTIONS/OPTION_PACKAGE/PACKAGE_BODY
EARLY_OPTIONS/OPTION_PACKAGE/PACKAGE_SPEC
EARLY_OPTIONS/OPTION_TYPE
EARLY_OPTIONS/OPTION_TYPE/OPTION_OBJNUM
EARLY_OPTIONS/OPTION_TYPE/SORT_TYPES
EARLY_OPTIONS/OPTION_TYPE/TABTYPE_OBJNUM
EARLY_OPTIONS/OPTION_TYPE/TYPE_BODY Type bodies
EARLY_OPTIONS/OPTION_TYPE/TYPE_SPEC
EARLY_OPTIONS/POST_DATA_TABLE
EARLY_OPTIONS/PROCEDURE
EARLY_OPTIONS/TABLE
EARLY_OPTIONS/TABLE_DATA
EARLY_OPTIONS/VIEWS_AS_TABLES
EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
EARLY_OPTIONS/VIEWS_AS_TABLES/VAT_OBJNUM
EARLY_OPTIONS_WITH_DEP
EARLY_OPTIONS_WITH_DEP/AUDIT_OBJ Object audits on the selected tables
EARLY_OPTIONS_WITH_DEP/COMMENT Table and column comments on the selected tables
EARLY_OPTIONS_WITH_DEP/CONSTRAINT
EARLY_OPTIONS_WITH_DEP/FGA_POLICY Fine-grained auditing policies
EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX
EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX
EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX_STAT
EARLY_OPTIONS_WITH_DEP/GRANT Object grants on the selected tables
EARLY_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA
EARLY_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA/OBJECT_G
EARLY_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT
EARLY_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT/OBJECT_GR Object grants on the selected tables
EARLY_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION
EARLY_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION/OBJ
EARLY_OPTIONS_WITH_DEP/INDEX
EARLY_OPTIONS_WITH_DEP/INDEX_STATISTICS
EARLY_OPTIONS_WITH_DEP/OPTION_OBJNUM
EARLY_OPTIONS_WITH_DEP/POST_DATA_TABLE
EARLY_OPTIONS_WITH_DEP/REF_CONSTRAINT
EARLY_OPTIONS_WITH_DEP/RLS_CONTEXT Fine-grained access control contexts
EARLY_OPTIONS_WITH_DEP/RLS_GROUP Fine-grained access control policy groups
EARLY_OPTIONS_WITH_DEP/RLS_POLICY Fine-grained access control policies
EARLY_OPTIONS_WITH_DEP/RLS_POLICY_OBJNUM
EARLY_OPTIONS_WITH_DEP/TABLE
EARLY_OPTIONS_WITH_DEP/TABLE_DATA
EARLY_OPTIONS_WITH_DEP/TRIGGER
EARLY/PLUGTS_TABLESPACE
EARLY_POST_INSTANCE_IMPCALLOUT
EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
END_PLUGTS_BLK Post-import plugts anonymous block
EVENT
EVENT/TRIGGER
EXP_XMLSCHEMA
FGA_POLICY Fine-grained auditing policies
FGA_POLICY
FINAL_POST_INSTANCE_IMPCALLOUT
FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
FULL
FULL/PLUGTS_TABLESPACE
FUNCTION
FUNCTION Functions and their dependent grants and audits
FUNCTIONAL_INDEX
FUNCTIONAL_INDEX/INDEX
FUNCTIONAL_INDEX/INDEX_STATISTICS
FUNCTION/ALTER_FUNCTION Recompile functions
FUNCTION/AUDIT_OBJ
FUNCTION/FUNCTION
FUNCTION/GRANT
FUNCTION/GRANT/CROSS_SCHEMA
FUNCTION/GRANT/CROSS_SCHEMA/OBJECT_GRANT
FUNCTION/GRANT/OWNER_GRANT
FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
FUNCTION/GRANT/WITH_GRANT_OPTION
FUNCTION/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
GRANT
GRANT Object grants on the selected tables
GRANT/CROSS_SCHEMA
GRANT/CROSS_SCHEMA/OBJECT_GRANT
GRANT/OWNER_GRANT
GRANT/OWNER_GRANT/OBJECT_GRANT
GRANT/OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
GRANT/PROCOBJ_GRANT
GRANT/PROCOBJ_GRANT Schema procedural object grants in the selected schemas
GRANT/SYSTEM_GRANT
GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT Procedural system privilege grants
GRANT/WITH_GRANT_OPTION
GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
INC_TYPE
INDEX
INDEX Indexes
INDEX/BITMAP_INDEX
INDEX/BITMAP_INDEX/INDEX
INDEX/DOMAIN_INDEX
INDEX/DOMAIN_INDEX/INDEX
INDEX/DOMIDX_OBJNUM
INDEX/FUNCTIONAL_INDEX
INDEX/FUNCTIONAL_INDEX/INDEX
INDEX/INDEX
INDEX/STATISTICS Precomputed statistics
INDEX/STATISTICS
INDEX_STATISTICS
INDEX/STATISTICS/BITMAP_INDEX
INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
INDEX/STATISTICS/FUNCTIONAL_INDEX
INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
INDEX/STATISTICS/INDEX_STATISTICS
INDEX/TABLE
INDEX/TABLE_DATA
INDEXTYPE
INDEXTYPE Indextypes and their dependent grants and audits
INDEXTYPE/AUDIT_OBJ
INDEXTYPE/COMMENT
INDEXTYPE/GRANT
INDEXTYPE/GRANT/CROSS_SCHEMA
INDEXTYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
INDEXTYPE/GRANT/OWNER_GRANT
INDEXTYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
INDEXTYPE/GRANT/WITH_GRANT_OPTION
INDEXTYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
INDEXTYPE/INDEXTYPE
INSTANCE_CALLOUT Instance callouts
INSTANCE_CALLOUT
JAVA_CLASS Java classes and their dependent grants and audits
JAVA_CLASS
JAVA_CLASS/AUDIT_OBJ
JAVA_CLASS/GRANT
JAVA_CLASS/GRANT/CROSS_SCHEMA
JAVA_CLASS/GRANT/CROSS_SCHEMA/OBJECT_GRANT
JAVA_CLASS/GRANT/OWNER_GRANT
JAVA_CLASS/GRANT/OWNER_GRANT/OBJECT_GRANT
JAVA_CLASS/GRANT/WITH_GRANT_OPTION
JAVA_CLASS/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
JAVA_CLASS/JAVA_CLASS
JAVA_OBJNUM
JAVA_RESOURCE
JAVA_RESOURCE Java resources and their dependent grants and audits
JAVA_RESOURCE/AUDIT_OBJ
JAVA_RESOURCE/GRANT
JAVA_RESOURCE/GRANT/CROSS_SCHEMA
JAVA_RESOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
JAVA_RESOURCE/GRANT/OWNER_GRANT
JAVA_RESOURCE/GRANT/OWNER_GRANT/OBJECT_GRANT
JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION
JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
JAVA_RESOURCE/JAVA_RESOURCE
JAVA_SOURCE
JAVA_SOURCE Java sources and their dependent grants and audits
JAVA_SOURCE/AUDIT_OBJ
JAVA_SOURCE/GRANT
JAVA_SOURCE/GRANT/CROSS_SCHEMA
JAVA_SOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
JAVA_SOURCE/GRANT/OWNER_GRANT
JAVA_SOURCE/GRANT/OWNER_GRANT/OBJECT_GRANT
JAVA_SOURCE/GRANT/WITH_GRANT_OPTION
JAVA_SOURCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
JAVA_SOURCE/JAVA_SOURCE
JOB Jobs
LIBRARY External procedure libraries and their dependent grants and audits
LIBRARY
LIBRARY/AUDIT_OBJ
LIBRARY/GRANT
LIBRARY/GRANT/CROSS_SCHEMA
LIBRARY/GRANT/CROSS_SCHEMA/OBJECT_GRANT
LIBRARY/GRANT/OWNER_GRANT
LIBRARY/GRANT/OWNER_GRANT/OBJECT_GRANT
LIBRARY/GRANT/WITH_GRANT_OPTION
LIBRARY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
LIBRARY/LIBRARY
MARKER
MATERIALIZED_VIEW Materialized views
MATERIALIZED_VIEW_LOG Materialized view logs
NORMAL_OPTIONS
NORMAL_OPTIONS/OPTION_OBJNUM
NORMAL_OPTIONS/OPTION_PACKAGE
NORMAL_OPTIONS/OPTION_PACKAGE/OPTION_OBJNUM
NORMAL_OPTIONS/OPTION_PACKAGE/PACKAGE_BODY
NORMAL_OPTIONS/OPTION_PACKAGE/PACKAGE_SPEC
NORMAL_OPTIONS/OPTION_TYPE
NORMAL_OPTIONS/OPTION_TYPE/OPTION_OBJNUM
NORMAL_OPTIONS/OPTION_TYPE/SORT_TYPES
NORMAL_OPTIONS/OPTION_TYPE/TABTYPE_OBJNUM
NORMAL_OPTIONS/OPTION_TYPE/TYPE_BODY Type bodies
NORMAL_OPTIONS/OPTION_TYPE/TYPE_SPEC
NORMAL_OPTIONS/POST_DATA_TABLE
NORMAL_OPTIONS/PROCEDURE
NORMAL_OPTIONS/TABLE
NORMAL_OPTIONS/TABLE_DATA
NORMAL_OPTIONS/VIEWS_AS_TABLES
NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
NORMAL_OPTIONS/VIEWS_AS_TABLES/VAT_OBJNUM
NORMAL_OPTIONS_WITH_DEP
NORMAL_OPTIONS_WITH_DEP/AUDIT_OBJ Object audits on the selected tables
NORMAL_OPTIONS_WITH_DEP/COMMENT Table and column comments on the selected tables
NORMAL_OPTIONS_WITH_DEP/CONSTRAINT
NORMAL_OPTIONS_WITH_DEP/FGA_POLICY Fine-grained auditing policies
NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX
NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX
NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX_STA
NORMAL_OPTIONS_WITH_DEP/GRANT Object grants on the selected tables
NORMAL_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA
NORMAL_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA/OBJECT_
NORMAL_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT
NORMAL_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT/OBJECT_G Object grants on the selected tables
NORMAL_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION
NORMAL_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION/OB
NORMAL_OPTIONS_WITH_DEP/INDEX
NORMAL_OPTIONS_WITH_DEP/INDEX_STATISTICS
NORMAL_OPTIONS_WITH_DEP/OPTION_OBJNUM
NORMAL_OPTIONS_WITH_DEP/POST_DATA_TABLE
NORMAL_OPTIONS_WITH_DEP/REF_CONSTRAINT
NORMAL_OPTIONS_WITH_DEP/RLS_CONTEXT Fine-grained access control contexts
NORMAL_OPTIONS_WITH_DEP/RLS_GROUP Fine-grained access control policy groups
NORMAL_OPTIONS_WITH_DEP/RLS_POLICY Fine-grained access control policies
NORMAL_OPTIONS_WITH_DEP/RLS_POLICY_OBJNUM
NORMAL_OPTIONS_WITH_DEP/TABLE
NORMAL_OPTIONS_WITH_DEP/TABLE_DATA
NORMAL_OPTIONS_WITH_DEP/TRIGGER
NORMAL_POST_INSTANCE_IMPCALLOU
NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
NTABLE_OBJNUM
OBJECT_GRANT
OBJECT_GRANT Object grants on the selected tables
OPERATOR Operators and their dependent grants and audits
OPERATOR
OPERATOR/AUDIT_OBJ
OPERATOR/COMMENT
OPERATOR/GRANT
OPERATOR/GRANT/CROSS_SCHEMA
OPERATOR/GRANT/CROSS_SCHEMA/OBJECT_GRANT
OPERATOR/GRANT/OWNER_GRANT
OPERATOR/GRANT/OWNER_GRANT/OBJECT_GRANT
OPERATOR/GRANT/WITH_GRANT_OPTION
OPERATOR/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
OPERATOR/OPERATOR
OPTION_OBJNUM
OPTION_PACKAGE
OPTION_PACKAGE/OPTION_OBJNUM
OPTION_PACKAGE/PACKAGE_BODY
OPTION_PACKAGE/PACKAGE_SPEC
OPTION_TYPE
OPTION_TYPE/OPTION_OBJNUM
OPTION_TYPE/SORT_TYPES
OPTION_TYPE/TABTYPE_OBJNUM
OPTION_TYPE/TYPE_BODY Type bodies
OPTION_TYPE/TYPE_SPEC
OWNER_GRANT
OWNER_GRANT/OBJECT_GRANT
OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
PACKAGE Packages (both specification and body) and their dependent grants and audits
PACKAGE
PACKAGE/AUDIT_OBJ
PACKAGE_BODIES
PACKAGE_BODIES/PACKAGE
PACKAGE_BODIES/PACKAGE/PACKAGE_BODY Package bodies
PACKAGE_BODY Package bodies
PACKAGE_BODY
PACKAGE/COMPILE_PACKAGE
PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC
PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE Recompile package specifications
PACKAGE/GRANT
PACKAGE/GRANT/CROSS_SCHEMA
PACKAGE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
PACKAGE/GRANT/OWNER_GRANT
PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
PACKAGE/GRANT/WITH_GRANT_OPTION
PACKAGE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
PACKAGE_OBJNUM
PACKAGE/PACKAGE_BODY Package bodies
PACKAGE/PACKAGE_OBJNUM
PACKAGE/PACKAGE_SPEC Package specifications
PACKAGE_SPEC
PACKAGE_SPEC Package specifications
PACKAGE_SPEC/ALTER_PACKAGE_SPEC Recompile package specifications
PASSWORD_HISTORY Password histories for database users
PASSWORD_VERIFY_FUNCTION The password complexity verification function
PLUGTS_BEGIN Call dbms_plugts.beginExport
PLUGTS_BLK Pre-import anonymous block
PLUGTS_CHECKPL Call dbms_plugts.checkPluggable
PLUGTS_EARLY_TABLESPACE
PLUGTS_FULL
PLUGTS_FULL/EARLY
PLUGTS_FULL/EARLY/PLUGTS_TABLESPACE
PLUGTS_FULL/FULL
PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
PLUGTS_FULL/PLUGTS_BEGIN Call dbms_plugts.beginExport
PLUGTS_FULL/PLUGTS_BLK Pre-import anonymous block
PLUGTS_FULL/PLUGTS_CHECKPL Call dbms_plugts.checkPluggable
PLUGTS_FULL/PLUGTS_EARLY_TABLESPACE
PLUGTS_FULL/PLUGTS_TSNAME_FULL
PLUGTS_FULL/TABLESPACE
PLUGTS_TABLESPACE
PLUGTS_TSNAME_FULL
POST_DATA_TABLE
POST_INSTANCE
POST_INSTANCE/GRANT
POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
POST_INSTANCE/INSTANCE_CALLOUT
POST_INSTANCE/PROCACT_INSTANCE
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_SCHEMA/GRANT
POST_SCHEMA/GRANT/PROCOBJ_GRANT
POST_SCHEMA/PROCACT_SCHEMA
POST_SCHEMA/PROCOBJ
POST_SCHEMA/PROCOBJ_AUDIT
POST_SCHEMA/SCHEMA_CALLOUT
POST_SYSTEM Post-system callouts
POST_SYSTEM_ACTIONS Post-system procedural actions
POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
POST_SYSTEM_IMPCALLOUT
POST_SYSTEM_IMPCALLOUT/MARKER
POST_SYSTEM/SYSTEM_CALLOUT
POST_TABLE_ACTION Post-table actions
PRE_INSTANCE_IMPCALLOUT
PRE_INSTANCE_IMPCALLOUT/MARKER
PRE_SYSTEM Pre-system callouts
PRE_SYSTEM_ACTIONS Pre-system procedural actions
PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
PRE_SYSTEM_IMPCALLOUT
PRE_SYSTEM_IMPCALLOUT/MARKER
PRE_SYSTEM/SYSTEM_CALLOUT System callouts
PRE_TABLE_ACTION Pre-table actions
PROCACT_INSTANCE Instance procedural actions
PROCACT_INSTANCE
PROCACT_SCHEMA
PROCACT_SCHEMA Schema procedural actions in the selected schemas
PROCACT_SYSTEM
PROCDEPOBJ Instance procedural objects
PROCDEPOBJ_AUDIT Audits on instance procedural objects
PROCDEPOBJ_GRANT Grants on instance procedural objects
PROCEDURE Procedures and their dependent grants and audits
PROCEDURE
PROCEDURE/ALTER_PROCEDURE Recompile procedures
PROCEDURE/AUDIT_OBJ
PROCEDURE/GRANT
PROCEDURE/GRANT/CROSS_SCHEMA
PROCEDURE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
PROCEDURE/GRANT/OWNER_GRANT
PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
PROCEDURE/GRANT/WITH_GRANT_OPTION
PROCEDURE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
PROCEDURE/PROCEDURE
PROCOBJ
PROCOBJ Procedural objects in the selected schemas
PROCOBJ_AUDIT
PROCOBJ_AUDIT Schema procedural object audits in the selected schemas
PROCOBJ_GRANT Schema procedural object grants in the selected schemas
PROCOBJ_GRANT
PROCOBJ_OBJNUM
PROC_SYSTEM_GRANT Procedural system privilege grants
PROFILE Profiles
PROXY Proxy authentications
PUBLIC_SYNONYM
PUBLIC_SYNONYM/FGA_POLICY
PUBLIC_SYNONYM/RLS_CONTEXT
PUBLIC_SYNONYM/RLS_GROUP
PUBLIC_SYNONYM/RLS_POLICY
PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY
PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM
PUBLIC_SYNONYM/SYNONYM Public and private synonyms
REF_CONSTRAINT
REF_CONSTRAINT Referential constraints
REFRESH_GROUP Refresh groups
RESOURCE_COST Resource cost information
RLS_CONTEXT Fine-grained access control contexts
RLS_CONTEXT
RLS_GROUP Fine-grained access control policy groups
RLS_GROUP
RLS_POLICY
RLS_POLICY Fine-grained access control policies
RLS_POLICY_OBJNUM
RLS_POLICY/RLS_POLICY Fine-grained access control policies
RLS_POLICY/RLS_POLICY
RLS_POLICY/RLS_POLICY_OBJNUM
ROLE Roles
ROLE_GRANT Role grants to users in the database
ROLLBACK_SEGMENT Rollback segments
SCHEMA
SCHEMA Pre-schema procedural actions and objects and their dependent grants and audits
SCHEMA Database schemas including related and dependent objects
SCHEMA/ASSOCIATION Statistics type associations
SCHEMA_CALLOUT Schema callouts in the selected schemas
SCHEMA_CALLOUT
SCHEMA/CLUSTER Clusters and their indexes
SCHEMA/CLUSTER/CLUSTER
SCHEMA/CLUSTER/INDEX
SCHEMA/DB_LINK Private and public database links
SCHEMA/DEFAULT_ROLE Default roles granted to users in the database
SCHEMA/DIMENSION Dimensions
SCHEMA/DVPS_STAGING_REALM_MEMBERSHIP Database Vault Import Staging Realm Membership
SCHEMA/EVENT
SCHEMA/EVENT/TRIGGER
SCHEMA/FUNCTION Functions and their dependent grants and audits
SCHEMA/FUNCTION
SCHEMA/FUNCTION/ALTER_FUNCTION Recompile functions
SCHEMA/FUNCTION/AUDIT_OBJ
SCHEMA/FUNCTION/FUNCTION
SCHEMA/FUNCTION/GRANT
SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA
SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/FUNCTION/GRANT/OWNER_GRANT
SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/FUNCTION/GRANT/WITH_GRANT_OPTION
SCHEMA/FUNCTION/GRANT/WITH_GRANT_OPTION/OBJECT_GRA
SCHEMA/GRANT
SCHEMA/GRANT/PROCOBJ_GRANT Schema procedural object grants in the selected schemas
SCHEMA/GRANT/SYSTEM_GRANT
SCHEMA/INDEXTYPE Indextypes and their dependent grants and audits
SCHEMA/INDEXTYPE/AUDIT_OBJ
SCHEMA/INDEXTYPE/COMMENT
SCHEMA/INDEXTYPE/GRANT
SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEMA
SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT
SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_OPTION
SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GR
SCHEMA/INDEXTYPE/INDEXTYPE
SCHEMA/JAVA_CLASS Java classes and their dependent grants and audits
SCHEMA/JAVA_CLASS/AUDIT_OBJ
SCHEMA/JAVA_CLASS/GRANT
SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHEMA
SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/JAVA_CLASS/GRANT/OWNER_GRANT
SCHEMA/JAVA_CLASS/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT_OPTION
SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT_OPTION/OBJECT_G
SCHEMA/JAVA_CLASS/JAVA_CLASS
SCHEMA/JAVA_OBJNUM
SCHEMA/JAVA_RESOURCE Java resources and their dependent grants and audits
SCHEMA/JAVA_RESOURCE/AUDIT_OBJ
SCHEMA/JAVA_RESOURCE/GRANT
SCHEMA/JAVA_RESOURCE/GRANT/CROSS_SCHEMA
SCHEMA/JAVA_RESOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRA
SCHEMA/JAVA_RESOURCE/GRANT/OWNER_GRANT
SCHEMA/JAVA_RESOURCE/GRANT/OWNER_GRANT/OBJECT_GRAN
SCHEMA/JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION
SCHEMA/JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION/OBJEC
SCHEMA/JAVA_RESOURCE/JAVA_RESOURCE
SCHEMA/JAVA_SOURCE Java sources and their dependent grants and audits
SCHEMA/JAVA_SOURCE/AUDIT_OBJ
SCHEMA/JAVA_SOURCE/GRANT
SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCHEMA
SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRANT
SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/JAVA_SOURCE/GRANT/WITH_GRANT_OPTION
SCHEMA/JAVA_SOURCE/GRANT/WITH_GRANT_OPTION/OBJECT_
SCHEMA/JAVA_SOURCE/JAVA_SOURCE
SCHEMA/JOB Jobs
SCHEMA/LIBRARY External procedure libraries and their dependent grants and audits
SCHEMA/LIBRARY/AUDIT_OBJ
SCHEMA/LIBRARY/GRANT
SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA
SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/LIBRARY/GRANT/OWNER_GRANT
SCHEMA/LIBRARY/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/LIBRARY/GRANT/WITH_GRANT_OPTION
SCHEMA/LIBRARY/GRANT/WITH_GRANT_OPTION/OBJECT_GRAN
SCHEMA/LIBRARY/LIBRARY
SCHEMA/MATERIALIZED_VIEW Materialized views
SCHEMA/OPERATOR Operators and their dependent grants and audits
SCHEMA/OPERATOR/AUDIT_OBJ
SCHEMA/OPERATOR/COMMENT
SCHEMA/OPERATOR/GRANT
SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA
SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/OPERATOR/GRANT/OWNER_GRANT
SCHEMA/OPERATOR/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/OPERATOR/GRANT/WITH_GRANT_OPTION
SCHEMA/OPERATOR/GRANT/WITH_GRANT_OPTION/OBJECT_GRA
SCHEMA/OPERATOR/OPERATOR
SCHEMA/PACKAGE Packages (both specification and body) and their dependent grants and audits
SCHEMA/PACKAGE
SCHEMA/PACKAGE/AUDIT_OBJ
SCHEMA/PACKAGE_BODIES
SCHEMA/PACKAGE_BODIES/PACKAGE
SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY Package bodies
SCHEMA/PACKAGE/COMPILE_PACKAGE
SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC
SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_ Recompile package specifications
SCHEMA/PACKAGE/GRANT
SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA
SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/PACKAGE/GRANT/OWNER_GRANT
SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/PACKAGE/GRANT/WITH_GRANT_OPTION
SCHEMA/PACKAGE/GRANT/WITH_GRANT_OPTION/OBJECT_GRAN
SCHEMA/PACKAGE/PACKAGE_OBJNUM
SCHEMA/PACKAGE/PACKAGE_SPEC Package specifications
SCHEMA/PASSWORD_HISTORY Password histories for database users
SCHEMA/POST_SCHEMA Post-schema procedural actions and objects and their dependent grants and audits
SCHEMA/POST_SCHEMA/GRANT
SCHEMA/POST_SCHEMA/GRANT/PROCOBJ_GRANT
SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
SCHEMA/POST_SCHEMA/PROCOBJ
SCHEMA/POST_SCHEMA/PROCOBJ_AUDIT
SCHEMA/POST_SCHEMA/SCHEMA_CALLOUT
SCHEMA/PROCACT_SCHEMA Schema procedural actions in the selected schemas
SCHEMA/PROCEDURE
SCHEMA/PROCEDURE Procedures and their dependent grants and audits
SCHEMA/PROCEDURE/ALTER_PROCEDURE Recompile procedures
SCHEMA/PROCEDURE/AUDIT_OBJ
SCHEMA/PROCEDURE/GRANT
SCHEMA/PROCEDURE/GRANT/CROSS_SCHEMA
SCHEMA/PROCEDURE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/PROCEDURE/GRANT/OWNER_GRANT
SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/PROCEDURE/GRANT/WITH_GRANT_OPTION
SCHEMA/PROCEDURE/GRANT/WITH_GRANT_OPTION/OBJECT_GR
SCHEMA/PROCEDURE/PROCEDURE
SCHEMA/PROCOBJ Procedural objects in the selected schemas
SCHEMA/PROCOBJ_AUDIT Schema procedural object audits in the selected schemas
SCHEMA/PUBLIC_SYNONYM
SCHEMA/PUBLIC_SYNONYM/FGA_POLICY
SCHEMA/PUBLIC_SYNONYM/RLS_CONTEXT
SCHEMA/PUBLIC_SYNONYM/RLS_GROUP
SCHEMA/PUBLIC_SYNONYM/RLS_POLICY
SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY
SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM
SCHEMA/PUBLIC_SYNONYM/SYNONYM Public and private synonyms
SCHEMA/REFRESH_GROUP Refresh groups
SCHEMA/ROLE_GRANT Role grants to users in the database
SCHEMA/SCHEMA_CALLOUT Schema callouts in the selected schemas
SCHEMA/SEQUENCE Sequences and their dependent grants and audits
SCHEMA/SEQUENCE/AUDIT_OBJ
SCHEMA/SEQUENCE/GRANT
SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA
SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/SEQUENCE/GRANT/OWNER_GRANT
SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/SEQUENCE/GRANT/WITH_GRANT_OPTION
SCHEMA/SEQUENCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRA
SCHEMA/SEQUENCE/SEQUENCE
SCHEMA/SYNONYM
SCHEMA/SYNONYM/FGA_POLICY
SCHEMA/SYNONYM/RLS_CONTEXT
SCHEMA/SYNONYM/RLS_GROUP
SCHEMA/SYNONYM/RLS_POLICY
SCHEMA/SYNONYM/RLS_POLICY/RLS_POLICY
SCHEMA/SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM
SCHEMA/TABLE Tables and their dependent objects
SCHEMA/TABLE
SCHEMA/TABLE/AUDIT_OBJ Object audits on the selected tables
SCHEMA/TABLE/COMMENT Table and column comments on the selected tables
SCHEMA/TABLE/CONSTRAINT
SCHEMA/TABLE/CONSTRAINT Constraints (including referential constraints)
SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT Referential constraints
SCHEMA/TABLE/DEPTABLE_OBJNUM
SCHEMA/TABLE/FGA_POLICY Fine-grained auditing policies
SCHEMA/TABLE/GRANT Object grants on the selected tables
SCHEMA/TABLE/GRANT/CROSS_SCHEMA
SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/TABLE/GRANT/OWNER_GRANT
SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION
SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
SCHEMA/TABLE/INDEX
SCHEMA/TABLE/INDEX Indexes
SCHEMA/TABLE/INDEX/BITMAP_INDEX
SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
SCHEMA/TABLE/INDEX/DOMAIN_INDEX
SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
SCHEMA/TABLE/INDEX/DOMIDX_OBJNUM
SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX
SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
SCHEMA/TABLE/INDEX/INDEX
SCHEMA/TABLE/INDEX/STATISTICS
SCHEMA/TABLE/INDEX/STATISTICS Precomputed statistics
SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX
SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_S
SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX
SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/IND
SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
SCHEMA/TABLE/INDEX/TABLE
SCHEMA/TABLE/INDEX/TABLE_DATA
SCHEMA/TABLE/INSTANCE_CALLOUT Instance callouts
SCHEMA/TABLE/MATERIALIZED_VIEW_LOG Materialized view logs
SCHEMA/TABLE/NTABLE_OBJNUM
SCHEMA/TABLE/POST_DATA_TABLE
SCHEMA/TABLE/POST_INSTANCE
SCHEMA/TABLE/POST_INSTANCE/GRANT
SCHEMA/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
SCHEMA/TABLE/POST_INSTANCE/INSTANCE_CALLOUT
SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ Instance procedural objects
SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT Audits on instance procedural objects
SCHEMA/TABLE/POST_TABLE_ACTION Post-table actions
SCHEMA/TABLE/PRE_TABLE_ACTION Pre-table actions
SCHEMA/TABLE/PROCACT_INSTANCE Instance procedural actions
SCHEMA/TABLE/RLS_CONTEXT Fine-grained access control contexts
SCHEMA/TABLE/RLS_GROUP Fine-grained access control policy groups
SCHEMA/TABLE/RLS_POLICY
SCHEMA/TABLE/RLS_POLICY/RLS_POLICY Fine-grained access control policies
SCHEMA/TABLE/RLS_POLICY/RLS_POLICY_OBJNUM
SCHEMA/TABLESPACE_QUOTA Tablespace quota granted to users in the database
SCHEMA/TABLE/STATISTICS
SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
SCHEMA/TABLE/STATISTICS/USER_PREF_STATISTICS
SCHEMA/TABLE/TABLE
SCHEMA/TABLE/TABLE_DATA
SCHEMA/TABLE/TABLE_OBJNUM
SCHEMA/TABLE/TRIGGER Triggers
SCHEMA/TYPE Types (both specification and body) and their dependent grants and audits
SCHEMA/TYPE
SCHEMA/TYPE/AUDIT_OBJ
SCHEMA/TYPE/GRANT
SCHEMA/TYPE/GRANT/CROSS_SCHEMA
SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/TYPE/GRANT/OWNER_GRANT
SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/TYPE/GRANT/WITH_GRANT_OPTION
SCHEMA/TYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
SCHEMA/TYPE/INC_TYPE
SCHEMA/TYPE/SORT_TYPES
SCHEMA/TYPE/TYPE_BODY Type bodies
SCHEMA/TYPE/TYPE_SPEC Type specifications
SCHEMA/USER User definitions
SCHEMA/VIEW Views and their dependent objects
SCHEMA/VIEW
SCHEMA/VIEW/AUDIT_OBJ
SCHEMA/VIEW/COMMENT
SCHEMA/VIEW/CONSTRAINT
SCHEMA/VIEW/FGA_POLICY
SCHEMA/VIEW/GRANT
SCHEMA/VIEW/GRANT/CROSS_SCHEMA
SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SCHEMA/VIEW/GRANT/OWNER_GRANT
SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
SCHEMA/VIEW/GRANT/WITH_GRANT_OPTION
SCHEMA/VIEW/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
SCHEMA/VIEW/RLS_CONTEXT
SCHEMA/VIEW/RLS_GROUP
SCHEMA/VIEW/RLS_POLICY
SCHEMA/VIEW/RLS_POLICY/RLS_POLICY Fine-grained access control policies
SCHEMA/VIEW/RLS_POLICY/RLS_POLICY_OBJNUM
SCHEMA/VIEW/TRIGGER
SCHEMA/VIEW/VIEW
SCHEMA/VIEW/VIEW_OBJNUM
SCHEMA/XMLSCHEMA Xmlschemas
SCHEMA/XMLSCHEMA/EXP_XMLSCHEMA
SEQUENCE Sequences and their dependent grants and audits
SEQUENCE
SEQUENCE/AUDIT_OBJ
SEQUENCE/GRANT
SEQUENCE/GRANT/CROSS_SCHEMA
SEQUENCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
SEQUENCE/GRANT/OWNER_GRANT
SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
SEQUENCE/GRANT/WITH_GRANT_OPTION
SEQUENCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
SEQUENCE/SEQUENCE
SORT_TYPES
STATISTICS
STATISTICS Precomputed statistics
STATISTICS/BITMAP_INDEX
STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
STATISTICS/FUNCTIONAL_INDEX
STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
STATISTICS/INDEX_STATISTICS
STATISTICS/TABLE_STATISTICS
STATISTICS/USER_PREF_STATISTICS
SYNONYM Public and private synonyms
SYNONYM
SYNONYM/FGA_POLICY
SYNONYM/RLS_CONTEXT
SYNONYM/RLS_GROUP
SYNONYM/RLS_POLICY
SYNONYM/RLS_POLICY/RLS_POLICY
SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM
SYSTEM_CALLOUT System callouts
SYSTEM_CALLOUT
SYSTEM_GRANT
SYSTEM_GRANT/PROC_SYSTEM_GRANT Procedural system privilege grants
SYSTEM_PROCOBJACT System procedural actions and objects and their dependent grants and audits
SYSTEM_PROCOBJACT/GRANT
SYSTEM_PROCOBJACT/GRANT/PROCOBJ_GRANT
SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS Post-system procedural actions
SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYST
SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS Pre-system procedural actions
SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTE
SYSTEM_PROCOBJACT/PROCOBJ
SYSTEM_PROCOBJACT/PROCOBJ_AUDIT
SYS_USER
SYS_USER/USER
TABLE
TABLE Tables and their dependent objects
TABLE/AUDIT_OBJ Object audits on the selected tables
TABLE/COMMENT Table and column comments on the selected tables
TABLE/CONSTRAINT
TABLE/CONSTRAINT Constraints (including referential constraints)
TABLE/CONSTRAINT/CONSTRAINT
TABLE/CONSTRAINT/REF_CONSTRAINT Referential constraints
TABLE_DATA
TABLE/DEPTABLE_OBJNUM
TABLE/FGA_POLICY Fine-grained auditing policies
TABLE/GRANT Object grants on the selected tables
TABLE/GRANT/CROSS_SCHEMA
TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
TABLE/GRANT/OWNER_GRANT
TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Object grants on the selected tables
TABLE/GRANT/WITH_GRANT_OPTION
TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
TABLE/INDEX Indexes
TABLE/INDEX
TABLE/INDEX/BITMAP_INDEX
TABLE/INDEX/BITMAP_INDEX/INDEX
TABLE/INDEX/DOMAIN_INDEX
TABLE/INDEX/DOMAIN_INDEX/INDEX
TABLE/INDEX/DOMIDX_OBJNUM
TABLE/INDEX/FUNCTIONAL_INDEX
TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
TABLE/INDEX/INDEX
TABLE/INDEX/STATISTICS
TABLE/INDEX/STATISTICS Precomputed statistics
TABLE/INDEX/STATISTICS/BITMAP_INDEX
TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTI
TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX
TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STAT
TABLE/INDEX/STATISTICS/INDEX_STATISTICS
TABLE/INDEX/TABLE
TABLE/INDEX/TABLE_DATA
TABLE/INSTANCE_CALLOUT Instance callouts
TABLE/MATERIALIZED_VIEW_LOG Materialized view logs
TABLE/NTABLE_OBJNUM
TABLE_OBJNUM
TABLE/POST_DATA_TABLE
TABLE/POST_INSTANCE
TABLE/POST_INSTANCE/GRANT
TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT Grants on instance procedural objects
TABLE/POST_INSTANCE/INSTANCE_CALLOUT
TABLE/POST_INSTANCE/PROCACT_INSTANCE
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
TABLE/RLS_POLICY/RLS_POLICY Fine-grained access control policies
TABLE/RLS_POLICY/RLS_POLICY_OBJNUM
TABLESPACE
TABLESPACE Tablespace definitions
TABLESPACE_QUOTA Tablespace quota granted to users in the database
TABLE/STATISTICS
TABLE_STATISTICS
TABLE/STATISTICS/TABLE_STATISTICS
TABLE/STATISTICS/USER_PREF_STATISTICS
TABLE/TABLE
TABLE/TABLE_DATA
TABLE/TABLE_OBJNUM
TABLE/TRIGGER Triggers
TABTYPE_OBJNUM
TRIGGER
TRIGGER Triggers
TRUSTED_DB_LINK
TYPE Types (both specification and body) and their dependent grants and audits
TYPE
TYPE/AUDIT_OBJ
TYPE_BODY Type bodies
TYPE/GRANT
TYPE/GRANT/CROSS_SCHEMA
TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
TYPE/GRANT/OWNER_GRANT
TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
TYPE/GRANT/WITH_GRANT_OPTION
TYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
TYPE/INC_TYPE
TYPE/SORT_TYPES
TYPE_SPEC
TYPE_SPEC Type specifications
TYPE/TYPE_BODY Type bodies
TYPE/TYPE_SPEC Type specifications
USER
USER User definitions
USER_PREF_STATISTICS
VAT_OBJNUM
VIEW Views and their dependent objects
VIEW
VIEW/AUDIT_OBJ
VIEW/COMMENT
VIEW/CONSTRAINT
VIEW/FGA_POLICY
VIEW/GRANT
VIEW/GRANT/CROSS_SCHEMA
VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT
VIEW/GRANT/OWNER_GRANT
VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
VIEW/GRANT/WITH_GRANT_OPTION
VIEW/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
VIEW_OBJNUM
VIEW/RLS_CONTEXT
VIEW/RLS_GROUP
VIEW/RLS_POLICY
VIEW/RLS_POLICY/RLS_POLICY Fine-grained access control policies
VIEW/RLS_POLICY/RLS_POLICY_OBJNUM
VIEWS_AS_TABLES
VIEWS_AS_TABLES/TABLE
VIEWS_AS_TABLES/TABLE_DATA
VIEWS_AS_TABLES/VAT_OBJNUM
VIEW/TRIGGER
VIEW/VIEW
VIEW/VIEW_OBJNUM
WITH_GRANT_OPTION
WITH_GRANT_OPTION/OBJECT_GRANT
XMLSCHEMA Xmlschemas
XMLSCHEMA/EXP_XMLSCHEMA
Posted by at No comments:
Labels: , , ,

Monday, August 4, 2014

who is locking my tables ?

SELECT owner || '.' || object_name obj,
         oracle_username || ' (' || s.status || ')' oruser,
         os_user_name osuser,
         machine computer,
         l.process unix,
         '''' || s.sid || ',' || s.serial# || '''' ss,
         r.name rs,
         TO_CHAR (s.logon_time, 'yyyy/mm/dd hh24:mi:ss') time
    FROM v$locked_object l,
         dba_objects o,
         v$session s,
         v$transaction t,
         v$rollname r
   WHERE     l.object_id = o.object_id
         AND s.sid = l.session_id
         AND s.taddr = t.addr
         AND t.xidusn = r.usn
ORDER BY obj,osuser, ss
Posted by at No comments:
Labels: ,

Sunday, July 13, 2014

Simple shell script to purge WRH\$_SQL_PLAN until a specified date and reclaim space on SYSAUX tablespace

nbparam=$#

 case $nbparam in
      0) echo "Usage = sh purge_sql_plan.sh <until_date>"
         exit 1;;
      *);;
   esac

 export date=$1

 sqlplus 'CONN_STRING' <<aa
set echo on timing on
DECLARE
   min_date   DATE;
BEGIN
   SELECT MIN (timestamp) INTO min_date FROM SYS.WRH\$_SQL_PLAN;

    WHILE min_date < TO_DATE ('$date', 'DD/MM/YYYY')
   LOOP
      DBMS_OUTPUT.put_line ('Date : ' || min_date);

       DELETE FROM SYS.WRH\$_SQL_PLAN
            WHERE timestamp <= min_date;

       COMMIT;
      min_date := min_date + 1;
   END LOOP;
END;
/

 ALTER TABLE SYS.WRH\$_SQL_PLAN move parallel tablespace sysaux;
ALTER TABLE SYS.WRH\$_SQL_PLAN noparallel;
alter index SYS.WRH\$_SQL_PLAN_PK rebuild parallel;
alter index SYS.WRH\$_SQL_PLAN_PK noparallel;

 exit;
aa

Read more »
Posted by at No comments:
Labels: , ,

Thursday, July 10, 2014

Best way to maximize cursor reuse in oracle

Reusing a cursor means compiling a SQL statement just once, but executing it more than once. When a SQL statement is compiled, the database checks the syntax and chooses a query path. By doing this only once, but executing this statement several times, you can obtain an improvement in performance.

It is good practice to limit the number of times a cursor has to be parsed the optimal number of parses is one, of course. One option to achieve this ideal would be to preparse every possible cursor your application might ever execute. That way, every cursor would already be waiting in the shared pool when your application starts up. However, this approach would be extremely difficult to maintain in a large application or in one that allows ad hoc queries. Thus, it is better to take the hit the first time a cursor executes and then ensure that it is reused whenever possible later on.
 Oracle uses a complex algorithm to decide whether a cursor that is about to be executed may reuse an already compiled version from the shared pool.

  • One of the best ways to take advantage of automatically reformatting cursors to promote reuse is to put them into PL/SQL.The PL/SQL compiler reformats the mismatched cursors, thus producing a single cursor in the shared pool. On the surface, this may seem to be a very small improvement, but implemented across an application, it can produce big performance gains because the shared pool latches have fewer cursors to keep track of.
  • PL/SQL can virtually eliminate all hard parses just by moving the cursors into a stored procedure.
  • The PL/SQL compiler promotes reuse by being more forgiving regarding the structure of cursors.
  • Once a cursor is compiled into a PL/SQL procedure, package, or function, it is automatically considered valid and parsed as long as the procedure, package, or function remains valid.
  • PL/SQL compiler makes some extra effort to facilitate cursor reuse by checking for small differences like extra whitespace, uppercase versus lowercase, and line breaks.
  • Another factor to consider when planning for cursor reuse is the use of literal values.
  • A setting is available for the CURSOR_SHARING parameter : FORCE. And it does just that force cursors to be shared strictly on the basis of the text they contain after translating literals into bind variables. This method blindly performs literal substitution and forces the CBO to create an execution plan based on it. This is not always optimal, because the CBO might make a better decision if it knew the explicit value.
Beyond matching the text of a cursor, there are several other factors influencing cursor reusefor example, optimizer statistics and Globalization Support (previously National Language Support, or NLS) setting mismatches. In such cases, it's not enough to simply match ASCII values.


Note: The cursor_sharing=similar option has been deprecated in Oracle 11g and will be removed in version 12 per MOSC Note 1169017.1
 References

  • http://docs.oracle.com/cd/E38689_01/pt853pbr0/eng/pt/tpcr/task_ReusingaCursor-c07aed.html
  • http://www.vsevolod.com/magz/ORplSQLl/0596005873/oracleplsqldba-chp-2-sect-1.html
  • Oracle PL/SQL for DBA By Arup Nanda, Steven Feuerstein
Posted by at No comments:
Labels: ,

Wednesday, July 2, 2014

Why you should use oracle advanced compression


  • Explosion in Data Volumes
  • As data volume expands performance often declines
  • Disk costs money
  • Transparent to applications, SQL, and PL/SQL
  • Use spare CPU cycles to decrease the bytes written and read
  • Transparent to applications, SQL, and PL/SQL
  • May improve performance by requiring the transfer of  fewer bytes from disk through the network, into the CPU,  to be stored in the buffer cache
  • Increase the amount of data stored on existing disk
  • Compression is performed at the block level
  • Data Guard Network Compression
  • Data Pump Compression
  • Fast RMAN Compression
  • OLTP Table Compression

References
  • http://www.morganslibrary.com/pres/ougf_advcomp_2009.pdf
Posted by at No comments:
Labels: , ,

Saturday, June 7, 2014

shell script to delete all not used oracle semaphores and shared memory

Here, save and try this script (kill_ipcs.sh) on your shell:
#!/bin/bash

ME=`whoami`

IPCS_S=`ipcs -s | egrep "0x[0-9a-f]+ [0-9]+" | grep $ME | cut -f2 -d" "`
IPCS_M=`ipcs -m | egrep "0x[0-9a-f]+ [0-9]+" | grep $ME | cut -f2 -d" "`
IPCS_Q=`ipcs -q | egrep "0x[0-9a-f]+ [0-9]+" | grep $ME | cut -f2 -d" "`


for id in $IPCS_M; do
  ipcrm -m $id;
done

for id in $IPCS_S; do
  ipcrm -s $id;
done

for id in $IPCS_Q; do
  ipcrm -q $id;
done
Posted by at No comments:
Labels: , ,
Subscribe to: Posts (Atom)