TABLE_NAME
ALL_ALL_TABLES
TAB_COMMENTSCOLUMN_NAME
Description of all object and relational tables accessible to the user
COL_COMMENTS
TABLESPACE_NAME
CLUSTER_NAME
IOT_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
BACKED_UP
NUM_ROWS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
AVG_SPACE_FREELIST_BLOCKS
NUM_FREELIST_BLOCKS
DEGREE
INSTANCES
CACHE
TABLE_LOCK
SAMPLE_SIZE
LAST_ANALYZED
PARTITIONED
IOT_TYPE
OBJECT_ID_TYPE
TABLE_TYPE_OWNER
TABLE_TYPE
TEMPORARY
SECONDARY
NESTED
BUFFER_POOL
ROW_MOVEMENT
GLOBAL_STATS
USER_STATS
DURATION
SKIP_CORRUPT
MONITORING
CLUSTER_OWNER
DEPENDENCIES
OWNER
TABLE_NAME
Name of the tablespace containing the table
Name of the cluster, if any, to which the table belongs
Name of the index-only table, if any, to which the overflow or mapping table entry belongs
Minimum percentage of free space in a block
Minimum percentage of used space in a block
Initial number of transactions
Maximum number of transactions
Size of the initial extent in bytes
Size of secondary extents in bytes
Minimum number of extents allowed in the segment
Maximum number of extents allowed in the segment
Percentage increase in extent size
Number of process freelists allocated in this segment
Number of freelist groups allocated in this segment
Logging attribute
Has table been backed up since last modification?
The number of rows in the table
The number of used blocks in the table
The number of empty (never used) blocks in the table
The average available free space in the table
The number of chained rows in the table
The average row length, including row overhead
The average freespace of all blocks on a freelist
The number of blocks on the freelist
The number of threads per instance for scanning the table
The number of instances across which the table is to be scanned
Whether the table is to be cached in the buffer cache
Whether table locking is enabled or disabled
The sample size used in analyzing this table
The date of the most recent time this table was analyzed
Is this table partitioned? YES or NO
If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL
If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST
Owner of the type of the table if the table is an object table
Type of the table if the table is an object table
Can the current session only see data that it place in this object itself?
Is this table object created as part of icreate for domain indexes?
Is the table a nested table?
The default buffer pool to be used for table blocks
Whether partitioned row movement is enabled or disabled
Are the statistics calculated without merging underlying partitions?
Were the statistics entered directly by the user?
If temporary table, then duration is sys$session or sys$transaction else NULL
Whether skip corrupt blocks is enabled or disabled
Should we keep track of the amount of modification?
Owner of the cluster, if any, to which the table belongs
Should we keep track of row level dependencies?
Owner of the table
Name of the table
ALL_APPLY
Details about each apply process that dequeues from the queue visible to the current user
APPLY_NAME
QUEUE_NAME
QUEUE_OWNER
APPLY_CAPTURED
RULE_SET_NAME
RULE_SET_OWNER
APPLY_USER
APPLY_DATABASE_LINK
APPLY_TAG
DDL_HANDLER
MESSAGE_HANDLER
STATUS
Name of the apply process
Name of the queue the apply process dequeues from
Owner of the queue the apply process dequeues from
Yes, if applying captured messages; No, if applying enqueued messages
Rule set used by apply process for filtering
Owner of the rule set
Current user who is applying the messages
For remote objects, the database link pointing to the remote database
Tag associated with DDL and DML change records that will be applied
Name of the user specified ddl handler
User specified procedure to handle messages other than DDL and DML messages
Status of the apply process: DISABLED, ENABLED, ABORTED
ALL_APPLY_CONFLICT_COLUMNS
Details about conflict resolution on tables visible to the current user
OBJECT_OWNER
OBJECT_NAME
METHOD_NAME
RESOLUTION_COLUMN
COLUMN_NAME
APPLY_DATABASE_LINK
Owner of the object
Name of the object
Name of the method used to resolve conflict
Name of the column used to resolve conflict
Name of the column that is to be considered as part of a group to resolve conflict
For remote objects, name of database link pointing to remote database
ALL_APPLY_DML_HANDLERS
Details about the dml handler on tables visible to the current user
OBJECT_OWNER
OBJECT_NAME
OPERATION_NAME
USER_PROCEDURE
ERROR_HANDLER
APPLY_DATABASE_LINK
Owner of the object
Name of the object
Name of the DML operation
Name of the DML handler specified by the user
Y if the user procedure is the error handler, N if it is the DML handler
For remote objects, name of database link pointing to remote database
ALL_APPLY_ERROR
Error transactions that were generated after dequeuing from the queue visible to the current user
APPLY_NAME
QUEUE_NAME
QUEUE_OWNER
LOCAL_TRANSACTION_ID
SOURCE_DATABASE
SOURCE_TRANSACTION_ID
SOURCE_COMMIT_SCN
MESSAGE_NUMBER
ERROR_NUMBER
ERROR_MESSAGE
RECIPIENT_ID
RECIPIENT_NAME
MESSAGE_COUNT
Name of the apply process at the local site which processed the transaction
Name of the queue at the local site where the transaction came from
Owner of the queue at the local site where the transaction came from
Local transaction ID for the error creation transaction
Database where the transaction originated
Original transaction ID at the source database
Original commit SCN for the transaction at the source database
Identifier for the message in the transaction that raised an error
Error number
Error message
User ID of the original recipient
Name of the original recipient
Total number of messages inside the error transaction
ALL_APPLY_KEY_COLUMNS
Alternative key columns for a STREAMS table visible to the current user
OBJECT_OWNER
OBJECT_NAME
COLUMN_NAME
APPLY_DATABASE_LINK
Owner of the object
Name of the object
Column name of the object
Remote database link to which changes will be aplied
ALL_APPLY_PARAMETERS
Details about parameters of each apply process that dequeues from the queue visible to the current user
APPLY_NAME
PARAMETER
VALUE
SET_BY_USER
Name of the apply process
Name of the parameter
Either the default value or the value set by the user for the parameter
YES if the value is set by the user, NO otherwise
ALL_APPLY_PROGRESS
Information about the progress made by the apply process that dequeues from the queue visible to the current user
APPLY_NAME
APPLIED_MESSAGE_NUMBER
OLDEST_MESSAGE_NUMBER
APPLY_TIME
APPLIED_MESSAGE_CREATE_TIME Time at which the message to be applied was created
Name of the apply process
All messages before this number have been successfully applied
Earliest commit number of the transactions currently being applied
Time at which the message was applied
ALL_ARGUMENTS
Arguments in object accessible to the user
OWNER
OBJECT_NAME
PACKAGE_NAME
OBJECT_ID
OVERLOAD
ARGUMENT_NAME
POSITION
SEQUENCE
DATA_LEVEL
DATA_TYPE
DEFAULT_VALUE
DEFAULT_LENGTH
IN_OUT
DATA_LENGTH
DATA_PRECISION
DATA_SCALE
RADIX
CHARACTER_SET_NAME
TYPE_OWNER
TYPE_NAME
TYPE_SUBNAME
TYPE_LINK
PLS_TYPE
CHAR_LENGTH
CHAR_USED
Username of the owner of the object
Procedure or function name
Package name
Object number of the object
Overload unique identifier
Argument name
Position in argument list, or null for function return value
Argument sequence, including all nesting levels
Nesting depth of argument for composite types
Datatype of the argument
Default value for the argument
Length of default value for the argument
Argument direction (IN, OUT, or IN/OUT)
Length of the column in bytes
Length: decimal digits (NUMBER) or binary digits (FLOAT)
Digits to right of decimal point in a number
Argument radix for a number
Character set name for the argument
Owner name for the argument type in case of object types
Object name for the argument type in case of object types
Subordinate object name for the argument type in case of object types
Database link name for the argument type in case of object types
PL/SQL type name for numeric arguments
Character limit for string datatypes
Is the byte limit (B) or char limit (C) official for this string?
ALL_ASSOCIATIONS
All associations available to the user
OBJECT_OWNER
OBJECT_NAME
COLUMN_NAME
OBJECT_TYPE
STATSTYPE_SCHEMA
STATSTYPE_NAME
DEF_SELECTIVITY
DEF_CPU_COST
DEF_IO_COST
DEF_NET_COST
INTERFACE_VERSION
Owner of the object for which the association is being defined
Object name for which the association is being defined
Column name in the object for which the association is being defined
Schema type of the object - column, type, package or function
Owner of the statistics type
Name of Statistics type which contains the cost, selectivity or stats funcs
Default Selectivity if any of the object
Default CPU cost if any of the object
Default I/O cost if any of the object
Default Networking cost if any of the object
Version number of Statistics type interface implemented
ALL_AUDIT_POLICIES
All fine grained auditing policies in the database
OBJECT_SCHEMA
OBJECT_NAME
POLICY_NAME
POLICY_TEXT
POLICY_COLUMN
PF_SCHEMA
PF_PACKAGE
PF_FUNCTION
ENABLED
Owner of the table or view
Name of the table or view
Name of the policy
Audit condition
Relevant column
Owner of the audit handler function
Name of the package containing the audit handler function
Name of the audit handler function
Is this policy is enabled?
ALL_BASE_TABLE_MVIEWS
All materialized views with log(s) in the database that the user can see
OWNER
MASTER
MVIEW_LAST_REFRESH_TIME
MVIEW_ID
Owner of the master table which changes are logged
Name of the master table which changes are logged
One date per materialized view -- the date the materialized view was last refreshed
Unique identifier of the materialized view
ALL_CAPTURE
Details about each capture process that stores the captured changes in a queue visible to the current user
CAPTURE_NAME
QUEUE_NAME
QUEUE_OWNER
RULE_SET_NAME
RULE_SET_OWNER
START_SCN
STATUS
Name of the capture process
Name of queue used for holding captured changes
Owner of the queue used for holding captured changes
Rule set used by capture process for filtering
Owner of the rule set
The SCN from which capturing will be resumed
Status of the capture process: DISABLED, ENABLED, ABORTED
ALL_CAPTURE_PARAMETERS
Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
CAPTURE_NAME
PARAMETER
VALUE
SET_BY_USER
Name of the capture process
Name of the parameter
Either the default value or the value set by the user for the parameter
YES if the value is set by the user, NO otherwise
ALL_CAPTURE_PREPARED_DATABASE
Is the local database prepared for instantiation?
TIMESTAMP
Time at which the database was ready to be instantiated
ALL_CAPTURE_PREPARED_SCHEMAS
All user schemas at the local database that are prepared for instantiation
SCHEMA_NAME
TIMESTAMP
Name of schema prepared for instantiation
Time at which the schema was ready to be instantiated
ALL_CAPTURE_PREPARED_TABLES
All tables visible to the current user that are prepared for instantiation
TABLE_OWNER
TABLE_NAME
SCN
TIMESTAMP
Owner of the table prepared for instantiation
Name of the table prepared for instantiation
SCN from which changes can be captured
Time at which the table was ready to be instantiated
ALL_CATALOG
All tables, views, synonyms, sequences accessible to the user
OWNER
TABLE_NAME
TABLE_TYPE
Owner of the object
Name of the object
Type of the object
ALL_CLUSTER_HASH_EXPRESSIONS
Hash functions for all accessible clusters
OWNER
CLUSTER_NAME
HASH_EXPRESSION
Name of owner of cluster
Name of cluster
Text of hash function of cluster
ALL_CLUSTERS
Description of clusters accessible to the user
OWNER
CLUSTER_NAME
TABLESPACE_NAME
PCT_FREE
PCT_USED
KEY_SIZE
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
AVG_BLOCKS_PER_KEY
CLUSTER_TYPE
FUNCTION
HASHKEYS
DEGREE
INSTANCES
CACHE
BUFFER_POOL
SINGLE_TABLE
DEPENDENCIES
Owner of the cluster
Name of the cluster
Name of the tablespace containing the cluster
Minimum percentage of free space in a block
Minimum percentage of used space in a block
Estimated size of cluster key plus associated rows
Initial number of transactions
Maximum number of transactions
Size of the initial extent in bytes
Size of secondary extents in bytes
Minimum number of extents allowed in the segment
Maximum number of extents allowed in the segment
Percentage increase in extent size
Number of process freelists allocated in this segment
Number of freelist groups allocated in this segment
Average number of blocks containing rows with a given cluster key
Type of cluster: b-tree index or hash
If a hash cluster, the hash function
If a hash cluster, the number of hash keys (hash buckets)
The number of threads per instance for scanning the cluster
The number of instances across which the cluster is to be scanned
Whether the cluster is to be cached in the buffer cache
The default buffer pool to be used for cluster blocks
Whether the cluster can contain only a single table
Should we keep track of row level dependencies?
ALL_COL_COMMENTS
Comments on columns of accessible tables and views
OWNER
TABLE_NAME
COLUMN_NAME
COMMENTS
Owner of the object
Name of the object
Name of the column
Comment on the column
ALL_COL_PRIVS
Grants on columns for which the user is the grantor, grantee, owner,
GRANTOR
GRANTEE
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
PRIVILEGE
GRANTABLE
Name of the user who performed the grant
Name of the user to whom access was granted
Schema of the object
Name of the object
Name of the column
Column Privilege
Privilege is grantable
ALL_COL_PRIVS_MADE
Grants on columns for which the user is owner or grantor
GRANTEE
OWNER
TABLE_NAME
COLUMN_NAME
GRANTOR
PRIVILEGE
GRANTABLE
Name of the user to whom access was granted
Username of the owner of the object
Name of the object
Name of the column
Name of the user who performed the grant
Column Privilege
Privilege is grantable
ALL_COL_PRIVS_RECD
Grants on columns for which the user, PUBLIC or enabled role is the grantee
GRANTEE
OWNER
TABLE_NAME
COLUMN_NAME
GRANTOR
PRIVILEGE
GRANTABLE
Name of the user to whom access was granted
Username of the owner of the object
Name of the object
Name of the column
Name of the user who performed the grant
Column privilege
Privilege is grantable
ALL_COLL_TYPES
Description of named collection types accessible to the user
OWNER
TYPE_NAME
COLL_TYPE
UPPER_BOUND
ELEM_TYPE_MOD
ELEM_TYPE_OWNER
ELEM_TYPE_NAME
LENGTH
PRECISION
SCALE
CHARACTER_SET_NAME
ELEM_STORAGE
NULLS_STORED
Owner of the type
Name of the type
Collection type
Size of the FIXED ARRAY type or maximum size of the VARYING ARRAY type
Type modifier of the element
Owner of the type of the element
Name of the type of the element
Length of the CHAR element or maximum length of the VARCHAR
Decimal precision of the NUMBER or DECIMAL element or
Scale of the NUMBER or DECIMAL element
Character set name of the element
Storage optimization specification for VARRAY of numeric elements
Is null information stored with each VARRAY element?
ALL_CONS_COLUMNS
Information about accessible columns in constraint definitions
OWNER
CONSTRAINT_NAME
TABLE_NAME
COLUMN_NAME
POSITION
Owner of the constraint definition
Name associated with the constraint definition
Name associated with table with constraint definition
Name associated with column or attribute of object column specified in the constraint definition
Original position of column or attribute in definition
ALL_CONS_OBJ_COLUMNS
List of types an object column or attribute is constrained to in the tables accessible to the user
OWNER
Owner of the table
TABLE_NAME
TAB_COMMENTSCOLUMN_NAME
TABLE_NAME
COLUMN_NAME
CONS_TYPE_OWNER
CONS_TYPE_NAME
CONS_TYPE_ONLY
COL_COMMENTS
Name of the table containing the object column or attribute
Fully qualified name of the object column or attribute
Owner of the type that the column is constrained to
Name of the type that the column is constrained to
Indication of whether the column is constrained to ONLY type
ALL_CONSTRAINTS
Constraint definitions on accessible tables
OWNER
CONSTRAINT_NAME
CONSTRAINT_TYPE
TABLE_NAME
SEARCH_CONDITION
R_OWNER
R_CONSTRAINT_NAME
DELETE_RULE
STATUS
DEFERRABLE
DEFERRED
VALIDATED
GENERATED
BAD
RELY
LAST_CHANGE
INDEX_OWNER
INDEX_NAME
INVALID
VIEW_RELATED
Owner of the table
Name associated with constraint definition
Type of constraint definition
Name associated with table with constraint definition
Text of search condition for table check
Owner of table used in referential constraint
Name of unique constraint definition for referenced table
The delete rule for a referential constraint
Enforcement status of constraint - ENABLED or DISABLED
Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE
Is the constraint deferred by default - DEFERRED or IMMEDIATE
Was this constraint system validated? - VALIDATED or NOT VALIDATED
Was the constraint name system generated? - GENERATED NAME or USER NAME
Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
If set, this flag will be used in optimizer
The date when this column was last enabled or disabled
The owner of the index used by this constraint
The index used by this constraint
ALL_CONTEXT
Description of all active context namespaces under the current session
NAMESPACE
SCHEMA
PACKAGE
Namespace of the active context
Schema of the designated package
Name of the designated package
ALL_DB_LINKS
Database links accessible to the user
OWNER
DB_LINK
USERNAME
HOST
CREATED
Name of the database link
Name of user to log on as
SQL*Net string for connect
Creation time of the database link
ALL_DEF_AUDIT_OPTS
Auditing options for newly created objects
ALT
AUD
COM
DEL
GRA
IND
INS
LOC
REN
SEL
UPD
REF
EXE
Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)
Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL
ALL_DEPENDENCIES
Dependencies to and from objects accessible to the user
OWNER
NAME
TYPE
REFERENCED_OWNER
REFERENCED_NAME
REFERENCED_TYPE
REFERENCED_LINK_NAME
DEPENDENCY_TYPE
Owner of the object
Name of the object
Type of the object
Owner of referenced object (remote owner if remote object)
Name of referenced object
Type of referenced object
Name of dblink if this is a remote object
ALL_DIM_ATTRIBUTES
Representation of the relationship between a dimension level and
OWNER
DIMENSION_NAME
LEVEL_NAME
COLUMN_NAME
INFERRED
Owner of the dimentsion
Name of the dimension
Name of the hierarchy level
Name of the dependent column
Whether this attribute is inferred from a JOIN KEY specification
ALL_DIM_CHILD_OF
Representaion of a 1:n hierarchical relationship between a pair of levels in
OWNER
DIMENSION_NAME
HIERARCHY_NAME
POSITION
CHILD_LEVEL_NAME
JOIN_KEY_ID
PARENT_LEVEL_NAME
Owner of the dimension
Name of the dimension
Name of the hierarchy
Hierarchical position within this hierarchy, position 1 being
Name of the child-side level of this 1:n relationship
Keys that join child uniquely to the parent
Name of the parent-side level of this 1:n relationship
ALL_DIM_HIERARCHIES
Representation of a dimension hierarchy
OWNER
DIMENSION_NAME
HIERARCHY_NAME
Owner of the dimension
Name of the dimension
Name of the hierarchy
ALL_DIM_JOIN_KEY
Representation of a join between two dimension tables.
OWNER
DIMENSION_NAME
DIM_KEY_ID
LEVEL_NAME
KEY_POSITION
HIERARCHY_NAME
CHILD_JOIN_COLUMN
Owner of the dimension
Name of the dimension
Join key ID (unique within a dimension)
Name of the hierarchy level
Position of the key column within the level
Name of the hierarchy
Name of the join column
ALL_DIM_LEVEL_KEY
Representations of columns of a dimension level
OWNER
DIMENSION_NAME
LEVEL_NAME
KEY_POSITION
COLUMN_NAME
Owner of the dimension
Name of the dimension
Name of the hierarchy level
Ordinal position of the key column within the level
Name of the key column
ALL_DIM_LEVELS
Description of dimension levels visible to DBA
OWNER
DIMENSION_NAME
LEVEL_NAME
NUM_COLUMNS
DETAILOBJ_OWNER
DETAILOBJ_NAME
Owner of the dimension
Name of the dimension
Name of the dimension level (unique within a dimension)
Number of columns in the level definition
Owner of the detail object that the keys of this level come from
Name of the table that the keys of this level come from
ALL_DIMENSIONS
Description of the dimension objects accessible to the DBA
OWNER
DIMENSION_NAME
INVALID
COMPILE_STATE
REVISION
Owner of the dimension
Name of the dimension
Invalidity of the dimension, Y = INVALID, N = VALID.
Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR
Revision levle of the dimension
ALL_DIRECTORIES
Description of all directories accessible to the user
OWNER
DIRECTORY_NAME
DIRECTORY_PATH
Owner of the directory (always SYS)
Name of the directory
Operating system pathname for the directory
ALL_ERRORS
Current errors on stored objects that user is allowed to create
OWNER
NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
Owner of the object
Name of the object
Type: "TYPE", "TYPE BODY", "VIEW", "PROCEDURE", "FUNCTION",
Sequence number used for ordering purposes
Line number at which this error occurs
Position in the line at which this error occurs
Text of the error
ALL_EVALUATION_CONTEXT_TABLES
tables in all rule evaluation contexts seen by the user
EVALUATION_CONTEXT_OWNER
EVALUATION_CONTEXT_NAME
TABLE_ALIAS
TABLE_NAME
Owner of the evaluation context
Name of the evaluation context
Alias of the table
Name of the table
ALL_EVALUATION_CONTEXT_VARS
variables in all rule evaluation contexts seen by the user
EVALUATION_CONTEXT_OWNER
EVALUATION_CONTEXT_NAME
VARIABLE_NAME
VARIABLE_TYPE
VARIABLE_VALUE_FUNCTION
VARIABLE_METHOD_FUNCTION
Owner of the evaluation context
Name of the evaluation context
Name of the variable
Function to provide variable value
Function to provide variable method return value
ALL_EVALUATION_CONTEXTS
rule evaluation contexts seen by user
EVALUATION_CONTEXT_OWNER
EVALUATION_CONTEXT_NAME
EVALUATION_FUNCTION
EVALUATION_CONTEXT_COMMENT
Owner of the evaluation context
Name of the evaluation context
User supplied function to evaluate rules
user description of the evaluation context
ALL_EXTERNAL_LOCATIONS
Description of the external tables locations accessible to the user
OWNER
TABLE_NAME
LOCATION
DIRECTORY_OWNER
DIRECTORY_NAME
Owner of the external table location
Name of the corresponding external table
External table location clause
Owner of the directory containing the external table location
Name of the directory containing the location
ALL_EXTERNAL_TABLES
Description of the external tables accessible to the user
OWNER
TABLE_NAME
TYPE_OWNER
TYPE_NAME
DEFAULT_DIRECTORY_OWNER
DEFAULT_DIRECTORY_NAME
REJECT_LIMIT
ACCESS_TYPE
ACCESS_PARAMETERS
Owner of the external table
Name of the external table
Owner of the implementation type for the external table access driver
Name of the implementation type for the external table access driver
Owner of the default directory for the external table
Name of the default directory for the external table
Reject limit for the external table
Type of access parameters for the external table (CLOB/BLOB)
Access parameters for the external table
ALL_HISTOGRAMS
Synonym for ALL_TAB_HISTOGRAMS
OWNER
TABLE_NAME
COLUMN_NAME
ENDPOINT_NUMBER
ENDPOINT_ACTUAL_VALUE
ENDPOINT_VALUE
Owner of table
Table name
Column name or attribute of object column
Endpoint number
Actual endpoint value
Normalized endpoint value
ALL_IND_COLUMNS
COLUMNs comprising INDEXes on accessible TABLES
INDEX_OWNER
INDEX_NAME
TABLE_OWNER
TABLE_NAME
COLUMN_NAME
COLUMN_POSITION
COLUMN_LENGTH
CHAR_LENGTH
DESCEND
Index owner
Index name
Table or cluster owner
Table or cluster name
Column name or attribute of object column
Position of column or attribute within index
Maximum length of the column or attribute, in bytes
Maximum length of the column or attribute, in characters
DESC if this column is sorted in descending order on disk, otherwise ASC
ALL_IND_EXPRESSIONS
ALL_IND_PARTITIONS
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
Index owner
Index name
Table or cluster owner
Table or cluster name
Functional index expression defining the column
Position of column or attribute within index
INDEX_OWNER
INDEX_NAME
TABLE_OWNER
TABLE_NAME
COLUMN_EXPRESSION
COLUMN_POSITION
ALL_IND_SUBPARTITIONS
CLUSTERING_FACTOR
NUM_ROWS
SAMPLE_SIZE
LAST_ANALYZED
BUFFER_POOL
USER_STATS
PCT_DIRECT_ACCESS
GLOBAL_STATS
DOMIDX_OPSTATUS
PARAMETERS
INDEX_OWNER
INDEX_NAME
COMPOSITE
PARTITION_NAME
SUBPARTITION_COUNT
HIGH_VALUE
HIGH_VALUE_LENGTH
PARTITION_POSITION
STATUS
TABLESPACE_NAME
PCT_FREE
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENT
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
COMPRESSION
BLEVEL
LEAF_BLOCKS
DISTINCT_KEYS
AVG_LEAF_BLOCKS_PER_KEY
AVG_DATA_BLOCKS_PER_KEY
INDEX_OWNER
INDEX_NAME
PARTITION_NAME
SUBPARTITION_NAME
HIGH_VALUE
HIGH_VALUE_LENGTH
SUBPARTITION_POSITION
STATUS
TABLESPACE_NAME
PCT_FREE
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENT
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
BLEVEL
LEAF_BLOCKS
DISTINCT_KEYS
AVG_LEAF_BLOCKS_PER_KEY
AVG_DATA_BLOCKS_PER_KEY
CLUSTERING_FACTOR
NUM_ROWS
SAMPLE_SIZE
LAST_ANALYZED
BUFFER_POOL
USER_STATS
GLOBAL_STATS
ALL_INDEXES
Descriptions of indexes on tables accessible to the user
DOMIDX_OPSTATUS
FUNCIDX_STATUS
JOIN_INDEX
OWNER
INDEX_NAME
INDEX_TYPE
TABLE_OWNER
TABLE_NAME
TABLE_TYPE
UNIQUENESS
COMPRESSION
PREFIX_LENGTH
TABLESPACE_NAME
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
PCT_THRESHOLD
INCLUDE_COLUMN
FREELISTS
FREELIST_GROUPS
PCT_FREE
Status of the operation on the domain index
Is the Function-based Index DISABLED or ENABLED?
Is this index a join index?
Username of the owner of the index
Name of the index
Owner of the indexed object
Name of the indexed object
Type of the indexed object
Uniqueness status of the index: "UNIQUE", "NONUNIQUE", or "BITMAP"
Compression property of the index: "ENABLED", "DISABLED", or NULL
Number of key columns in the prefix used for compression
Name of the tablespace containing the index
Initial number of transactions
Maximum number of transactions
Size of the initial extent
Size of secondary extents
Minimum number of extents allowed in the segment
Maximum number of extents allowed in the segment
Percentage increase in extent size
Threshold percentage of block space allowed per index entry
User column-id for last column to be included in index-organized table top index
Number of process freelists allocated in this segment
Number of freelist groups allocated to this segment
Minimum percentage of free space in a block
TABLE_NAME
TAB_COMMENTSCOLUMN_NAME
LOGGING
BLEVEL
LEAF_BLOCKS
DISTINCT_KEYS
AVG_LEAF_BLOCKS_PER_KEY
AVG_DATA_BLOCKS_PER_KEY
CLUSTERING_FACTOR
STATUS
NUM_ROWS
SAMPLE_SIZE
LAST_ANALYZED
DEGREE
INSTANCES
PARTITIONED
TEMPORARY
GENERATED
SECONDARY
BUFFER_POOL
USER_STATS
DURATION
PCT_DIRECT_ACCESS
ITYP_OWNER
ITYP_NAME
PARAMETERS
GLOBAL_STATS
DOMIDX_STATUS
COL_COMMENTS
Logging attribute
B-Tree level
The number of leaf blocks in the index
The number of distinct keys in the index
The average number of leaf blocks per key
The average number of data blocks per key
A measurement of the amount of (dis)order of the table this index is for
Whether the non-partitioned index is in USABLE or not
The sample size used in analyzing this index
The date of the most recent time this index was analyzed
The number of threads per instance for scanning the partitioned index
The number of instances across which the partitioned index is to be scanned
Is this index partitioned? YES or NO
Can the current session only see data that it place in this object itself?
Was the name of this index system generated?
Is the index object created as part of icreate for domain indexes?
The default buffer pool to be used for index blocks
Were the statistics entered directly by the user?
If index on temporary table, then duration is sys$session or sys$transaction else NULL
If index on IOT, then this is percentage of rows with Valid guess
If domain index, then this is the indextype owner
If domain index, then this is the name of the associated indextype
If domain index, then this is the parameter string
Are the statistics calculated without merging underlying partitions?
Is the indextype of the domain index valid
ALL_INDEXTYPE_COMMENTS
Comments for user-defined indextypes
OWNER
INDEXTYPE_NAME
COMMENTS
Owner of the user-defined indextype
Name of the user-defined indextype
Comment for the user-defined indextype
ALL_INDEXTYPE_OPERATORS
All operators available to the user
OWNER
INDEXTYPE_NAME
OPERATOR_SCHEMA
OPERATOR_NAME
BINDING#
Owner of the indextype
Name of the indextype
Name of the operator schema
Name of the operator for which the indextype is defined
Binding# associated with the operator
ALL_INDEXTYPES
All indextypes available to the user
OWNER
INDEXTYPE_NAME
IMPLEMENTATION_SCHEMA
IMPLEMENTATION_NAME
INTERFACE_VERSION
IMPLEMENTATION_VERSION
NUMBER_OF_OPERATORS
PARTITIONING
Owner of the indextype
Name of the indextype
Name of the schema for indextype implementation
Name of indextype implementation
Version of indextype interface
Version of indextype implementation
Number of operators associated with the indextype
Kinds of local partitioning supported by the indextype
ALL_INTERNAL_TRIGGERS
Description of the internal triggers on the tables accessible to the user
TABLE_NAME
INTERNAL_TRIGGER_TYPE
Name of the table
Type of internal trigger
ALL_JAVA_ARGUMENTS
argument information of stored java class accessible to the user
OWNER
NAME
METHOD_INDEX
METHOD_NAME
ARGUMENT_POSITION
ARRAY_DEPTH
BASE_TYPE
ARGUMENT_CLASS
owner of the stored java class
name of the java class
the index of hosting method of the argument
the name of hosting method of the argument
the position of the argument, starting from 0
array depth of the type of the arguement
base type of the type of the argument
if base_type is class, this gives the actual class name of the argument
ALL_JAVA_CLASSES
class level information of stored java class accessible to the user
OWNER
NAME
MAJOR
MINOR
KIND
ACCESSIBILITY
IS_INNER
IS_ABSTRACT
IS_FINAL
IS_DEBUG
SOURCE
SUPER
OUTER
owner of the java class
name of the java class
the major version number of the java class as defined in JVM specification
the minor version number of the java class as defined in JVM specification
is the stored object a java class or java interface?
the accessiblity of the java class
is this java class an inner class
is this an abstract class?
is this an final class?
does this class contain debug information?
source designation of the java class
super class of this java class
outer class of this java class if this java class is an inner class
ALL_JAVA_DERIVATIONS
this view maps java source objects and their derived java class objects and java resource objects for the java class accessible to user
OWNER
SOURCE_NAME
CLASS_INDEX
CLASS_NAME
RESOURCE_INDEX
RESOURCE_NAME
owner of the java class object
name of the java source object
index of the derived java class object
name of the derived java class object
index of the derived java resource object
name of the derived java resource object
ALL_JAVA_FIELDS
field information of stored java class accessible to user
OWNER
NAME
FIELD_INDEX
FIELD_NAME
ACCESSIBILITY
IS_STATIC
IS_FINAL
IS_VOLATILE
IS_TRANSIENT
ARRAY_DEPTH
BASE_TYPE
FIELD_CLASS
owner of the stored java class
name of the java class
the index of the field
the name of the field at FIELD_INDEX
the accessiblity of the field, public/private/protected/null(i.e. package)
is the field a static field?
is the field a final field?
is the field volotile?
is the field transient?
array depth of the type of the field
base type of the type of the field
if base_type is class, this gives the actual class name of the base object
ALL_JAVA_IMPLEMENTS
interfaces implemented by the stored java class accessible to the user
OWNER
NAME
INTERFACE_INDEX
INTERFACE_NAME
owner of the java class
name of the stored java class
index of the interfaces implemented by the stored java class
name of the interface identified by the INTERFACE_INDEX
ALL_JAVA_INNERS
list of inner classes refered by the stored java class accessible to user
OWNER
NAME
INNER_INDEX
SIMPLE_NAME
FULL_NAME
ACCESSIBILITY
IS_STATIC
IS_FINAL
IS_ABSTRACT
IS_INTERFACE
owner of the stored java class
name of the stored java class
index of the refered inner class
simple name of the refered inner class
full name of the refered inner class
is the refered inner class declared static in the sorce file
is the refered inner class declared final in the sorce file
is the refered inner class declared abstract in the sorce file
is the refered inner class declared interface in the sorce file
ALL_JAVA_LAYOUTS
class layout information about stored java class accessible to the user
OWNER
NAME
INTERFACES
INNER_CLASSES
FIELDS
STATIC_FIELDS
METHODS
STATIC_METHODS
NATIVE_METHODS
owner of the java class
how many interfaces does this class implement?
how many inner classes does this class contain?
how many locally declared fields does this class contain?
how many locally declared static fields does this class contain?
how many locally declared methods does this class contain?
how many locally declared static methods does this class contain?
ALL_JAVA_METHODS
method information of stored java class accessible to user
OWNER
NAME
METHOD_INDEX
METHOD_NAME
ACCESSIBILITY
IS_STATIC
IS_FINAL
IS_SYNCHRONIZED
IS_NATIVE
IS_ABSTRACT
IS_STRICT
ARGUMENTS
THROWS
ARRAY_DEPTH
BASE_TYPE
RETURN_CLASS
owner of the stored java class
name of the java class
the index of the method
the name of the field at METHOD_INDEX
the accessiblity of the method, public/private/protected/null(i.e. package)
is the method a static method?
is the method a final method?
is the method a synchronized method?
is the method a native method?
is the method an abstract method?
is the method a strict method?
number of arguments of the method
number of exceptions thrown by the method
array depth of the return type of the method
base type of the return type of the field
if base_type is class, this gives the actual class name of the return value
ALL_JAVA_NCOMPS
ncomp related information of all java classes
OWNER
NAME
SOURCE
INITIALIZER
LIBRARYFILE
LIBRARY
owner of the java class object
name of the java class object
ncomp source shown in this row
ncomp initializer shown in this row
ncomp libraryfile shown in this row
ncomp library shown in this row
ALL_JAVA_RESOLVERS
resolver of java class owned by user
OWNER
NAME
TERM_INDEX
PATTERN
SCHEMA
owner of the java class object
name of the java class object
index of the resolver term in this row
resolver pattern of the resolver term identified by TERM_INDEX column
resolver schema of the resolver term identified by TERM_INDEX column
ALL_JAVA_THROWS
list of exceptions thrown from a method of a class accessible to user
OWNER
NAME
METHOD_INDEX
METHOD_NAME
EXCEPTION_INDEX
EXCEPTION_CLASS
owner of the stored java class
name of the java class
the index of throwing method of the exception
the name of throwing method of the exception
the index of the exception
the class of the exception
ALL_JOBS
Synonym for USER_JOBS
JOB
LOG_USER
PRIV_USER
SCHEMA_USER
LAST_SEC
THIS_SEC
MISC_ENV
NLS_ENV
WHAT
FAILURES
INTERVAL
BROKEN
TOTAL_TIME
NEXT_SEC
NEXT_DATE
INSTANCE
THIS_DATE
LAST_DATE
Identifier of job. Neither import/export nor repeated executions change it.
USER who was logged in when the job was submitted
USER whose default privileges apply to this job
select * from bar means select * from schema_user.bar
Same as LAST_DATE. This is when the last successful execution started.
Same as THIS_DATE. This is when the last successful execution started.
a versioned raw maintained by the kernel, for other session parameters
alter session parameters describing the NLS environment of the job
Body of the anonymous PL/SQL block that this job executes
How many times has this job started and failed since its last success?
A date function, evaluated at the start of execution, becomes next NEXT_DATE
If Y, no attempt is being made to run this job. See dbms_jobq.broken(job).
Total wallclock time spent by the system on this job, in seconds
Same as NEXT_DATE. The job becomes due for execution at this time.
Date that this job will next be executed
Instance number restricted to run the job
Date that this job started executing (usually null if not executing)
Date that this job last successfully executed
ALL_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
Index owner
Index name
Table owner of inner table (table closer to the fact table)
Table name of inner table (table closer to the fact table)
Column name of inner table (table closer to the fact table)
Table owner of outer table (table closer to the fact table)
Table name of outer table (table closer to the fact table)
Column name of outer table (table closer to the fact table)
INDEX_OWNER
INDEX_NAME
INNER_TABLE_OWNER
INNER_TABLE_NAME
INNER_TABLE_COLUMN
OUTER_TABLE_OWNER
OUTER_TABLE_NAME
OUTER_TABLE_COLUMN
ALL_LIBRARIES
Description of libraries accessible to the user
Owner of the library
Name of the library
Operating system file specification of the library
Is the library dynamically loadable
Status of the library
ALL_LOB_PARTITIONS
ALL_LOB_SUBPARTITIONS
ALL_LOB_TEMPLATES
OWNER
LIBRARY_NAME
FILE_SPEC
DYNAMIC
STATUS
TABLE_OWNER
TABLE_NAME
COLUMN_NAME
LOB_NAME
PARTITION_NAME
LOB_PARTITION_NAME
LOB_INDPART_NAME
PARTITION_POSITION
COMPOSITE
CHUNK
PCTVERSION
CACHE
IN_ROW
TABLESPACE_NAME
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
BUFFER_POOL
TABLE_OWNER
TABLE_NAME
COLUMN_NAME
LOB_NAME
LOB_PARTITION_NAME
SUBPARTITION_NAME
LOB_SUBPARTITION_NAME
LOB_INDSUBPART_NAME
SUBPARTITION_POSITION
CHUNK
PCTVERSION
CACHE
IN_ROW
TABLESPACE_NAME
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
BUFFER_POOL
USER_NAME
TABLE_NAME
LOB_COL_NAME
SUBPARTITION_NAME
LOB_SEGMENT_NAME
TABLESPACE_NAME
ALL_LOBS
Description of LOBs contained in tables accessible to the user
OWNER
TABLE_NAME
COLUMN_NAME
SEGMENT_NAME
INDEX_NAME
CHUNK
PCTVERSION
RETENTION
FREEPOOLS
CACHE
LOGGING
IN_ROW
Owner of the table containing the LOB
Name of the table containing the LOB
Name of the LOB column or attribute
Name of the LOB segment
Name of the LOB index
Size of the LOB chunk as a unit of allocation/manipulation in bytes
Maximum percentage of the LOB space used for versioning
Maximum time duration for versioning of the LOB space
Number of freepools for this LOB segment
Is the LOB accessed through the buffer cache?
Are changes to the LOB logged?
Are some of the LOBs stored with the base row?
ALL_LOG_GROUP_COLUMNS
Information about columns in log group definitions
OWNER
LOG_GROUP_NAME
TABLE_NAME
COLUMN_NAME
POSITION
Owner of the log group definition
Name associated with the log group definition
Name associated with table with log group definition
Name associated with column or attribute of object column specified in the log group definition
Original position of column or attribute in definition
ALL_LOG_GROUPS
Log group definitions on accessible tables
OWNER
LOG_GROUP_NAME
TABLE_NAME
ALWAYS
Owner of the table
Name associated with log group definition
If set, these columns are always logged
ALL_METHOD_PARAMS
Description of method parameters of types accessible
OWNER
TYPE_NAME
Onwer of the type
Name of the type
TABLE_NAME
TAB_COMMENTSCOLUMN_NAME
METHOD_NAME
METHOD_NO
PARAM_NAME
PARAM_NO
PARAM_MODE
PARAM_TYPE_MOD
PARAM_TYPE_OWNER
PARAM_TYPE_NAME
CHARACTER_SET_NAME
COL_COMMENTS
Name of the method
Method number for distinguishing overloaded method (not to be used as ID number)
Name of the parameter
Parameter number or position
Mode of the parameter
Type modifier of the parameter
Owner of the type of the parameter
Name of the type of the parameter
Character set name of the parameter
ALL_METHOD_RESULTS
Description of method results of types accessible
OWNER
TYPE_NAME
METHOD_NAME
METHOD_NO
RESULT_TYPE_MOD
RESULT_TYPE_OWNER
RESULT_TYPE_NAME
CHARACTER_SET_NAME
Onwer of the type
Name of the type
Name of the method
Method number for distinguishing overloaded method (not to be used as ID number)
Type modifier of the result
Owner of the type of the result
Name of the type of the result
Character set name of the result
ALL_MVIEW_AGGREGATES
Description of the materialized view aggregates accessible to the user
OWNER
MVIEW_NAME
POSITION_IN_SELECT
CONTAINER_COLUMN
AGG_FUNCTION
DISTINCTFLAG
MEASURE
Owner of the materialized view
Name of the materialized view
Position of this aggregated measure with the SELECT list
Name of this column in the container table
Name of the aggregation function, one of the following:
Set to Y is this is a DISTINCT aggregation
The SQL text of the measure, excluding the aggregation function
ALL_MVIEW_ANALYSIS
Description of the materialized views accessible to the user
OWNER
MVIEW_NAME
MVIEW_TABLE_OWNER
CONTAINER_NAME
LAST_REFRESH_SCN
LAST_REFRESH_DATE
REFRESH_METHOD
SUMMARY
FULLREFRESHTIM
INCREFRESHTIM
CONTAINS_VIEWS
UNUSABLE
RESTRICTED_SYNTAX
INC_REFRESHABLE
KNOWN_STALE
INVALID
REWRITE_ENABLED
QUERY_LEN
QUERY
REVISION
Owner of the materialized view
Name of the materialized view
Owner of the container table
Name of the container table for this materialized view
The SCN of the last transaction to refresh the materialized view
The date of the last refresh of the materialized view
User declared method of refresh for the materialized view
Indicates if the materialized view includes the GROUP BY clause
The time that it took to fully refresh the materialized view
The time that it took to incrementally refresh the materialized view
This materialized view contains views in the FROM clause
This materialized view is unusable, the build was deferred
This materialized view contains restrictive syntax
This materialized view is not restricted from being incrementally refreshed
This materialized view is directly stale
Invalidity of the materialized view, Y = INVALID, N = VALID
This materialized view is enabled for query rewrite
The length (in bytes) of the query field
SELECT expression of the materialized view definition
Reserved for internal use
ALL_MVIEW_DETAIL_RELATIONS
Description of the materialized view detail tables accessible to the user
OWNER
MVIEW_NAME
DETAILOBJ_OWNER
DETAILOBJ_NAME
DETAILOBJ_TYPE
DETAILOBJ_ALIAS
Owner of the materialized view
Name of the materialized view
Owner of the detail relation
Name of the materialized view detail table
Type of materialized view detail table type
Alias of the detail relation if used
ALL_MVIEW_JOINS
Description of a join between two columns in the
OWNER
MVIEW_NAME
DETAILOBJ1_OWNER
DETAILOBJ1_RELATION
DETAILOBJ1_COLUMN
OPERATOR
OPERATOR_TYPE
DETAILOBJ2_OWNER
DETAILOBJ2_RELATION
DETAILOBJ2_COLUMN
Owner of the materialized view
Name of the materialized view
Owner of the 1st detail object
Name of the 1st detail object
Name of the 1st detail object column
Name of the join operator. Currently only = is defined
Owner of the 2nd detail object
Name of the 2nd detail object
Name of the 2nd detail object column
ALL_MVIEW_KEYS
Description of the columns that appear in the GROUP BY
OWNER
MVIEW_NAME
POSITION_IN_SELECT
CONTAINER_COLUMN
DETAILOBJ_OWNER
DETAILOBJ_NAME
DETAILOBJ_ALIAS
DETAILOBJ_TYPE
DETAILOBJ_COLUMN
Owner of the materialized view
Name of the materialized view
Position of this key within the SELECT list
Name of the column in the container table
Owner of the detail object
Name of the detail object
Alias of the detail object
Type of the detail object: VIEW or TABLE
Name of the detail object column
ALL_MVIEW_LOGS
All materialized view logs in the database that the user can see
LOG_OWNER
MASTER
LOG_TABLE
LOG_TRIGGER
ROWIDS
PRIMARY_KEY
OBJECT_ID
FILTER_COLUMNS
SEQUENCE
INCLUDE_NEW_VALUES
Owner of the materialized view log
Name of the master table which changes are logged
Log table; with rowids and timestamps of rows which changed in the master
An after-row trigger on the master which inserts rows into the log
If YES, the materialized view log records rowid information
If YES, the materialized view log records primary key information
If YES, the materialized view log records object id information
If YES, the materialized view log records filter column information
If YES, the materialized view log records sequence information
If YES, the materialized view log records old and new values (else only old values)
ALL_MVIEW_REFRESH_TIMES
Materialized views and their last refresh times for each master table that the user can look at
OWNER
NAME
MASTER_OWNER
MASTER
LAST_REFRESH
Owner of the materialized view
The view used by users and applications for viewing the MV
Owner of the master table
Name of the master table
SYSDATE from the master site at the time of the last refresh
ALL_MVIEWS
All materialized views in the database
OWNER
MVIEW_NAME
CONTAINER_NAME
QUERY
QUERY_LEN
UPDATABLE
UPDATE_LOG
MASTER_ROLLBACK_SEG
MASTER_LINK
REWRITE_ENABLED
REWRITE_CAPABILITY
REFRESH_MODE
REFRESH_METHOD
BUILD_MODE
FAST_REFRESHABLE
LAST_REFRESH_TYPE
LAST_REFRESH_DATE
STALENESS
AFTER_FAST_REFRESH
UNKNOWN_PREBUILT
UNKNOWN_PLSQL_FUNC
UNKNOWN_EXTERNAL_TABLE
UNKNOWN_CONSIDER_FRESH
UNKNOWN_IMPORT
COMPILE_STATE
USE_NO_INDEX
Owner of the materialized view
Name of the materialized view
Name of the materialized view container table
The defining query that the materialized view instantiates
The number of bytes in the defining query (based on the server character set
Indicates whether the materialized view can be updated
Name of the table that logs changes to an updatable materialized view
Name of the rollback segment to use at the master site
Name of the database link to the master site
Indicates whether rewrite is enabled for the materialized view
Indicates the kind of rewrite that is enabled
Indicates how and when the materialized view will be refreshed
The default refresh method for the materialized view (complete, fast, ...)
How and when to initially build (load) the materialized view container
Indicates the kinds of operations that can be fast refreshed for the MV
Indicates the kind of refresh that was last performed on the MV
The date that the materialized view was last refreshed
Indicates the staleness state of the materialized view (fresh, stale, ...)
Indicates the staleness state the MV will have after a fast refresh is done
Indicates if the materialized view is prebuilt
Indicates if the materialized view contains PL/SQL function
Indicates if the materialized view contains external tables
Indicates if the materialized view is considered fresh
Indicates if the materialized view is imported
Indicates the validity of the MV meta-data
Indicates whether the MV uses no index
ALL_NESTED_TABLES
Description of nested tables in tables accessible to the user
OWNER
TABLE_NAME
TABLE_TYPE_OWNER
TABLE_TYPE_NAME
PARENT_TABLE_NAME
PARENT_TABLE_COLUMN
STORAGE_SPEC
RETURN_TYPE
ELEMENT_SUBSTITUTABLE
Owner of the nested table
Name of the nested table
Owner of the type of which the nested table was created
Name of the type of the nested table
Name of the parent table containing the nested table
Column name of the parent table that corresponds to the nested table
Indication of whether the nested table element is substitutable or not
ALL_OBJ_COLATTRS
Description of object columns and attributes contained in the tables accessible to the user
OWNER
TABLE_NAME
COLUMN_NAME
SUBSTITUTABLE
Owner of the table
Name of the table containing the object column or attribute
Fully qualified name of the object column or attribute
Indication of whether the column is substitutable or not
ALL_OBJECT_TABLES
Description of all object tables accessible to the user
Owner of the table
Name of the table
Name of the tablespace containing the table
Name of the cluster, if any, to which the table belongs
Name of the index-only table, if any, to which the overflow or mapping table entry belongs
Minimum percentage of free space in a block
Minimum percentage of used space in a block
Initial number of transactions
Maximum number of transactions
Size of the initial extent in bytes
Size of secondary extents in bytes
Minimum number of extents allowed in the segment
Maximum number of extents allowed in the segment
Percentage increase in extent size
Number of process freelists allocated in this segment
Number of freelist groups allocated in this segment
Logging attribute
Has table been backed up since last modification?
The number of rows in the table
The number of used blocks in the table
The number of empty (never used) blocks in the table
The average available free space in the table
The number of chained rows in the table
The average row length, including row overhead
The average freespace of all blocks on a freelist
The number of blocks on the freelist
The number of threads per instance for scanning the table
The number of instances across which the table is to be scanned
Whether the table is to be cached in the buffer cache
Whether table locking is enabled or disabled
The sample size used in analyzing this table
The date of the most recent time this table was analyzed
Is this table partitioned? YES or NO
If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL
If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
Owner of the type of the table if the table is an object table
Type of the table if the table is an object table
Can the current session only see data that it place in this object itself?
Is this table object created as part of icreate for domain indexes?
Is the table a nested table?
The default buffer pool to be used for table blocks
Whether partitioned row movement is enabled or disabled
Are the statistics calculated without merging underlying partitions?
Were the statistics entered directly by the user?
If temporary table, then duration is sys$session or sys$transaction else NULL
Whether skip corrupt blocks is enabled or disabled
Should we keep track of the amount of modification?
Owner of the cluster, if any, to which the table belongs
Should we keep track of row level dependencies?
OWNER
TABLE_NAME
TABLESPACE_NAME
CLUSTER_NAME
IOT_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
BACKED_UP
NUM_ROWS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
AVG_SPACE_FREELIST_BLOCKS
NUM_FREELIST_BLOCKS
DEGREE
INSTANCES
CACHE
TABLE_LOCK
SAMPLE_SIZE
LAST_ANALYZED
PARTITIONED
IOT_TYPE
OBJECT_ID_TYPE
TABLE_TYPE_OWNER
TABLE_TYPE
TEMPORARY
SECONDARY
NESTED
BUFFER_POOL
ROW_MOVEMENT
GLOBAL_STATS
USER_STATS
DURATION
SKIP_CORRUPT
MONITORING
CLUSTER_OWNER
DEPENDENCIES
ALL_OBJECTS
Objects accessible to the user
OWNER
OBJECT_NAME
SUBOBJECT_NAME
OBJECT_ID
DATA_OBJECT_ID
OBJECT_TYPE
CREATED
LAST_DDL_TIME
TIMESTAMP
STATUS
TEMPORARY
GENERATED
SECONDARY
Username of the owner of the object
Name of the object
Name of the sub-object (for example, partititon)
Object number of the object
Object number of the segment which contains the object
Type of the object
Timestamp for the creation of the object
Timestamp for the last DDL change (including GRANT and REVOKE) to the object
Timestamp for the specification of the object
Status of the object
Can the current session only see data that it placed in this object itself?
Was the name of this object system generated?
Is this a secondary object created as part of icreate for domain indexes?
ALL_OLAP_ALTER_SESSION
Synonym for V$OLAP_ALTER_SESSION
ROLE
CLAUSE_TEXT
ALL_OPANCILLARY
All ancillary operators available to the user
OWNER
OPERATOR_NAME
BINDING#
PRIMOP_OWNER
PRIMOP_NAME
PRIMOP_BIND#
Owner of ancillary operator
Name of ancillary operator
Binding number of ancillary operator
Owner of primary operator
Name of primary operator
Binding number of primary operator
ALL_OPARGUMENTS
All arguments of the operators available to the user
OWNER
OPERATOR_NAME
BINDING#
POSITION
ARGUMENT_TYPE
Owner of the operator
Name of the operator
Binding# of the operator
Position of the operator argument
Datatype of the operator argument
ALL_OPBINDINGS
All binding functions for operators available to the user
OWNER
OPERATOR_NAME
BINDING#
FUNCTION_NAME
RETURN_SCHEMA
RETURN_TYPE
IMPLEMENTATION_TYPE_SCHEMA
IMPLEMENTATION_TYPE
PROPERTY
Owner of the operator
Name of the operator
Binding# of the operator
Name of the binding function or method as specified by the user
Name of the schema of the return type - not null only for ADTs
Name of the return type
Schema of the implementation type of the indextype
Implementation type of the indextype
Property of the operator binding
ALL_OPERATOR_COMMENTS
Comments for user-defined operators
OWNER
OPERATOR_NAME
COMMENTS
Owner of the user-defined operator
Name of the user-defined operator
Comment for the user-defined operator
ALL_OPERATORS
All operators available to the user
OWNER
OPERATOR_NAME
NUMBER_OF_BINDS
Owner of the operator
Name of the operator
Number of bindings associated with the operator
ALL_OUTLINE_HINTS
Synonym for USER_OUTLINE_HINTS
NAME
HINT
JOIN_POS
NODE
STAGE
Stage at which the outline is processed
Text of the hint
Position of the table in the join order
I.D. of the query or subquery to which the hint applies
Stage at which outline is processed
ALL_OUTLINES
Synonym for USER_OUTLINES
Name of the outline
SQL text of the query
Signature uniquely identifying the outline SQL text
Oracle Version that created the outline
Category to which the outline belongs
Flag indicating whether the outline has ever been used
Timestamp at which the outline was created
NAME
SQL_TEXT
SIGNATURE
VERSION
CATEGORY
USED
TIMESTAMP
OWNER
TABLE_NAME
PARTITION_NAME
COLUMN_NAME
NUM_DISTINCT
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
SAMPLE_SIZE
LAST_ANALYZED
GLOBAL_STATS
USER_STATS
AVG_COL_LEN
OWNER
TABLE_NAME
PARTITION_NAME
COLUMN_NAME
BUCKET_NUMBER
ENDPOINT_VALUE
ENDPOINT_ACTUAL_VALUE
ALL_PART_COL_STATISTICS
ALL_PART_HISTOGRAMS
ALL_PART_INDEXES
TABLE_NAME
ALL_PART_KEY_COLUMNS
ALL_PART_LOBS
ALL_PART_TABLES
COL_COMMENTS
TAB_COMMENTSCOLUMN_NAME
OWNER
INDEX_NAME
TABLE_NAME
PARTITIONING_TYPE
SUBPARTITIONING_TYPE
PARTITION_COUNT
DEF_SUBPARTITION_COUNT
PARTITIONING_KEY_COUNT
SUBPARTITIONING_KEY_COUNT
LOCALITY
ALIGNMENT
DEF_TABLESPACE_NAME
DEF_PCT_FREE
DEF_INI_TRANS
DEF_MAX_TRANS
DEF_INITIAL_EXTENT
DEF_NEXT_EXTENT
DEF_MIN_EXTENTS
DEF_MAX_EXTENTS
DEF_PCT_INCREASE
DEF_FREELISTS
DEF_FREELIST_GROUPS
DEF_LOGGING
DEF_BUFFER_POOL
DEF_PARAMETERS
OWNER
NAME
OBJECT_TYPE
COLUMN_NAME
COLUMN_POSITION
TABLE_OWNER
TABLE_NAME
COLUMN_NAME
LOB_NAME
LOB_INDEX_NAME
DEF_CHUNK
DEF_PCTVERSION
DEF_CACHE
DEF_IN_ROW
DEF_TABLESPACE_NAME
DEF_INITIAL_EXTENT
DEF_NEXT_EXTENT
DEF_MIN_EXTENTS
DEF_MAX_EXTENTS
DEF_PCT_INCREASE
DEF_FREELISTS
DEF_FREELIST_GROUPS
DEF_LOGGING
DEF_BUFFER_POOL
OWNER
TABLE_NAME
PARTITIONING_TYPE
SUBPARTITIONING_TYPE
PARTITION_COUNT
DEF_SUBPARTITION_COUNT
PARTITIONING_KEY_COUNT
SUBPARTITIONING_KEY_COUNT
DEF_TABLESPACE_NAME
DEF_PCT_FREE
DEF_PCT_USED
DEF_INI_TRANS
DEF_MAX_TRANS
DEF_INITIAL_EXTENT
DEF_NEXT_EXTENT
DEF_MIN_EXTENTS
DEF_MAX_EXTENTS
DEF_PCT_INCREASE
DEF_FREELISTS
DEF_FREELIST_GROUPS
DEF_LOGGING
DEF_COMPRESSION
DEF_BUFFER_POOL
ALL_PARTIAL_DROP_TABS
All tables with patially dropped columns accessible to the user
OWNER
TABLE_NAME
Owner of the table
Name of the table
ALL_PENDING_CONV_TABLES
All tables accessible to the user which are not upgraded to the latest type version
OWNER
TABLE_NAME
Owner of the table
Name of the table
ALL_POLICIES
All policies for objects if the user has system privileges or owns the objects
OBJECT_OWNER
OBJECT_NAME
POLICY_GROUP
POLICY_NAME
PF_OWNER
PACKAGE
FUNCTION
SEL
INS
UPD
DEL
CHK_OPTION
ENABLE
STATIC_POLICY
Owner of the synonym, table, or view
Name of the synonym, table, or view
Name of the policy
Owner of the policy function
Name of the package containing the policy function
Name of the policy function
If YES, policy is applied to query on the object
If YES, policy is applied to insert on the object
If YES, policy is applied to update on the object
If YES, policy is applied to delete on the object
Is check option enforced for this policy?
Is this policy is enabled?
Is this policy is static?
ALL_POLICY_CONTEXTS
All policy driving context defined for all synonyms, tables, or views accessable to the user
OBJECT_OWNER
OBJECT_NAME
NAMESPACE
ATTRIBUTE
Schema of the synonym, table, or view
Name of the synonym, table, or view
Namespace of the context
Attribute of the context
ALL_POLICY_GROUPS
All policy groups defined for any synonym, table or view accessable to the user
Schema of the synonym, table, or view
Name of the synonym, table, or view
Policy group defined
ALL_PROBE_OBJECTS
OBJECT_OWNER
OBJECT_NAME
POLICY_GROUP
OWNER
OBJECT_NAME
SUBOBJECT_NAME
OBJECT_ID
DATA_OBJECT_ID
OBJECT_TYPE
CREATED
LAST_DDL_TIME
TIMESTAMP
STATUS
TEMPORARY
GENERATED
SECONDARY
DEBUGINFO
ALL_PROCEDURES
Description of all procedures available to the user
OWNER
OBJECT_NAME
PROCEDURE_NAME
AGGREGATE
PIPELINED
IMPLTYPEOWNER
IMPLTYPENAME
PARALLEL
INTERFACE
DETERMINISTIC
AUTHID
Name of the object : top level function/procedure/package name
Name of the procedure
Is it an aggregate function ?
Is it a pipelined table function ?
Name of the owner of the implementation type (if any)
Name of the implementation type (if any)
Is the procedure parallel enabled ?
ALL_PROPAGATION
Streams propagation seen by the user
PROPAGATION_NAME
SOURCE_QUEUE_OWNER
SOURCE_QUEUE_NAME
DESTINATION_QUEUE_OWNER
DESTINATION_QUEUE_NAME
DESTINATION_DBLINK
RULE_SET_OWNER
RULE_SET_NAME
name of the Streams propagation
owner of the propgation source queue
name of the propagation source queue
owner of the propagation destination queue
name of the propagation destination queue
database link to access the propagation destination queue
propagation rule set owner
propagation rule set name
ALL_PUBLISHED_COLUMNS
ALL_QUEUE_PUBLISHERS
CHANGE_SET_NAME
SOURCE_SCHEMA_NAME
SOURCE_TABLE_NAME
PUB_ID
COLUMN_NAME
DATA_TYPE
DATA_LENGTH
DATA_PRECISION
DATA_SCALE
NULLABLE
QUEUE_OWNER
QUEUE_NAME
PUBLISHER_NAME
PUBLISHER_ADDRESS
PUBLISHER_PROTOCOL
PUBLISHER_RULE
PUBLISHER_RULE_NAME
PUBLISHER_RULESET
PUBLISHER_TRANSFORMATION
ALL_QUEUE_TABLES
All queue tables accessible to the user
OWNER
QUEUE_TABLE
TYPE
OBJECT_TYPE
SORT_ORDER
RECIPIENTS
MESSAGE_GROUPING
COMPATIBLE
PRIMARY_INSTANCE
SECONDARY_INSTANCE
OWNER_INSTANCE
USER_COMMENT
SECURE
Owner of the queue table
Name of the queue table
Name of the payload type
Name of the payload type for object type payload
Sort order for the queue table
Mulitple or single recipient queue
Transaction grouping
Compatibility version of the queue table
Instance assigned as the primary owner of the queue table
Instance assigned as the secondary owner of the queue table
Instance which owns the queue table currently
User specified comment
Secure queue table
ALL_QUEUES
All queues accessible to the user
OWNER
NAME
QUEUE_TABLE
QID
QUEUE_TYPE
MAX_RETRIES
RETRY_DELAY
ENQUEUE_ENABLED
DEQUEUE_ENABLED
RETENTION
USER_COMMENT
Owner of the queue
Name of the queue
Name of the table the queue data resides in
Object number of the queue
Type of the queue
Maximum number of retries allowed when dequeuing from the queue
Time interval between retries
Queue is enabled for enqueue
Queue is enabled for dequeue
Time interval processed messages retained in the queue
User specified comment
ALL_REFRESH
All the refresh groups that the user can touch
ROWNER
RNAME
REFGROUP
IMPLICIT_DESTROY
PUSH_DEFERRED_RPC
REFRESH_AFTER_ERRORS
ROLLBACK_SEG
JOB
NEXT_DATE
INTERVAL
BROKEN
PURGE_OPTION
PARALLELISM
HEAP_SIZE
Name of the owner of the refresh group
Name of the refresh group
Internal identifier of refresh group
Y or N, if Y then destroy the refresh group when its last item is subtracted
Y or N, if Y then push changes from snapshot to master before refresh
If Y, proceed with refresh despite error when pushing deferred RPCs
Name of the rollback segment to use while refreshing
Identifier of job used to automatically refresh the group
Date that this job will next be automatically refreshed, if not broken
A date function used to compute the next NEXT_DATE
Y or N, Y is the job is broken and will never be run
The method for purging the transaction queue after each push
The level of parallelism for transaction propagation
The heap size used for transaction propagation
ALL_REFRESH_CHILDREN
All the objects in refresh groups, where the user can touch the group
OWNER
NAME
TYPE
ROWNER
RNAME
REFGROUP
IMPLICIT_DESTROY
PUSH_DEFERRED_RPC
REFRESH_AFTER_ERRORS
ROLLBACK_SEG
JOB
NEXT_DATE
INTERVAL
BROKEN
PURGE_OPTION
PARALLELISM
HEAP_SIZE
Owner of the object in the refresh group
Name of the object in the refresh group
Type of the object in the refresh group
Name of the owner of the refresh group
Name of the refresh group
Internal identifier of refresh group
Y or N, if Y then destroy the refresh group when its last item is subtracted
Y or N, if Y then push changes from snapshot to master before refresh
If Y, proceed with refresh despite error when pushing deferred RPCs
Name of the rollback segment to use while refreshing
Identifier of job used to automatically refresh the group
Date that this job will next be automatically refreshed, if not broken
A date function used to compute the next NEXT_DATE
Y or N, Y is the job is broken and will never be run
The method for purging the transaction queue after each push
The level of parallelism for transaction propagation
The heap size used for transaction propagation
ALL_REFRESH_DEPENDENCIES
Description of the detail tables that materialized views depend on for
OWNER
TABLE_NAME
PARENT_OBJECT_TYPE
OLDEST_REFRESH_SCN
OLDEST_REFRESH_DATE
Owner of the dependent table
Name of the dependent table
Materialized View
The oldest scn of a dependent materialized view
The oldest date scn of a dependent materialized view
ALL_REFS
Description of REF columns contained in tables accessible to the user
OWNER
TABLE_NAME
COLUMN_NAME
WITH_ROWID
IS_SCOPED
SCOPE_TABLE_OWNER
SCOPE_TABLE_NAME
OBJECT_ID_TYPE
Owner of the table containing the REF column
Name of the table containing the REF column
Column name or attribute of object column
Is the REF value stored with the rowid?
Is the REF column scoped?
Owner of the scope table, if it exists
Name of the scope table, if it exists
If ref contains user-defined OID, then USER-DEFINED, else if it contains system
ALL_REGISTERED_MVIEWS
Remote materialized views of local tables that the user can see
OWNER
NAME
MVIEW_SITE
CAN_USE_LOG
UPDATABLE
REFRESH_METHOD
MVIEW_ID
VERSION
QUERY_TXT
Owner of the materialized view
The name of the materialized view
Global name of the materialized view site
If NO, this materialized view is complex and cannot fast refresh
If NO, the materialized view is read only
Whether the materialized view uses rowid or primary key or object id for fast refresh
Identifier for the materialized view used by the master for fast refresh
Version of materialized view
Query defining the materialized view
ALL_REGISTERED_SNAPSHOTS
Remote snapshots of local tables that the user can see
OWNER
NAME
SNAPSHOT_SITE
CAN_USE_LOG
UPDATABLE
REFRESH_METHOD
SNAPSHOT_ID
VERSION
QUERY_TXT
BANNER
Owner of the snapshot
The name of the snapshot
Global name of the snapshot site
If NO, this snapshot is complex and cannot fast refresh
If NO, the snapshot is read only
Whether the snapshot uses rowid or primary key or object id for fast refresh
Identifier for the snapshot used by the master for fast refresh
Version of snapshot
Query defining the snapshot
ALL_REGISTRY_BANNERS
ALL_REPAUDIT_ATTRIBUTE
Information about attributes automatically maintained for replication
ATTRIBUTE
DATA_TYPE
DATA_LENGTH
SOURCE
Description of the attribute
Datatype of the attribute value
Length of the attribute value in byte
Name of the function which returns the attribute value
ALL_REPAUDIT_COLUMN
Information about columns in all shadow tables for replicated tables which are accessible to the user
SNAME
ONAME
COLUMN_NAME
BASE_SNAME
BASE_ONAME
BASE_CONFLICT_TYPE
BASE_REFERENCE_NAME
Owner of the shadow table
Name of the shadow table
Name of the column in the shadow table
Owner of replicated table
Name of the replicated table
Type of conflict
Table name, unique constraint name, or column group name
TABLE_NAME
ALL_REPCAT
TAB_COMMENTSCOLUMN_NAME
ATTRIBUTE
COL_COMMENTS
Description of the attribute
SNAME
MASTER
STATUS
SCHEMA_COMMENT
GNAME
FNAME
RPC_PROCESSING_DISABLED
OWNER
ALL_REPCATLOG
Information about asynchronous administration requests
ID
SOURCE
USERID
TIMESTAMP
ROLE
MASTER
SNAME
REQUEST
ONAME
TYPE
STATUS
MESSAGE
ERRNUM
GNAME
Identifying number of repcat log record
Name of the database at which the request originated
Name of the user who submitted the request
When the request was submitted
Is this database the masterdef for the request
Name of the database that processes this request
Schema of replicated object name, if applicable
Name of the requested operation
Replicated object name, if applicable
Type of replicated object, if applicable
Status of the request at this database
Error message associated with processing the request
Oracle error number associated with processing the request
Name of the replicated object group
ALL_REPCOLUMN
Replicated top-level columns (table) sorted alphabetically in ascending order
SNAME
ONAME
TYPE
CNAME
ID
POS
COMPARE_OLD_ON_DELETE
COMPARE_OLD_ON_UPDATE
SEND_OLD_ON_DELETE
SEND_OLD_ON_UPDATE
CTYPE
CTYPE_TOID
CTYPE_OWNER
CTYPE_HASHCODE
CTYPE_MOD
DATA_LENGTH
DATA_PRECISION
DATA_SCALE
NULLABLE
CHARACTER_SET_NAME
TOP
CHAR_LENGTH
CHAR_USED
Name of the object owner
Name of the object
Type of the object
Name of the replicated column
ID of the replicated column
Ordering of the replicated column
Compare the old value of the column in replicated deletes
Compare the old value of the column in replicated updates
Send the old value of the column in replicated deletes
Send the old value of the column in replicated updates
Type of the column
Type OID of a column of TYPE
Type owner of a column of TYPE
Type hashcode of a column of TYPE
Datatype modifier of a column
Length of the column in bytes
Length: decimal digits (NUMBER) or binary digits (FLOAT)
Digits to right of decimal point in a number
Does column allow NULL values?
Name of character set for column, if applicable
Top column name for an attribute
The maximim length of the column in characters
C if the width was specified in characters, B if in bytes
ALL_REPCOLUMN_GROUP
All column groups of replicated tables which are accessible to the user
SNAME
ONAME
GROUP_NAME
GROUP_COMMENT
Owner of replicated object
Name of the replicated object
Name of the column group
Description of the column group
ALL_REPCONFLICT
All conflicts with available resolutions for user's replicated tables
SNAME
ONAME
CONFLICT_TYPE
REFERENCE_NAME
Owner of replicated object
Name of the replicated object
Type of conflict
Table name, unique constraint name, or column group name
ALL_REPDDL
Arguments that do not fit in a single repcat log record
LOG_ID
SOURCE
ROLE
MASTER
LINE
TEXT
DDL_NUM
Identifying number of the repcat log record
Name of the database at which the request originated
Is this database the masterdef for the request
Name of the database that processes this request
Ordering of records within a single request
Portion of an argument
Order of ddls to execute
ALL_REPFLAVOR_COLUMNS
Replicated columns in flavors
FNAME
GNAME
SNAME
ONAME
CNAME
TYPE
POS
GROUP_OWNER
TYPE_TOID
TYPE_OWNER
TYPE_HASHCODE
TYPE_MOD
TOP
Flavor name
Object group name
Schema containing the object
Object name
Column name
Column type
Ordering of column used as IN parameter in the replication procedures
Object group owner
Type OID of a column of TYPE
Type owner of a column of TYPE
Type hashcode of a column of TYPE
Datatype modifier of a column
Top column of this attribute column
ALL_REPFLAVOR_OBJECTS
Replicated objects in flavors
FNAME
GNAME
SNAME
ONAME
TYPE
GROUP_OWNER
Flavor name
Object group name
Schema containing object
Name of object
Object type
Object group owner
ALL_REPFLAVORS
Flavors defined for replicated object groups
FLAVOR_ID
GNAME
FNAME
CREATION_DATE
CREATED_BY
PUBLISHED
GROUP_OWNER
Flavor identifier, unique within object group
Name of the object group
Name of the flavor
Date on which the flavor was created
User that created the flavor
Indicates whether flavor is published (Y/N) or obsolete (O)
ALL_REPGENERATED
Objects generated to support replication
SNAME
ONAME
TYPE
BASE_SNAME
BASE_ONAME
BASE_TYPE
PACKAGE_PREFIX
PROCEDURE_PREFIX
DISTRIBUTED
REASON
Schema containing the generated object
Name of the generated object
Type of the generated object
Name of the object's owner
Name of the object
Type of the object
Prefix for package wrapper
Procedure prefix for package wrapper or procedure wrapper
Is the generated object separately generated at each master
Reason the object was generated
ALL_REPGENOBJECTS
Objects generated to support replication
SNAME
ONAME
TYPE
BASE_SNAME
BASE_ONAME
BASE_TYPE
PACKAGE_PREFIX
PROCEDURE_PREFIX
DISTRIBUTED
REASON
Schema containing the generated object
Name of the generated object
Type of the generated object
Name of the object's owner
Name of the object
Type of the object
Prefix for package wrapper
Procedure prefix for package wrapper or procedure wrapper
Is the generated object separately generated at each master
Reason the object was generated
ALL_REPGROUP
Information about replicated object groups
SNAME
MASTER
STATUS
SCHEMA_COMMENT
GNAME
FNAME
RPC_PROCESSING_DISABLED
OWNER
OBSOLETE COLUMN: Name of the replicated schema
Is the site a master site for the replicated object group
If the site is a master, the master's status
Description of the replicated object group
Name of the replicated object group
Flavor name
Owner of the replicated object group
ALL_REPGROUP_PRIVILEGES
Information about users who are registered for object group privileges
USERNAME
GNAME
CREATED
RECEIVER
PROXY_SNAPADMIN
OWNER
Name of the user
Name of the replicated object group
Registration date
Receiver privileges
Proxy snapadmin privileges
Owner of the replicated object group
ALL_REPGROUPED_COLUMN
Columns in the all column groups of replicated tables which are accessible to the user
SNAME
ONAME
GROUP_NAME
COLUMN_NAME
Owner of replicated object
Name of the replicated object
Name of the column group
Name of the column in the column group
ALL_REPKEY_COLUMNS
Primary columns for a table using column-level replication
SNAME
ONAME
COL
Schema containing table
Name of the table
Column in the table
ALL_REPOBJECT
Information about replicated objects
SNAME
ONAME
TYPE
STATUS
GENERATION_STATUS
ID
OBJECT_COMMENT
GNAME
MIN_COMMUNICATION
REPLICATION_TRIGGER_EXISTS
INTERNAL_PACKAGE_EXISTS
GROUP_OWNER
NESTED_TABLE
Name of the object owner
Name of the object
Type of the object
Status of the last create or alter request on the local object
Status of whether the object needs to generate replication packages
Identifier of the local object
Description of the replicated object
Name of the replicated object group
Send only necessary OLD and NEW values for an updated row?
Internal replication trigger exists?
Internal package exists?
Owner of the replicated object group
Storage table for a nested table column?
ALL_REPPARAMETER_COLUMN
All columns used for resolving conflicts in replicated tables which are accessible to the user
SNAME
ONAME
CONFLICT_TYPE
REFERENCE_NAME
SEQUENCE_NO
METHOD_NAME
FUNCTION_NAME
PRIORITY_GROUP
PARAMETER_TABLE_NAME
PARAMETER_COLUMN_NAME
PARAMETER_SEQUENCE_NO
Owner of replicated object
Name of the replicated object
Type of conflict
Table name, unique constraint name, or column group name
Ordering on resolution
Name of the table to which the parameter column belongs
Name of the parameter column used for resolving the conflict
Ordering on parameter column
ALL_REPPRIORITY
Values and their corresponding priorities in all priority groups which are accessible to the user
SNAME
PRIORITY_GROUP
PRIORITY
DATA_TYPE
FIXED_DATA_LENGTH
CHAR_VALUE
VARCHAR2_VALUE
NUMBER_VALUE
DATE_VALUE
RAW_VALUE
GNAME
NCHAR_VALUE
NVARCHAR2_VALUE
LARGE_CHAR_VALUE
OBSOLETE COLUMN: Name of the replicated schema
Name of the priority group
Priority of the value
Datatype of the value
Length of the value in bytes if the datatype is CHAR
Blank-padded character string
Character string
Numeric value
Date value
Raw value
Name of the replicated object group
NCHAR string
NVARCHAR2 string
Blank-padded character string over 255 characters
ALL_REPPRIORITY_GROUP
Information about all priority groups which are accessible to the user
SNAME
PRIORITY_GROUP
DATA_TYPE
FIXED_DATA_LENGTH
PRIORITY_COMMENT
GNAME
OBSOLETE COLUMN: Name of the replicated schema
Name of the priority group
Datatype of the value in the priority group
Length of the value in bytes if the datatype is CHAR
Description of the priority group
Name of the replicated object group
ALL_REPPROP
Propagation information about replicated objects
SNAME
ONAME
TYPE
DBLINK
HOW
PROPAGATE_COMMENT
Name of the object owner
Name of the object
Type of the object
Destination database for propagation
Propagation choice for the destination database
Description of the propagation choice
ALL_REPRESOL_STATS_CONTROL
Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
SNAME
ONAME
CREATED
STATUS
STATUS_UPDATE_DATE
PURGED_DATE
LAST_PURGE_START_DATE
LAST_PURGE_END_DATE
Owner of replicated object
Name of the replicated object
Timestamp for which statistics collection was first started
Status of statistics collection: ACTIVE, CANCELLED
Timestamp for which the status was last updated
Timestamp for the last purge of statistics data
The last start date of the statistics purging date range
The last end date of the statistics purging date range
ALL_REPRESOLUTION
Description of all conflict resolutions for replicated tables which are accessible to the user
SNAME
ONAME
CONFLICT_TYPE
REFERENCE_NAME
SEQUENCE_NO
METHOD_NAME
FUNCTION_NAME
PRIORITY_GROUP
RESOLUTION_COMMENT
Owner of replicated object
Name of the replicated object
Type of conflict
Table name, unique constraint name, or column group name
Ordering on resolution
Name of the conflict resolution method
Name of the resolution function
Name of the priority group used in conflict resolution
Description of the conflict resolution
ALL_REPRESOLUTION_METHOD
All conflict resolution methods accessible to the user
Type of conflict
Name of the conflict resolution method
CONFLICT_TYPE
METHOD_NAME
ALL_REPRESOLUTION_STATISTICS
Statistics for conflict resolutions for replicated tables which are accessible to the user
SNAME
ONAME
CONFLICT_TYPE
REFERENCE_NAME
METHOD_NAME
FUNCTION_NAME
PRIORITY_GROUP
RESOLVED_DATE
PRIMARY_KEY_VALUE
Owner of replicated object
Name of the replicated object
Type of conflict
Table name, unique constraint name, or column group name
Name of the conflict resolution method
Name of the resolution function
Name of the priority group used in conflict resolution
Timestamp for the resolution of the conflict
Primary key of the replicated row (character data)
ALL_REPSCHEMA
N-way replication information
SNAME
DBLINK
MASTERDEF
SNAPMASTER
MASTER_COMMENT
GNAME
MASTER
GROUP_OWNER
OBSOLETE COLUMN: Name of the replicated schema
A database site replicating the object group
Is the database the master definition site for the replicated object group
For a snapshot site, is the database the current refresh master
Description of the database site
Name of the replicated object group
Redundant information from all_repcat.master
Owner of the replicated object group
ALL_REPSITES
N-way replication information
GNAME
DBLINK
MASTERDEF
SNAPMASTER
MASTER_COMMENT
MASTER
GROUP_OWNER
Name of the replicated object group
A database site replicating the schema
Is the database the master definition site for the replicated object group
For a snapshot site, is the database the current refresh master
Description of the database site
Redundant information from all_repcat.master
Owner of the replicated object group
ALL_RULE_SET_RULES
Rules in all rule sets seen by the user
RULE_SET_OWNER
RULE_SET_NAME
RULE_OWNER
RULE_NAME
RULE_SET_RULE_ENABLED
RULE_SET_RULE_EVAL_CTX_OWNER evaluation context owner specified when the rule is added to this rule set
RULE_SET_RULE_EVAL_CTX_NAME evaluation context name specified when the rule is added to this rule set
RULE_SET_RULE_COMMENT
Owner of the rule set
Name of the rule set
Owner of the rule
Name of the rule
Whether the rule is enabled in this ruleset
User description of this mapping
ALL_RULE_SETS
Rule sets seen by the user
RULE_SET_OWNER
RULE_SET_NAME
RULE_SET_EVAL_CONTEXT_OWNER The evaluation context owner name associated with the rule set, if any
RULE_SET_EVAL_CONTEXT_NAME
RULE_SET_COMMENT
The evaluation context name associated with the rule set, if any
user description of the rule set
Owner of the rule set
Name of the rule set
ALL_RULES
Rules seen by the user
RULE_OWNER
RULE_NAME
RULE_CONDITION
Owner of the rule
Name of the rule
the rule expression
TABLE_NAME
TAB_COMMENTSCOLUMN_NAME
COL_COMMENTS
RULE_EVALUATION_CONTEXT_OWNERowner of the evaluation context on which rule is defined
RULE_EVALUATION_CONTEXT_NAME name of the evaluation context on which rule is defined
RULE_ACTION_CONTEXT
RULE_COMMENT
action context of the rule
user description of the rule
ALL_RULESETS
Rulesets seen by the user: maintained for backward compatibility
OWNER
RULESET_NAME
RULESET_STORAGE_TABLE
BASE_TABLE
RULESET_COMMENT
Owner of the ruleset
Name of the ruleset
name of the table to store rules in the ruleset
name of the evaluation context for the rule set
user description of the ruleset
ALL_SECONDARY_OBJECTS
All secondary objects for domain indexes
INDEX_OWNER
INDEX_NAME
SECONDARY_OBJECT_OWNER
SECONDARY_OBJECT_NAME
Name of the domain index owner
Name of the domain index
Owner of the secondary object
Name of the secondary object
ALL_SEQUENCES
Description of SEQUENCEs accessible to the user
SEQUENCE_OWNER
SEQUENCE_NAME
MIN_VALUE
MAX_VALUE
INCREMENT_BY
CYCLE_FLAG
ORDER_FLAG
CACHE_SIZE
LAST_NUMBER
Name of the owner of the sequence
SEQUENCE name
Minimum value of the sequence
Maximum value of the sequence
Value by which sequence is incremented
Does sequence wrap around on reaching limit?
Are sequence numbers generated in order?
Number of sequence numbers to cache
Last sequence number written to disk
ALL_SNAPSHOT_LOGS
All snapshot logs in the database that the user can see
LOG_OWNER
MASTER
LOG_TABLE
LOG_TRIGGER
ROWIDS
PRIMARY_KEY
OBJECT_ID
FILTER_COLUMNS
SEQUENCE
INCLUDE_NEW_VALUES
CURRENT_SNAPSHOTS
SNAPSHOT_ID
Owner of the snapshot log
Name of the master table which changes are logged
Log table; with rowids and timestamps of rows which changed in the master
An after-row trigger on the master which inserts rows into the log
If YES, the snapshot log records rowid information
If YES, the snapshot log records primary key information
If YES, the snapshot log records object id information
If YES, the snapshot log records filter column information
If YES, the snapshot log records sequence information
If YES, the snapshot log records old and new values (else only old values)
One date per snapshot -- the date the snapshot of the master last refreshed
Unique identifier of the snapshot
ALL_SNAPSHOT_REFRESH_TIMES
Synonym for ALL_MVIEW_REFRESH_TIMES
OWNER
MASTER
LAST_REFRESH
MASTER_OWNER
NAME
Owner of the materialized view
Name of the master table
SYSDATE from the master site at the time of the last refresh
Owner of the master table
The view used by users and applications for viewing the MV
ALL_SNAPSHOTS
Snapshots the user can access
OWNER
NAME
TABLE_NAME
MASTER_VIEW
MASTER_OWNER
MASTER
MASTER_LINK
CAN_USE_LOG
UPDATABLE
REFRESH_METHOD
LAST_REFRESH
ERROR
FR_OPERATIONS
CR_OPERATIONS
TYPE
NEXT
START_WITH
REFRESH_GROUP
UPDATE_TRIG
UPDATE_LOG
QUERY
MASTER_ROLLBACK_SEG
STATUS
REFRESH_MODE
PREBUILT
Owner of the snapshot
The view used by users and applications for viewing the snapshot
Table the snapshot is stored in -- has an extra column for the master rowid
View of the master table, owned by the snapshot owner, used for refreshes
Owner of the master table
Name of the master table that this snapshot is a copy of
Database link name to the master site
If NO, this snapshot is complex and will never use a log
If NO, the snapshot is read only. Look up REPLICATION
The values used to drive a fast refresh of the snapshot
SYSDATE from the master site at the time of the last refresh
The error returned last time an automatic refresh was attempted
The type of refresh (complete,fast,force) for all automatic refreshes
The date function used to compute next refresh dates
The date function used to compute next refresh dates
All snapshots in a given refresh group get refreshed in the same transaction
The name of the trigger which fills the UPDATE_LOG
The table which logs changes made to an updatable snapshots
The original query that this snapshot is an instantiation of
Rollback segment to use at the master site
The status of the contents of the snapshot
This indicates how and when the snapshot will be refreshed
If YES, this snapshot uses a prebuilt table as the base table
ALL_SOURCE
Current source on stored objects that user is allowed to create
Owner of the object
Name of the object
Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION",
Line number of this line of source
Source text
ALL_SOURCE_TAB_COLUMNS
ALL_SOURCE_TABLES
OWNER
NAME
TYPE
LINE
TEXT
SOURCE_SCHEMA_NAME
SOURCE_TABLE_NAME
COLUMN_NAME
DATA_TYPE
DATA_LENGTH
DATA_PRECISION
DATA_SCALE
NULLABLE
SOURCE_SCHEMA_NAME
SOURCE_TABLE_NAME
ALL_SQLJ_TYPE_ATTRS
Description of attributes of types accessible to the user
ALL_SQLJ_TYPE_METHODS
OWNER
TYPE_NAME
ATTR_NAME
EXTERNAL_ATTR_NAME
ATTR_TYPE_MOD
ATTR_TYPE_OWNER
ATTR_TYPE_NAME
LENGTH
PRECISION
SCALE
CHARACTER_SET_NAME
ATTR_NO
INHERITED
Owner of the type
Name of the type
Name of the attribute
External name of the attribute
Type modifier of the attribute
Owner of the type of the attribute
Name of the type of the attribute
Length of the CHAR attribute or maximum length of the VARCHAR
Decimal precision of the NUMBER or DECIMAL attribute or
Scale of the NUMBER or DECIMAL attribute
Character set name of the attribute
Syntactical order number or position of the attribute as specified in the
Is the attribute inherited from the supertype ?
Description of methods of types accessible to the user
Owner of the type
Name of the type
Name of the method
Name of the external variable
Method number for distinguishing overloaded method (not to be used as ID number)
Type of the method
Number of parameters to the method
Number of results returned by the method
Is the method final ?
Is the method instantiable ?
Is the method overriding a supertype method ?
Is the method inherited from the supertype ?
OWNER
TYPE_NAME
METHOD_NAME
EXTERNAL_VAR_NAME
METHOD_NO
METHOD_TYPE
PARAMETERS
RESULTS
FINAL
INSTANTIABLE
OVERRIDING
INHERITED
ALL_SQLJ_TYPES
Description of types accessible to the user
OWNER
TYPE_NAME
TYPE_OID
EXTERNAL_NAME
USING
TYPECODE
ATTRIBUTES
METHODS
PREDEFINED
INCOMPLETE
FINAL
INSTANTIABLE
SUPERTYPE_OWNER
SUPERTYPE_NAME
LOCAL_ATTRIBUTES
LOCAL_METHODS
Owner of the type
Name of the type
Object identifier (OID) of the type
External class name of the type
Representation of the type
Typecode of the type
Number of attributes in the type
Number of methods in the type
Is the type a predefined type?
Is the type an incomplete type?
Is the type a final type?
Is the type an instantiable type?
Owner of the supertype (null if type is not a subtype)
Name of the supertype (null if type is not a subtype)
Number of local (not inherited) attributes (if any) in the subtype
Number of local (not inherited) methods (if any) in the subtype
ALL_STORED_SETTINGS
Parameter settings for objects accessible to the user
OWNER
OBJECT_NAME
OBJECT_ID
OBJECT_TYPE
PARAM_NAME
PARAM_VALUE
Username of the owner of the object
Name of the object
Object number of the object
Type of the object
Name of the parameter
Value of the parameter
ALL_STREAMS_GLOBAL_RULES
Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user
STREAMS_NAME
STREAMS_TYPE
RULE_TYPE
INCLUDE_TAGGED_LCR
SOURCE_DATABASE
RULE_NAME
RULE_OWNER
RULE_CONDITION
Name of the streams process: capture/propagation/apply process
Type of the streams process: CAPTURE, PROPAGATION or APPLY
Type of rule: DML or DDL
Whether or not to include tagged LCR
Name of the database where the LCRs originated
Name of the rule to be applied
Owner of the rule
Generated rule condition evaluated by the rules engine
ALL_STREAMS_SCHEMA_RULES
Rules created by streams administrative APIs on all user schemas
STREAMS_NAME
STREAMS_TYPE
SCHEMA_NAME
RULE_TYPE
INCLUDE_TAGGED_LCR
SOURCE_DATABASE
RULE_NAME
RULE_OWNER
RULE_CONDITION
Name of the streams process: capture/propagation/apply process
Type of the streams process: CAPTURE, PROPAGATION or APPLY
Name of the schema selected by this rule
Type of rule: DML or DDL
Whether or not to include tagged LCR
Name of the database where the LCRs originated
Name of the rule to be applied
Owner of the rule
Generated rule condition evaluated by the rules engine
ALL_STREAMS_TABLE_RULES
Rules created by streams administrative APIs on tables visible to the current user
Name of the streams process: capture/propagation/apply process
Type of the streams process: CAPTURE, PROPAGATION or APPLY
Owner of the table selected by this rule
Name of the table selected by this rule
Type of rule: DML or DDL
Row subsetting condition
DML operation for row subsetting
Whether or not to include tagged LCR
Name of the database where the LCRs originated
Name of the rule to be applied
Owner of the rule
Generated rule condition evaluated by the rules engine
ALL_SUBPART_COL_STATISTICS
ALL_SUBPART_HISTOGRAMS
ALL_SUBPART_KEY_COLUMNS
ALL_SUBPARTITION_TEMPLATES
ALL_SUBSCRIBED_COLUMNS
ALL_SUBSCRIBED_TABLES
ALL_SUBSCRIPTIONS
STREAMS_NAME
STREAMS_TYPE
TABLE_OWNER
TABLE_NAME
RULE_TYPE
DML_CONDITION
SUBSETTING_OPERATION
INCLUDE_TAGGED_LCR
SOURCE_DATABASE
RULE_NAME
RULE_OWNER
RULE_CONDITION
OWNER
TABLE_NAME
SUBPARTITION_NAME
COLUMN_NAME
NUM_DISTINCT
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
SAMPLE_SIZE
LAST_ANALYZED
GLOBAL_STATS
USER_STATS
AVG_COL_LEN
OWNER
TABLE_NAME
SUBPARTITION_NAME
COLUMN_NAME
BUCKET_NUMBER
ENDPOINT_VALUE
ENDPOINT_ACTUAL_VALUE
OWNER
NAME
OBJECT_TYPE
COLUMN_NAME
COLUMN_POSITION
USER_NAME
TABLE_NAME
SUBPARTITION_NAME
SUBPARTITION_POSITION
TABLESPACE_NAME
HIGH_BOUND
HANDLE
SOURCE_SCHEMA_NAME
SOURCE_TABLE_NAME
COLUMN_NAME
HANDLE
SOURCE_SCHEMA_NAME
SOURCE_TABLE_NAME
VIEW_NAME
CHANGE_SET_NAME
HANDLE
SET_NAME
USERNAME
CREATED
STATUS
EARLIEST_SCN
LATEST_SCN
DESCRIPTION
LAST_PURGED
LAST_EXTENDED
ALL_SUMDELTA
Direct path load entries accessible to the user
TABLEOBJ#
PARTITIONOBJ#
DMLOPERATION
SCN
TIMESTAMP
LOWROWID
HIGHROWID
SEQUENCE
Object number of the table
Object number of table partitions (if the table is partitioned)
Type of DML operation applied to the table
SCN when the bulk DML occurred
Timestamp of log entry
The start ROWID in the loaded rowid range
The end ROWID in the loaded rowid range
The sequence# of the direct load
ALL_SUMMARIES
Description of the summaries accessible to the user
OWNER
SUMMARY_NAME
CONTAINER_OWNER
CONTAINER_NAME
LAST_REFRESH_SCN
LAST_REFRESH_DATE
REFRESH_METHOD
SUMMARY
FULLREFRESHTIM
INCREFRESHTIM
CONTAINS_VIEWS
UNUSABLE
RESTRICTED_SYNTAX
INC_REFRESHABLE
KNOWN_STALE
QUERY_LEN
QUERY
Owner of the summary
Name of the summary
Owner of the container table
Name of the container table for this summary
The SCN of the last transaction to refresh the summary
The date of the last refresh of the summary
User declared method of refresh for the summary
Indicates the presence of either aggregation or a GROUP BY
The time that it took to fully refresh the summary
The time that it took to incrementally refresh the summary
This summary contains views in the FROM clause
This summary is unusable, the build was deferred
This summary contains restrictive syntax
This summary is not restricted from being incrementally refreshed
This summary is directly stale
ALL_SYNONYMS
All synonyms accessible to the user
OWNER
SYNONYM_NAME
TABLE_OWNER
TABLE_NAME
DB_LINK
Owner of the synonym
Name of the synonym
Owner of the object referenced by the synonym
Name of the object referenced by the synonym
Name of the database link referenced in a remote synonym
ALL_TAB_COL_STATISTICS
Columns of user's tables, views and clusters
OWNER
TABLE_NAME
COLUMN_NAME
NUM_DISTINCT
Table, view or cluster owner
Table, view or cluster name
Column name
The number of distinct values in the column
TABLE_NAME
TAB_COMMENTSCOLUMN_NAME
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
LAST_ANALYZED
SAMPLE_SIZE
GLOBAL_STATS
USER_STATS
AVG_COL_LEN
COL_COMMENTS
The low value in the column
The high value in the column
The density of the column
The number of nulls in the column
The number of buckets in histogram for the column
The date of the most recent time this column was analyzed
The sample size used in analyzing this column
Are the statistics calculated without merging underlying partitions?
Were the statistics entered directly by the user?
The average length of the column in bytes
ALL_TAB_COLS
Columns of user's tables, views and clusters
LAST_ANALYZED
SAMPLE_SIZE
CHARACTER_SET_NAME
CHAR_COL_DECL_LENGTH
GLOBAL_STATS
USER_STATS
AVG_COL_LEN
CHAR_LENGTH
CHAR_USED
V80_FMT_IMAGE
DATA_UPGRADED
HIDDEN_COLUMN
VIRTUAL_COLUMN
SEGMENT_COLUMN_ID
INTERNAL_COLUMN_ID
OWNER
TABLE_NAME
COLUMN_NAME
DATA_TYPE
DATA_TYPE_MOD
DATA_TYPE_OWNER
DATA_LENGTH
DATA_PRECISION
DATA_SCALE
NULLABLE
COLUMN_ID
DEFAULT_LENGTH
DATA_DEFAULT
NUM_DISTINCT
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
The date of the most recent time this column was analyzed
The sample size used in analyzing this column
Character set name
Declaration length of character type column
Are the statistics calculated without merging underlying partitions?
Were the statistics entered directly by the user?
The average length of the column in bytes
The maximum length of the column in characters
C if maximum length is specified in characters, B if in bytes
Is column data in 8.0 image format?
Has column data been upgraded to the latest type version format?
Is this a hidden column?
Is this a virtual column?
Sequence number of the column in the segment
Internal sequence number of the column
Table, view or cluster name
Column name
Datatype of the column
Datatype modifier of the column
Owner of the datatype of the column
Length of the column in bytes
Length: decimal digits (NUMBER) or binary digits (FLOAT)
Digits to right of decimal point in a number
Does column allow NULL values?
Sequence number of the column as created
Length of default value for the column
Default value for the column
The number of distinct values in the column
The low value in the column
The high value in the column
The density of the column
The number of nulls in the column
The number of buckets in histogram for the column
ALL_TAB_COLUMNS
Columns of user's tables, views and clusters
OWNER
TABLE_NAME
COLUMN_NAME
DATA_TYPE
DATA_TYPE_MOD
DATA_TYPE_OWNER
DATA_LENGTH
DATA_PRECISION
DATA_SCALE
NULLABLE
COLUMN_ID
DEFAULT_LENGTH
DATA_DEFAULT
NUM_DISTINCT
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
LAST_ANALYZED
SAMPLE_SIZE
CHARACTER_SET_NAME
CHAR_COL_DECL_LENGTH
GLOBAL_STATS
USER_STATS
AVG_COL_LEN
CHAR_LENGTH
CHAR_USED
V80_FMT_IMAGE
DATA_UPGRADED
Table, view or cluster name
Column name
Datatype of the column
Datatype modifier of the column
Owner of the datatype of the column
Length of the column in bytes
Length: decimal digits (NUMBER) or binary digits (FLOAT)
Digits to right of decimal point in a number
Does column allow NULL values?
Sequence number of the column as created
Length of default value for the column
Default value for the column
The number of distinct values in the column
The low value in the column
The high value in the column
The density of the column
The number of nulls in the column
The number of buckets in histogram for the column
The date of the most recent time this column was analyzed
The sample size used in analyzing this column
Character set name
Declaration length of character type column
Are the statistics calculated without merging underlying partitions?
Were the statistics entered directly by the user?
The average length of the column in bytes
The maximum length of the column in characters
C if maximum length is specified in characters, B if in bytes
Is column data in 8.0 image format?
Has column data been upgraded to the latest type version format?
ALL_TAB_COMMENTS
Comments on tables and views accessible to the user
OWNER
TABLE_NAME
TABLE_TYPE
COMMENTS
Owner of the object
Name of the object
Type of the object
Comment on the object
ALL_TAB_HISTOGRAMS
Histograms on columns of all tables visible to user
Owner of table
Table name
Column name or attribute of object column
Endpoint number
Normalized endpoint value
Actual endpoint value
OWNER
TABLE_NAME
COLUMN_NAME
ENDPOINT_NUMBER
ENDPOINT_VALUE
ENDPOINT_ACTUAL_VALUE
ALL_TAB_MODIFICATIONS
Information regarding modifications to tables
Owner of modified table
Modified table
Modified partition
Modified subpartition
Approximate number of rows inserted since last analyze
Approximate number of rows updated since last analyze
Approximate number of rows deleted since last analyze
Timestamp of last time this row was modified
Was this object truncated since the last analyze?
ALL_TAB_PARTITIONS
TABLE_OWNER
TABLE_NAME
PARTITION_NAME
SUBPARTITION_NAME
INSERTS
UPDATES
DELETES
TIMESTAMP
TRUNCATED
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENT
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
COMPRESSION
NUM_ROWS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
SAMPLE_SIZE
LAST_ANALYZED
BUFFER_POOL
GLOBAL_STATS
USER_STATS
TABLE_OWNER
TABLE_NAME
COMPOSITE
PARTITION_NAME
SUBPARTITION_COUNT
HIGH_VALUE
HIGH_VALUE_LENGTH
PARTITION_POSITION
TABLESPACE_NAME
ALL_TAB_PRIVS
Grants on objects for which the user is the grantor, grantee, owner,
GRANTOR
GRANTEE
TABLE_SCHEMA
TABLE_NAME
PRIVILEGE
GRANTABLE
HIERARCHY
Name of the user who performed the grant
Name of the user to whom access was granted
Schema of the object
Name of the object
Table Privilege
Privilege is grantable
Privilege is with hierarchy option
ALL_TAB_PRIVS_MADE
User's grants and grants on user's objects
GRANTEE
OWNER
TABLE_NAME
GRANTOR
PRIVILEGE
GRANTABLE
HIERARCHY
Name of the user to whom access was granted
Owner of the object
Name of the object
Name of the user who performed the grant
Table Privilege
Privilege is grantable
Privilege is with hierarchy option
ALL_TAB_PRIVS_RECD
Grants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_SUBPARTITIONS
ALL_TABLES
Name of the user to whom access was granted
Owner of the object
Name of the object
Name of the user who performed the grant
Table Privilege
Privilege is grantable
Privilege is with hierarchy option
GRANTEE
OWNER
TABLE_NAME
GRANTOR
PRIVILEGE
GRANTABLE
HIERARCHY
TABLE_OWNER
TABLE_NAME
PARTITION_NAME
SUBPARTITION_NAME
HIGH_VALUE
HIGH_VALUE_LENGTH
SUBPARTITION_POSITION
TABLESPACE_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENT
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
COMPRESSION
NUM_ROWS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
SAMPLE_SIZE
LAST_ANALYZED
BUFFER_POOL
GLOBAL_STATS
USER_STATS
Description of relational tables accessible to the user
Owner of the table
Name of the table
Name of the tablespace containing the table
Name of the cluster, if any, to which the table belongs
Name of the index-only table, if any, to which the overflow or mapping table entry belongs
Minimum percentage of free space in a block
Minimum percentage of used space in a block
Initial number of transactions
Maximum number of transactions
Size of the initial extent in bytes
Size of secondary extents in bytes
Minimum number of extents allowed in the segment
Maximum number of extents allowed in the segment
Percentage increase in extent size
Number of process freelists allocated in this segment
Number of freelist groups allocated in this segment
Logging attribute
Has table been backed up since last modification?
The number of rows in the table
The number of used blocks in the table
The number of empty (never used) blocks in the table
The average available free space in the table
The number of chained rows in the table
The average row length, including row overhead
The average freespace of all blocks on a freelist
The number of blocks on the freelist
The number of threads per instance for scanning the table
The number of instances across which the table is to be scanned
Whether the table is to be cached in the buffer cache
Whether table locking is enabled or disabled
The sample size used in analyzing this table
The date of the most recent time this table was analyzed
Is this table partitioned? YES or NO
If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL
Can the current session only see data that it place in this object itself?
Is this table object created as part of icreate for domain indexes?
Is the table a nested table?
The default buffer pool to be used for table blocks
Whether partitioned row movement is enabled or disabled
Are the statistics calculated without merging underlying partitions?
Were the statistics entered directly by the user?
If temporary table, then duration is sys$session or sys$transaction else NULL
Whether skip corrupt blocks is enabled or disabled
Should we keep track of the amount of modification?
Owner of the cluster, if any, to which the table belongs
Should we keep track of row level dependencies?
OWNER
TABLE_NAME
TABLESPACE_NAME
CLUSTER_NAME
IOT_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING
BACKED_UP
NUM_ROWS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
AVG_SPACE_FREELIST_BLOCKS
NUM_FREELIST_BLOCKS
DEGREE
INSTANCES
CACHE
TABLE_LOCK
SAMPLE_SIZE
LAST_ANALYZED
PARTITIONED
IOT_TYPE
TEMPORARY
SECONDARY
NESTED
BUFFER_POOL
ROW_MOVEMENT
GLOBAL_STATS
USER_STATS
DURATION
SKIP_CORRUPT
MONITORING
CLUSTER_OWNER
DEPENDENCIES
ALL_TRIGGER_COLS
Column usage in user's triggers or in triggers on user's tables
TRIGGER_OWNER
TRIGGER_NAME
TABLE_OWNER
TABLE_NAME
COLUMN_NAME
COLUMN_LIST
COLUMN_USAGE
Owner of the trigger
Name of the trigger
Owner of the table
Name of the table on which the trigger is defined
Name of the column or the attribute of the ADT column used in trigger definition
Is column specified in UPDATE OF clause?
Usage of column within trigger body
ALL_TRIGGERS
Triggers accessible to the current user
OWNER
TRIGGER_NAME
TRIGGER_TYPE
TRIGGERING_EVENT
TABLE_OWNER
BASE_OBJECT_TYPE
TABLE_NAME
COLUMN_NAME
REFERENCING_NAMES
WHEN_CLAUSE
STATUS
DESCRIPTION
ACTION_TYPE
TRIGGER_BODY
Owner of the trigger
Name of the trigger
When the trigger fires - BEFORE/AFTER and STATEMENT/ROW
Statement that will fire the trigger - INSERT, UPDATE and/or DELETE
Owner of the table that this trigger is associated with
Name of the table that this trigger is associated with
The name of the column on which the trigger is defined over
Names used for referencing to OLD and NEW values within the trigger
WHEN clause must evaluate to true in order for triggering body to execute
If DISABLED then trigger will not fire
Trigger description, useful for re-creating trigger creation statement
Action taken by this trigger when it fires
ALL_TYPE_ATTRS
Description of attributes of types accessible to the user
OWNER
TYPE_NAME
ATTR_NAME
ATTR_TYPE_MOD
ATTR_TYPE_OWNER
ATTR_TYPE_NAME
LENGTH
PRECISION
SCALE
CHARACTER_SET_NAME
ATTR_NO
INHERITED
Owner of the type
Name of the type
Name of the attribute
Type modifier of the attribute
Owner of the type of the attribute
Name of the type of the attribute
Length of the CHAR attribute or maximum length of the VARCHAR
Decimal precision of the NUMBER or DECIMAL attribute or
Scale of the NUMBER or DECIMAL attribute
Character set name of the attribute
Syntactical order number or position of the attribute as specified in the
Is the attribute inherited from the supertype ?
ALL_TYPE_METHODS
Description of methods of types accessible to the user
Owner of the type
Name of the type
Name of the method
Method number for distinguishing overloaded method (not to be used as ID number)
Type of the method
Number of parameters to the method
Number of results returned by the method
OWNER
TYPE_NAME
METHOD_NAME
METHOD_NO
METHOD_TYPE
PARAMETERS
RESULTS