| OWNER | Owner of the table |
| TABLE_NAME | Name of the table |
| TABLESPACE_NAME | Name of the tablespace containing the table |
| CLUSTER_NAME | Name of the cluster, if any, to which the table belongs |
| IOT_NAME | Name of the index-only table, if any, to which the overflow or mapping table entry belongs |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_USED | Minimum percentage of used space in a block |
| INI_TRANS | Initial number of transactions |
| MAX_TRANS | Maximum number of transactions |
| INITIAL_EXTENT | Size of the initial extent in bytes |
| NEXT_EXTENT | Size of secondary extents in bytes |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE | Percentage increase in extent size |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated in this segment |
| LOGGING | Logging attribute |
| BACKED_UP | Has table been backed up since last modification? |
| NUM_ROWS | The number of rows in the table |
| BLOCKS | The number of used blocks in the table |
| EMPTY_BLOCKS | The number of empty (never used) blocks in the table |
| AVG_SPACE | The average available free space in the table |
| CHAIN_CNT | The number of chained rows in the table |
| AVG_ROW_LEN | The average row length, including row overhead |
| AVG_SPACE_FREELIST_BLOCKS | The average freespace of all blocks on a freelist |
| NUM_FREELIST_BLOCKS | The number of blocks on the freelist |
| DEGREE | The number of threads per instance for scanning the table |
| INSTANCES | The number of instances across which the table is to be scanned |
| CACHE | Whether the table is to be cached in the buffer cache |
| TABLE_LOCK | Whether table locking is enabled or disabled |
| SAMPLE_SIZE | The sample size used in analyzing this table |
| LAST_ANALYZED | The date of the most recent time this table was analyzed |
| PARTITIONED | Is this table partitioned? YES or NO |
| IOT_TYPE | If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL |
| OBJECT_ID_TYPE | If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST EM GENERATED |
| TABLE_TYPE_OWNER | Owner of the type of the table if the table is an object table |
| TABLE_TYPE | Type of the table if the table is an object table |
| TEMPORARY | Can the current session only see data that it place in this object itself? |
| SECONDARY | Is this table object created as part of icreate for domain indexes? |
| NESTED | Is the table a nested table? |
| BUFFER_POOL | The default buffer pool to be used for table blocks |
| ROW_MOVEMENT | Whether partitioned row movement is enabled or disabled |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| USER_STATS | Were the statistics entered directly by the user? |
| DURATION | If temporary table, then duration is sys$session or sys$transaction else NULL |
| SKIP_CORRUPT | Whether skip corrupt blocks is enabled or disabled |
| MONITORING | Should we keep track of the amount of modification? |
| CLUSTER_OWNER | Owner of the cluster, if any, to which the table belongs |
| DEPENDENCIES | Should we keep track of row level dependencies? |
| APPLY_NAME | Name of the apply process |
| QUEUE_NAME | Name of the queue the apply process dequeues from |
| QUEUE_OWNER | Owner of the queue the apply process dequeues from |
| APPLY_CAPTURED | Yes, if applying captured messages; No, if applying enqueued messages |
| RULE_SET_NAME | Rule set used by apply process for filtering |
| RULE_SET_OWNER | Owner of the rule set |
| APPLY_USER | Current user who is applying the messages |
| APPLY_DATABASE_LINK | For remote objects, the database link pointing to the remote database |
| APPLY_TAG | Tag associated with DDL and DML change records that will be applied |
| DDL_HANDLER | Name of the user specified ddl handler |
| MESSAGE_HANDLER | User specified procedure to handle messages other than DDL and DML messages |
| STATUS | Status of the apply process: DISABLED, ENABLED, ABORTED |
| OBJECT_OWNER | Owner of the object |
| OBJECT_NAME | Name of the object |
| METHOD_NAME | Name of the method used to resolve conflict |
| RESOLUTION_COLUMN | Name of the column used to resolve conflict |
| COLUMN_NAME | Name of the column that is to be considered as part of a group to resolve conflict |
| APPLY_DATABASE_LINK | For remote objects, name of database link pointing to remote database |
| OBJECT_OWNER | Owner of the object |
| OBJECT_NAME | Name of the object |
| OPERATION_NAME | Name of the DML operation |
| USER_PROCEDURE | Name of the DML handler specified by the user |
| ERROR_HANDLER | Y if the user procedure is the error handler, N if it is the DML handler |
| APPLY_DATABASE_LINK | For remote objects, name of database link pointing to remote database |
| APPLY_NAME | Name of the apply process at the local site which processed the transaction |
| QUEUE_NAME | Name of the queue at the local site where the transaction came from |
| QUEUE_OWNER | Owner of the queue at the local site where the transaction came from |
| LOCAL_TRANSACTION_ID | Local transaction ID for the error creation transaction |
| SOURCE_DATABASE | Database where the transaction originated |
| SOURCE_TRANSACTION_ID | Original transaction ID at the source database |
| SOURCE_COMMIT_SCN | Original commit SCN for the transaction at the source database |
| MESSAGE_NUMBER | Identifier for the message in the transaction that raised an error |
| ERROR_NUMBER | Error number |
| ERROR_MESSAGE | Error message |
| RECIPIENT_ID | User ID of the original recipient |
| RECIPIENT_NAME | Name of the original recipient |
| MESSAGE_COUNT | Total number of messages inside the error transaction |
| OBJECT_OWNER | Owner of the object |
| OBJECT_NAME | Name of the object |
| COLUMN_NAME | Column name of the object |
| APPLY_DATABASE_LINK | Remote database link to which changes will be aplied |
| APPLY_NAME | Name of the apply process |
| PARAMETER | Name of the parameter |
| VALUE | Either the default value or the value set by the user for the parameter |
| SET_BY_USER | YES if the value is set by the user, NO otherwise |
| APPLY_NAME | Name of the apply process |
| APPLIED_MESSAGE_NUMBER | All messages before this number have been successfully applied |
| OLDEST_MESSAGE_NUMBER | Earliest commit number of the transactions currently being applied |
| APPLY_TIME | Time at which the message was applied |
| APPLIED_MESSAGE_CREATE_TIME | Time at which the message to be applied was created |
| OWNER | Username of the owner of the object |
| OBJECT_NAME | Procedure or function name |
| PACKAGE_NAME | Package name |
| OBJECT_ID | Object number of the object |
| OVERLOAD | Overload unique identifier |
| ARGUMENT_NAME | Argument name |
| POSITION | Position in argument list, or null for function return value |
| SEQUENCE | Argument sequence, including all nesting levels |
| DATA_LEVEL | Nesting depth of argument for composite types |
| DATA_TYPE | Datatype of the argument |
| DEFAULT_VALUE | Default value for the argument |
| DEFAULT_LENGTH | Length of default value for the argument |
| IN_OUT | Argument direction (IN, OUT, or IN/OUT) |
| DATA_LENGTH | Length of the column in bytes |
| DATA_PRECISION | Length: decimal digits (NUMBER) or binary digits (FLOAT) |
| DATA_SCALE | Digits to right of decimal point in a number |
| RADIX | Argument radix for a number |
| CHARACTER_SET_NAME | Character set name for the argument |
| TYPE_OWNER | Owner name for the argument type in case of object types |
| TYPE_NAME | Object name for the argument type in case of object types |
| TYPE_SUBNAME | Subordinate object name for the argument type in case of object types |
| TYPE_LINK | Database link name for the argument type in case of object types |
| PLS_TYPE | PL/SQL type name for numeric arguments |
| CHAR_LENGTH | Character limit for string datatypes |
| CHAR_USED | Is the byte limit (B) or char limit (C) official for this string? |
| OBJECT_OWNER | Owner of the object for which the association is being defined |
| OBJECT_NAME | Object name for which the association is being defined |
| COLUMN_NAME | Column name in the object for which the association is being defined |
| OBJECT_TYPE | Schema type of the object - column, type, package or function |
| STATSTYPE_SCHEMA | Owner of the statistics type |
| STATSTYPE_NAME | Name of Statistics type which contains the cost, selectivity or stats funcs |
| DEF_SELECTIVITY | Default Selectivity if any of the object |
| DEF_CPU_COST | Default CPU cost if any of the object |
| DEF_IO_COST | Default I/O cost if any of the object |
| DEF_NET_COST | Default Networking cost if any of the object |
| INTERFACE_VERSION | Version number of Statistics type interface implemented |
| OBJECT_SCHEMA | Owner of the table or view |
| OBJECT_NAME | Name of the table or view |
| POLICY_NAME | Name of the policy |
| POLICY_TEXT | Audit condition |
| POLICY_COLUMN | Relevant column |
| PF_SCHEMA | Owner of the audit handler function |
| PF_PACKAGE | Name of the package containing the audit handler function |
| PF_FUNCTION | Name of the audit handler function |
| ENABLED | Is this policy is enabled? |
| OWNER | Owner of the master table which changes are logged |
| MASTER | Name of the master table which changes are logged |
| MVIEW_LAST_REFRESH_TIME | One date per materialized view -- the date the materialized view was last refreshed |
| MVIEW_ID | Unique identifier of the materialized view |
| CAPTURE_NAME | Name of the capture process |
| QUEUE_NAME | Name of queue used for holding captured changes |
| QUEUE_OWNER | Owner of the queue used for holding captured changes |
| RULE_SET_NAME | Rule set used by capture process for filtering |
| RULE_SET_OWNER | Owner of the rule set |
| START_SCN | The SCN from which capturing will be resumed |
| STATUS | Status of the capture process: DISABLED, ENABLED, ABORTED |
| CAPTURE_NAME | Name of the capture process |
| PARAMETER | Name of the parameter |
| VALUE | Either the default value or the value set by the user for the parameter |
| SET_BY_USER | YES if the value is set by the user, NO otherwise |
| TIMESTAMP | Time at which the database was ready to be instantiated |
| SCHEMA_NAME | Name of schema prepared for instantiation |
| TIMESTAMP | Time at which the schema was ready to be instantiated |
| TABLE_OWNER | Owner of the table prepared for instantiation |
| TABLE_NAME | Name of the table prepared for instantiation |
| SCN | SCN from which changes can be captured |
| TIMESTAMP | Time at which the table was ready to be instantiated |
| OWNER | Owner of the object |
| TABLE_NAME | Name of the object |
| TABLE_TYPE | Type of the object |
| OWNER | Owner of the cluster |
| CLUSTER_NAME | Name of the cluster |
| TABLESPACE_NAME | Name of the tablespace containing the cluster |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_USED | Minimum percentage of used space in a block |
| KEY_SIZE | Estimated size of cluster key plus associated rows |
| INI_TRANS | Initial number of transactions |
| MAX_TRANS | Maximum number of transactions |
| INITIAL_EXTENT | Size of the initial extent in bytes |
| NEXT_EXTENT | Size of secondary extents in bytes |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE | Percentage increase in extent size |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated in this segment |
| AVG_BLOCKS_PER_KEY | Average number of blocks containing rows with a given cluster key |
| CLUSTER_TYPE | Type of cluster: b-tree index or hash |
| FUNCTION | If a hash cluster, the hash function |
| HASHKEYS | If a hash cluster, the number of hash keys (hash buckets) |
| DEGREE | The number of threads per instance for scanning the cluster |
| INSTANCES | The number of instances across which the cluster is to be scanned |
| CACHE | Whether the cluster is to be cached in the buffer cache |
| BUFFER_POOL | The default buffer pool to be used for cluster blocks |
| SINGLE_TABLE | Whether the cluster can contain only a single table |
| DEPENDENCIES | Should we keep track of row level dependencies? |
| OWNER | Name of owner of cluster |
| CLUSTER_NAME | Name of cluster |
| HASH_EXPRESSION | Text of hash function of cluster |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| COLL_TYPE | Collection type |
| UPPER_BOUND | Size of the FIXED ARRAY type or maximum size of the VARYING ARRAY type |
| ELEM_TYPE_MOD | Type modifier of the element |
| ELEM_TYPE_OWNER | Owner of the type of the element |
| ELEM_TYPE_NAME | Name of the type of the element |
| LENGTH | Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element |
| PRECISION | Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element |
| SCALE | Scale of the NUMBER or DECIMAL element |
| CHARACTER_SET_NAME | Character set name of the element |
| ELEM_STORAGE | Storage optimization specification for VARRAY of numeric elements |
| NULLS_STORED | Is null information stored with each VARRAY element? |
| OWNER | Owner of the object |
| TABLE_NAME | Name of the object |
| COLUMN_NAME | Name of the column |
| COMMENTS | Comment on the column |
| GRANTOR | Name of the user who performed the grant |
| GRANTEE | Name of the user to whom access was granted |
| TABLE_SCHEMA | Schema of the object |
| TABLE_NAME | Name of the object |
| COLUMN_NAME | Name of the column |
| PRIVILEGE | Column Privilege |
| GRANTABLE | Privilege is grantable |
| GRANTEE | Name of the user to whom access was granted |
| OWNER | Username of the owner of the object |
| TABLE_NAME | Name of the object |
| COLUMN_NAME | Name of the column |
| GRANTOR | Name of the user who performed the grant |
| PRIVILEGE | Column Privilege |
| GRANTABLE | Privilege is grantable |
| GRANTEE | Name of the user to whom access was granted |
| OWNER | Username of the owner of the object |
| TABLE_NAME | Name of the object |
| COLUMN_NAME | Name of the column |
| GRANTOR | Name of the user who performed the grant |
| PRIVILEGE | Column privilege |
| GRANTABLE | Privilege is grantable |
| OWNER | Owner of the table |
| CONSTRAINT_NAME | Name associated with constraint definition |
| CONSTRAINT_TYPE | Type of constraint definition |
| TABLE_NAME | Name associated with table with constraint definition |
| SEARCH_CONDITION | Text of search condition for table check |
| R_OWNER | Owner of table used in referential constraint |
| R_CONSTRAINT_NAME | Name of unique constraint definition for referenced table |
| DELETE_RULE | The delete rule for a referential constraint |
| STATUS | Enforcement status of constraint - ENABLED or DISABLED |
| DEFERRABLE | Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE |
| DEFERRED | Is the constraint deferred by default - DEFERRED or IMMEDIATE |
| VALIDATED | Was this constraint system validated? - VALIDATED or NOT VALIDATED |
| GENERATED | Was the constraint name system generated? - GENERATED NAME or USER NAME |
| BAD | Creating this constraint should give ORA-02436. Rewrite it before 2000 AD. |
| RELY | If set, this flag will be used in optimizer |
| LAST_CHANGE | The date when this column was last enabled or disabled |
| INDEX_OWNER | The owner of the index used by this constraint |
| INDEX_NAME | The index used by this constraint |
| INVALID | |
| VIEW_RELATED |
| OWNER | Owner of the constraint definition |
| CONSTRAINT_NAME | Name associated with the constraint definition |
| TABLE_NAME | Name associated with table with constraint definition |
| COLUMN_NAME | Name associated with column or attribute of object column specified in the constraint definition |
| POSITION | Original position of column or attribute in definition |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table containing the object column or attribute |
| COLUMN_NAME | Fully qualified name of the object column or attribute |
| CONS_TYPE_OWNER | Owner of the type that the column is constrained to |
| CONS_TYPE_NAME | Name of the type that the column is constrained to |
| CONS_TYPE_ONLY | Indication of whether the column is constrained to ONLY type |
| NAMESPACE | Namespace of the active context |
| SCHEMA | Schema of the designated package |
| PACKAGE | Name of the designated package |
| OWNER | |
| DB_LINK | Name of the database link |
| USERNAME | Name of user to log on as |
| HOST | SQL*Net string for connect |
| CREATED | Creation time of the database link |
| ALT | Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| AUD | Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| COM | Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| DEL | Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| GRA | Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| IND | Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| INS | Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| LOC | Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| REN | Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| SEL | Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| UPD | Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| REF | Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used) |
| EXE | Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| OWNER | Owner of the object |
| NAME | Name of the object |
| TYPE | Type of the object |
| REFERENCED_OWNER | Owner of referenced object (remote owner if remote object) |
| REFERENCED_NAME | Name of referenced object |
| REFERENCED_TYPE | Type of referenced object |
| REFERENCED_LINK_NAME | Name of dblink if this is a remote object |
| DEPENDENCY_TYPE |
| OWNER | Owner of the dimension |
| DIMENSION_NAME | Name of the dimension |
| INVALID | Invalidity of the dimension, Y = INVALID, N = VALID. The column is deprecated, please use COMPILE_STATE instead. |
| COMPILE_STATE | Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR |
| REVISION | Revision levle of the dimension |
| OWNER | Owner of the dimentsion |
| DIMENSION_NAME | Name of the dimension |
| LEVEL_NAME | Name of the hierarchy level |
| COLUMN_NAME | Name of the dependent column |
| INFERRED | Whether this attribute is inferred from a JOIN KEY specification |
| OWNER | Owner of the dimension |
| DIMENSION_NAME | Name of the dimension |
| HIERARCHY_NAME | Name of the hierarchy |
| POSITION | Hierarchical position within this hierarchy, position 1 being the most detailed |
| CHILD_LEVEL_NAME | Name of the child-side level of this 1:n relationship |
| JOIN_KEY_ID | Keys that join child uniquely to the parent |
| PARENT_LEVEL_NAME | Name of the parent-side level of this 1:n relationship |
| OWNER | Owner of the dimension |
| DIMENSION_NAME | Name of the dimension |
| HIERARCHY_NAME | Name of the hierarchy |
| OWNER | Owner of the dimension |
| DIMENSION_NAME | Name of the dimension |
| DIM_KEY_ID | Join key ID (unique within a dimension) |
| LEVEL_NAME | Name of the hierarchy level |
| KEY_POSITION | Position of the key column within the level |
| HIERARCHY_NAME | Name of the hierarchy |
| CHILD_JOIN_COLUMN | Name of the join column |
| OWNER | Owner of the dimension |
| DIMENSION_NAME | Name of the dimension |
| LEVEL_NAME | Name of the dimension level (unique within a dimension) |
| NUM_COLUMNS | Number of columns in the level definition |
| DETAILOBJ_OWNER | Owner of the detail object that the keys of this level come from |
| DETAILOBJ_NAME | Name of the table that the keys of this level come from |
| OWNER | Owner of the dimension |
| DIMENSION_NAME | Name of the dimension |
| LEVEL_NAME | Name of the hierarchy level |
| KEY_POSITION | Ordinal position of the key column within the level |
| COLUMN_NAME | Name of the key column |
| OWNER | Owner of the directory (always SYS) |
| DIRECTORY_NAME | Name of the directory |
| DIRECTORY_PATH | Operating system pathname for the directory |
| OWNER | Owner of the object |
| NAME | Name of the object |
| TYPE | Type: "TYPE", "TYPE BODY", "VIEW", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "JAVA SOURCE" or "JAVA CLASS" |
| SEQUENCE | Sequence number used for ordering purposes |
| LINE | Line number at which this error occurs |
| POSITION | Position in the line at which this error occurs |
| TEXT | Text of the error |
| EVALUATION_CONTEXT_OWNER | Owner of the evaluation context |
| EVALUATION_CONTEXT_NAME | Name of the evaluation context |
| EVALUATION_FUNCTION | User supplied function to evaluate rules |
| EVALUATION_CONTEXT_COMMENT | user description of the evaluation context |
| EVALUATION_CONTEXT_OWNER | Owner of the evaluation context |
| EVALUATION_CONTEXT_NAME | Name of the evaluation context |
| TABLE_ALIAS | Alias of the table |
| TABLE_NAME | Name of the table |
| EVALUATION_CONTEXT_OWNER | Owner of the evaluation context |
| EVALUATION_CONTEXT_NAME | Name of the evaluation context |
| VARIABLE_NAME | Name of the variable |
| VARIABLE_TYPE | |
| VARIABLE_VALUE_FUNCTION | Function to provide variable value |
| VARIABLE_METHOD_FUNCTION | Function to provide variable method return value |
| OWNER | Owner of the external table location |
| TABLE_NAME | Name of the corresponding external table |
| LOCATION | External table location clause |
| DIRECTORY_OWNER | Owner of the directory containing the external table location |
| DIRECTORY_NAME | Name of the directory containing the location |
| OWNER | Owner of the external table |
| TABLE_NAME | Name of the external table |
| TYPE_OWNER | Owner of the implementation type for the external table access driver |
| TYPE_NAME | Name of the implementation type for the external table access driver |
| DEFAULT_DIRECTORY_OWNER | Owner of the default directory for the external table |
| DEFAULT_DIRECTORY_NAME | Name of the default directory for the external table |
| REJECT_LIMIT | Reject limit for the external table |
| ACCESS_TYPE | Type of access parameters for the external table (CLOB/BLOB) |
| ACCESS_PARAMETERS | Access parameters for the external table |
| OWNER | Owner of table |
| TABLE_NAME | Table name |
| COLUMN_NAME | Column name or attribute of object column |
| ENDPOINT_NUMBER | Endpoint number |
| ENDPOINT_VALUE | Normalized endpoint value |
| ENDPOINT_ACTUAL_VALUE | Actual endpoint value |
| OWNER | Username of the owner of the index |
| INDEX_NAME | Name of the index |
| INDEX_TYPE | |
| TABLE_OWNER | Owner of the indexed object |
| TABLE_NAME | Name of the indexed object |
| TABLE_TYPE | Type of the indexed object |
| UNIQUENESS | Uniqueness status of the index: "UNIQUE", "NONUNIQUE", or "BITMAP" |
| COMPRESSION | Compression property of the index: "ENABLED", "DISABLED", or NULL |
| PREFIX_LENGTH | Number of key columns in the prefix used for compression |
| TABLESPACE_NAME | Name of the tablespace containing the index |
| INI_TRANS | Initial number of transactions |
| MAX_TRANS | Maximum number of transactions |
| INITIAL_EXTENT | Size of the initial extent |
| NEXT_EXTENT | Size of secondary extents |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE | Percentage increase in extent size |
| PCT_THRESHOLD | Threshold percentage of block space allowed per index entry |
| INCLUDE_COLUMN | User column-id for last column to be included in index-organized table top index |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated to this segment |
| PCT_FREE | Minimum percentage of free space in a block |
| LOGGING | Logging attribute |
| BLEVEL | B-Tree level |
| LEAF_BLOCKS | The number of leaf blocks in the index |
| DISTINCT_KEYS | The number of distinct keys in the index |
| AVG_LEAF_BLOCKS_PER_KEY | The average number of leaf blocks per key |
| AVG_DATA_BLOCKS_PER_KEY | The average number of data blocks per key |
| CLUSTERING_FACTOR | A measurement of the amount of (dis)order of the table this index is for |
| STATUS | Whether the non-partitioned index is in USABLE or not |
| NUM_ROWS | |
| SAMPLE_SIZE | The sample size used in analyzing this index |
| LAST_ANALYZED | The date of the most recent time this index was analyzed |
| DEGREE | The number of threads per instance for scanning the partitioned index |
| INSTANCES | The number of instances across which the partitioned index is to be scanned |
| PARTITIONED | Is this index partitioned? YES or NO |
| TEMPORARY | Can the current session only see data that it place in this object itself? |
| GENERATED | Was the name of this index system generated? |
| SECONDARY | Is the index object created as part of icreate for domain indexes? |
| BUFFER_POOL | The default buffer pool to be used for index blocks |
| USER_STATS | Were the statistics entered directly by the user? |
| DURATION | If index on temporary table, then duration is sys$session or sys$transaction else NULL |
| PCT_DIRECT_ACCESS | If index on IOT, then this is percentage of rows with Valid guess |
| ITYP_OWNER | If domain index, then this is the indextype owner |
| ITYP_NAME | If domain index, then this is the name of the associated indextype |
| PARAMETERS | If domain index, then this is the parameter string |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| DOMIDX_STATUS | Is the indextype of the domain index valid |
| DOMIDX_OPSTATUS | Status of the operation on the domain index |
| FUNCIDX_STATUS | Is the Function-based Index DISABLED or ENABLED? |
| JOIN_INDEX | Is this index a join index? |
| OWNER | Owner of the indextype |
| INDEXTYPE_NAME | Name of the indextype |
| IMPLEMENTATION_SCHEMA | Name of the schema for indextype implementation |
| IMPLEMENTATION_NAME | Name of indextype implementation |
| INTERFACE_VERSION | Version of indextype interface |
| IMPLEMENTATION_VERSION | Version of indextype implementation |
| NUMBER_OF_OPERATORS | Number of operators associated with the indextype |
| PARTITIONING | Kinds of local partitioning supported by the indextype |
| OWNER | Owner of the user-defined indextype |
| INDEXTYPE_NAME | Name of the user-defined indextype |
| COMMENTS | Comment for the user-defined indextype |
| OWNER | Owner of the indextype |
| INDEXTYPE_NAME | Name of the indextype |
| OPERATOR_SCHEMA | Name of the operator schema |
| OPERATOR_NAME | Name of the operator for which the indextype is defined |
| BINDING# | Binding# associated with the operator |
| INDEX_OWNER | Index owner |
| INDEX_NAME | Index name |
| TABLE_OWNER | Table or cluster owner |
| TABLE_NAME | Table or cluster name |
| COLUMN_NAME | Column name or attribute of object column |
| COLUMN_POSITION | Position of column or attribute within index |
| COLUMN_LENGTH | Maximum length of the column or attribute, in bytes |
| CHAR_LENGTH | Maximum length of the column or attribute, in characters |
| DESCEND | DESC if this column is sorted in descending order on disk, otherwise ASC |
| INDEX_OWNER | Index owner |
| INDEX_NAME | Index name |
| TABLE_OWNER | Table or cluster owner |
| TABLE_NAME | Table or cluster name |
| COLUMN_EXPRESSION | Functional index expression defining the column |
| COLUMN_POSITION | Position of column or attribute within index |
| TABLE_NAME | Name of the table |
| INTERNAL_TRIGGER_TYPE | Type of internal trigger |
| JOB | Identifier of job. Neither import/export nor repeated executions change it. |
| LOG_USER | USER who was logged in when the job was submitted |
| PRIV_USER | USER whose default privileges apply to this job |
| SCHEMA_USER | select * from bar means select * from schema_user.bar |
| LAST_DATE | Date that this job last successfully executed |
| LAST_SEC | Same as LAST_DATE. This is when the last successful execution started. |
| THIS_DATE | Date that this job started executing (usually null if not executing) |
| THIS_SEC | Same as THIS_DATE. This is when the last successful execution started. |
| NEXT_DATE | Date that this job will next be executed |
| NEXT_SEC | Same as NEXT_DATE. The job becomes due for execution at this time. |
| TOTAL_TIME | Total wallclock time spent by the system on this job, in seconds |
| BROKEN | If Y, no attempt is being made to run this job. See dbms_jobq.broken(job). |
| INTERVAL | A date function, evaluated at the start of execution, becomes next NEXT_DATE |
| FAILURES | How many times has this job started and failed since its last success? |
| WHAT | Body of the anonymous PL/SQL block that this job executes |
| NLS_ENV | alter session parameters describing the NLS environment of the job |
| MISC_ENV | a versioned raw maintained by the kernel, for other session parameters |
| INSTANCE | Instance number restricted to run the job |
| INDEX_OWNER | Index owner |
| INDEX_NAME | Index name |
| INNER_TABLE_OWNER | Table owner of inner table (table closer to the fact table) |
| INNER_TABLE_NAME | Table name of inner table (table closer to the fact table) |
| INNER_TABLE_COLUMN | Column name of inner table (table closer to the fact table) |
| OUTER_TABLE_OWNER | Table owner of outer table (table closer to the fact table) |
| OUTER_TABLE_NAME | Table name of outer table (table closer to the fact table) |
| OUTER_TABLE_COLUMN | Column name of outer table (table closer to the fact table) |
| OWNER | Owner of the library |
| LIBRARY_NAME | Name of the library |
| FILE_SPEC | Operating system file specification of the library |
| DYNAMIC | Is the library dynamically loadable |
| STATUS | Status of the library |
| OWNER | Owner of the table containing the LOB |
| TABLE_NAME | Name of the table containing the LOB |
| COLUMN_NAME | Name of the LOB column or attribute |
| SEGMENT_NAME | Name of the LOB segment |
| INDEX_NAME | Name of the LOB index |
| CHUNK | Size of the LOB chunk as a unit of allocation/manipulation in bytes |
| PCTVERSION | Maximum percentage of the LOB space used for versioning |
| RETENTION | Maximum time duration for versioning of the LOB space |
| FREEPOOLS | Number of freepools for this LOB segment |
| CACHE | Is the LOB accessed through the buffer cache? |
| LOGGING | Are changes to the LOB logged? |
| IN_ROW | Are some of the LOBs stored with the base row? |
| OWNER | Owner of the table |
| LOG_GROUP_NAME | Name associated with log group definition |
| TABLE_NAME | |
| ALWAYS | If set, these columns are always logged |
| OWNER | Owner of the log group definition |
| LOG_GROUP_NAME | Name associated with the log group definition |
| TABLE_NAME | Name associated with table with log group definition |
| COLUMN_NAME | Name associated with column or attribute of object column specified in the log group definition |
| POSITION | Original position of column or attribute in definition |
| OWNER | Onwer of the type |
| TYPE_NAME | Name of the type |
| METHOD_NAME | Name of the method |
| METHOD_NO | Method number for distinguishing overloaded method (not to be used as ID number) |
| PARAM_NAME | Name of the parameter |
| PARAM_NO | Parameter number or position |
| PARAM_MODE | Mode of the parameter |
| PARAM_TYPE_MOD | Type modifier of the parameter |
| PARAM_TYPE_OWNER | Owner of the type of the parameter |
| PARAM_TYPE_NAME | Name of the type of the parameter |
| CHARACTER_SET_NAME | Character set name of the parameter |
| OWNER | Onwer of the type |
| TYPE_NAME | Name of the type |
| METHOD_NAME | Name of the method |
| METHOD_NO | Method number for distinguishing overloaded method (not to be used as ID number) |
| RESULT_TYPE_MOD | Type modifier of the result |
| RESULT_TYPE_OWNER | Owner of the type of the result |
| RESULT_TYPE_NAME | Name of the type of the result |
| CHARACTER_SET_NAME | Character set name of the result |
| OWNER | Owner of the materialized view |
| MVIEW_NAME | Name of the materialized view |
| CONTAINER_NAME | Name of the materialized view container table |
| QUERY | The defining query that the materialized view instantiates |
| QUERY_LEN | The number of bytes in the defining query (based on the server character set |
| UPDATABLE | Indicates whether the materialized view can be updated |
| UPDATE_LOG | Name of the table that logs changes to an updatable materialized view |
| MASTER_ROLLBACK_SEG | Name of the rollback segment to use at the master site |
| MASTER_LINK | Name of the database link to the master site |
| REWRITE_ENABLED | Indicates whether rewrite is enabled for the materialized view |
| REWRITE_CAPABILITY | Indicates the kind of rewrite that is enabled |
| REFRESH_MODE | Indicates how and when the materialized view will be refreshed |
| REFRESH_METHOD | The default refresh method for the materialized view (complete, fast, ...) |
| BUILD_MODE | How and when to initially build (load) the materialized view container |
| FAST_REFRESHABLE | Indicates the kinds of operations that can be fast refreshed for the MV |
| LAST_REFRESH_TYPE | Indicates the kind of refresh that was last performed on the MV |
| LAST_REFRESH_DATE | The date that the materialized view was last refreshed |
| STALENESS | Indicates the staleness state of the materialized view (fresh, stale, ...) |
| AFTER_FAST_REFRESH | Indicates the staleness state the MV will have after a fast refresh is done |
| UNKNOWN_PREBUILT | Indicates if the materialized view is prebuilt |
| UNKNOWN_PLSQL_FUNC | Indicates if the materialized view contains PL/SQL function |
| UNKNOWN_EXTERNAL_TABLE | Indicates if the materialized view contains external tables |
| UNKNOWN_CONSIDER_FRESH | Indicates if the materialized view is considered fresh |
| UNKNOWN_IMPORT | Indicates if the materialized view is imported |
| COMPILE_STATE | Indicates the validity of the MV meta-data |
| USE_NO_INDEX | Indicates whether the MV uses no index |
| OWNER | Owner of the materialized view |
| MVIEW_NAME | Name of the materialized view |
| POSITION_IN_SELECT | Position of this aggregated measure with the SELECT list |
| CONTAINER_COLUMN | Name of this column in the container table |
| AGG_FUNCTION | Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV |
| DISTINCTFLAG | Set to Y is this is a DISTINCT aggregation |
| MEASURE | The SQL text of the measure, excluding the aggregation function |
| OWNER | Owner of the materialized view |
| MVIEW_NAME | Name of the materialized view |
| MVIEW_TABLE_OWNER | Owner of the container table |
| CONTAINER_NAME | Name of the container table for this materialized view |
| LAST_REFRESH_SCN | The SCN of the last transaction to refresh the materialized view |
| LAST_REFRESH_DATE | The date of the last refresh of the materialized view |
| REFRESH_METHOD | User declared method of refresh for the materialized view |
| SUMMARY | Indicates if the materialized view includes the GROUP BY clause |
| FULLREFRESHTIM | The time that it took to fully refresh the materialized view |
| INCREFRESHTIM | The time that it took to incrementally refresh the materialized view |
| CONTAINS_VIEWS | This materialized view contains views in the FROM clause |
| UNUSABLE | This materialized view is unusable, the build was deferred |
| RESTRICTED_SYNTAX | This materialized view contains restrictive syntax |
| INC_REFRESHABLE | This materialized view is not restricted from being incrementally refreshed |
| KNOWN_STALE | This materialized view is directly stale |
| INVALID | Invalidity of the materialized view, Y = INVALID, N = VALID |
| REWRITE_ENABLED | This materialized view is enabled for query rewrite |
| QUERY_LEN | The length (in bytes) of the query field |
| QUERY | SELECT expression of the materialized view definition |
| REVISION | Reserved for internal use |
| OWNER | Owner of the materialized view |
| MVIEW_NAME | Name of the materialized view |
| DETAILOBJ_OWNER | Owner of the detail relation |
| DETAILOBJ_NAME | Name of the materialized view detail table |
| DETAILOBJ_TYPE | Type of materialized view detail table type |
| DETAILOBJ_ALIAS | Alias of the detail relation if used |
| OWNER | Owner of the materialized view |
| MVIEW_NAME | Name of the materialized view |
| DETAILOBJ1_OWNER | Owner of the 1st detail object |
| DETAILOBJ1_RELATION | Name of the 1st detail object |
| DETAILOBJ1_COLUMN | Name of the 1st detail object column |
| OPERATOR | Name of the join operator. Currently only = is defined |
| OPERATOR_TYPE | |
| DETAILOBJ2_OWNER | Owner of the 2nd detail object |
| DETAILOBJ2_RELATION | Name of the 2nd detail object |
| DETAILOBJ2_COLUMN | Name of the 2nd detail object column |
| OWNER | Owner of the materialized view |
| MVIEW_NAME | Name of the materialized view |
| POSITION_IN_SELECT | Position of this key within the SELECT list |
| CONTAINER_COLUMN | Name of the column in the container table |
| DETAILOBJ_OWNER | Owner of the detail object |
| DETAILOBJ_NAME | Name of the detail object |
| DETAILOBJ_ALIAS | Alias of the detail object |
| DETAILOBJ_TYPE | Type of the detail object: VIEW or TABLE |
| DETAILOBJ_COLUMN | Name of the detail object column |
| LOG_OWNER | Owner of the materialized view log |
| MASTER | Name of the master table which changes are logged |
| LOG_TABLE | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TRIGGER | An after-row trigger on the master which inserts rows into the log |
| ROWIDS | If YES, the materialized view log records rowid information |
| PRIMARY_KEY | If YES, the materialized view log records primary key information |
| OBJECT_ID | If YES, the materialized view log records object id information |
| FILTER_COLUMNS | If YES, the materialized view log records filter column information |
| SEQUENCE | If YES, the materialized view log records sequence information |
| INCLUDE_NEW_VALUES | If YES, the materialized view log records old and new values (else only old values) |
| OWNER | Owner of the materialized view |
| NAME | The view used by users and applications for viewing the MV |
| MASTER_OWNER | Owner of the master table |
| MASTER | Name of the master table |
| LAST_REFRESH | SYSDATE from the master site at the time of the last refresh |
| OWNER | Owner of the nested table |
| TABLE_NAME | Name of the nested table |
| TABLE_TYPE_OWNER | Owner of the type of which the nested table was created |
| TABLE_TYPE_NAME | Name of the type of the nested table |
| PARENT_TABLE_NAME | Name of the parent table containing the nested table |
| PARENT_TABLE_COLUMN | Column name of the parent table that corresponds to the nested table |
| STORAGE_SPEC | |
| RETURN_TYPE | |
| ELEMENT_SUBSTITUTABLE | Indication of whether the nested table element is substitutable or not |
| OWNER | Username of the owner of the object |
| OBJECT_NAME | Name of the object |
| SUBOBJECT_NAME | Name of the sub-object (for example, partititon) |
| OBJECT_ID | Object number of the object |
| DATA_OBJECT_ID | Object number of the segment which contains the object |
| OBJECT_TYPE | Type of the object |
| CREATED | Timestamp for the creation of the object |
| LAST_DDL_TIME | Timestamp for the last DDL change (including GRANT and REVOKE) to the object |
| TIMESTAMP | Timestamp for the specification of the object |
| STATUS | Status of the object |
| TEMPORARY | Can the current session only see data that it placed in this object itself? |
| GENERATED | Was the name of this object system generated? |
| SECONDARY | Is this a secondary object created as part of icreate for domain indexes? |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table |
| TABLESPACE_NAME | Name of the tablespace containing the table |
| CLUSTER_NAME | Name of the cluster, if any, to which the table belongs |
| IOT_NAME | Name of the index-only table, if any, to which the overflow or mapping table entry belongs |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_USED | Minimum percentage of used space in a block |
| INI_TRANS | Initial number of transactions |
| MAX_TRANS | Maximum number of transactions |
| INITIAL_EXTENT | Size of the initial extent in bytes |
| NEXT_EXTENT | Size of secondary extents in bytes |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE | Percentage increase in extent size |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated in this segment |
| LOGGING | Logging attribute |
| BACKED_UP | Has table been backed up since last modification? |
| NUM_ROWS | The number of rows in the table |
| BLOCKS | The number of used blocks in the table |
| EMPTY_BLOCKS | The number of empty (never used) blocks in the table |
| AVG_SPACE | The average available free space in the table |
| CHAIN_CNT | The number of chained rows in the table |
| AVG_ROW_LEN | The average row length, including row overhead |
| AVG_SPACE_FREELIST_BLOCKS | The average freespace of all blocks on a freelist |
| NUM_FREELIST_BLOCKS | The number of blocks on the freelist |
| DEGREE | The number of threads per instance for scanning the table |
| INSTANCES | The number of instances across which the table is to be scanned |
| CACHE | Whether the table is to be cached in the buffer cache |
| TABLE_LOCK | Whether table locking is enabled or disabled |
| SAMPLE_SIZE | The sample size used in analyzing this table |
| LAST_ANALYZED | The date of the most recent time this table was analyzed |
| PARTITIONED | Is this table partitioned? YES or NO |
| IOT_TYPE | If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL |
| OBJECT_ID_TYPE | If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED |
| TABLE_TYPE_OWNER | Owner of the type of the table if the table is an object table |
| TABLE_TYPE | Type of the table if the table is an object table |
| TEMPORARY | Can the current session only see data that it place in this object itself? |
| SECONDARY | Is this table object created as part of icreate for domain indexes? |
| NESTED | Is the table a nested table? |
| BUFFER_POOL | The default buffer pool to be used for table blocks |
| ROW_MOVEMENT | Whether partitioned row movement is enabled or disabled |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| USER_STATS | Were the statistics entered directly by the user? |
| DURATION | If temporary table, then duration is sys$session or sys$transaction else NULL |
| SKIP_CORRUPT | Whether skip corrupt blocks is enabled or disabled |
| MONITORING | Should we keep track of the amount of modification? |
| CLUSTER_OWNER | Owner of the cluster, if any, to which the table belongs |
| DEPENDENCIES | Should we keep track of row level dependencies? |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table containing the object column or attribute |
| COLUMN_NAME | Fully qualified name of the object column or attribute |
| SUBSTITUTABLE | Indication of whether the column is substitutable or not |
| OWNER | Owner of ancillary operator |
| OPERATOR_NAME | Name of ancillary operator |
| BINDING# | Binding number of ancillary operator |
| PRIMOP_OWNER | Owner of primary operator |
| PRIMOP_NAME | Name of primary operator |
| PRIMOP_BIND# | Binding number of primary operator |
| OWNER | Owner of the operator |
| OPERATOR_NAME | Name of the operator |
| BINDING# | Binding# of the operator |
| POSITION | Position of the operator argument |
| ARGUMENT_TYPE | Datatype of the operator argument |
| OWNER | Owner of the operator |
| OPERATOR_NAME | Name of the operator |
| BINDING# | Binding# of the operator |
| FUNCTION_NAME | Name of the binding function or method as specified by the user |
| RETURN_SCHEMA | Name of the schema of the return type - not null only for ADTs |
| RETURN_TYPE | Name of the return type |
| IMPLEMENTATION_TYPE_SCHEMA | Schema of the implementation type of the indextype |
| IMPLEMENTATION_TYPE | Implementation type of the indextype |
| PROPERTY | Property of the operator binding |
| OWNER | Owner of the operator |
| OPERATOR_NAME | Name of the operator |
| NUMBER_OF_BINDS | Number of bindings associated with the operator |
| OWNER | Owner of the user-defined operator |
| OPERATOR_NAME | Name of the user-defined operator |
| COMMENTS | Comment for the user-defined operator |
| NAME | Name of the outline |
| CATEGORY | Category to which the outline belongs |
| USED | Flag indicating whether the outline has ever been used |
| TIMESTAMP | Timestamp at which the outline was created |
| VERSION | Oracle Version that created the outline |
| SQL_TEXT | SQL text of the query |
| SIGNATURE | Signature uniquely identifying the outline SQL text |
| NAME | Stage at which the outline is processed |
| NODE | I.D. of the query or subquery to which the hint applies |
| STAGE | Stage at which outline is processed |
| JOIN_POS | Position of the table in the join order |
| HINT | Text of the hint |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table |
| OBJECT_OWNER | Owner of the synonym, table, or view |
| OBJECT_NAME | Name of the synonym, table, or view |
| POLICY_GROUP | |
| POLICY_NAME | Name of the policy |
| PF_OWNER | Owner of the policy function |
| PACKAGE | Name of the package containing the policy function |
| FUNCTION | Name of the policy function |
| SEL | If YES, policy is applied to query on the object |
| INS | If YES, policy is applied to insert on the object |
| UPD | If YES, policy is applied to update on the object |
| DEL | If YES, policy is applied to delete on the object |
| CHK_OPTION | Is check option enforced for this policy? |
| ENABLE | Is this policy is enabled? |
| STATIC_POLICY | Is this policy is static? |
| OBJECT_OWNER | Schema of the synonym, table, or view |
| OBJECT_NAME | Name of the synonym, table, or view |
| NAMESPACE | Namespace of the context |
| ATTRIBUTE | Attribute of the context |
| OBJECT_OWNER | Schema of the synonym, table, or view |
| OBJECT_NAME | Name of the synonym, table, or view |
| POLICY_GROUP | Policy group defined |
| OWNER | |
| OBJECT_NAME | Name of the object : top level function/procedure/package name |
| PROCEDURE_NAME | Name of the procedure |
| AGGREGATE | Is it an aggregate function ? |
| PIPELINED | Is it a pipelined table function ? |
| IMPLTYPEOWNER | Name of the owner of the implementation type (if any) |
| IMPLTYPENAME | Name of the implementation type (if any) |
| PARALLEL | Is the procedure parallel enabled ? |
| INTERFACE | |
| DETERMINISTIC | |
| AUTHID |
| PROPAGATION_NAME | name of the Streams propagation |
| SOURCE_QUEUE_OWNER | owner of the propgation source queue |
| SOURCE_QUEUE_NAME | name of the propagation source queue |
| DESTINATION_QUEUE_OWNER | owner of the propagation destination queue |
| DESTINATION_QUEUE_NAME | name of the propagation destination queue |
| DESTINATION_DBLINK | database link to access the propagation destination queue |
| RULE_SET_OWNER | propagation rule set owner |
| RULE_SET_NAME | propagation rule set name |
| OWNER | Owner of the queue |
| NAME | Name of the queue |
| QUEUE_TABLE | Name of the table the queue data resides in |
| QID | Object number of the queue |
| QUEUE_TYPE | Type of the queue |
| MAX_RETRIES | Maximum number of retries allowed when dequeuing from the queue |
| RETRY_DELAY | Time interval between retries |
| ENQUEUE_ENABLED | Queue is enabled for enqueue |
| DEQUEUE_ENABLED | Queue is enabled for dequeue |
| RETENTION | Time interval processed messages retained in the queue |
| USER_COMMENT | User specified comment |
| OWNER | Owner of the queue table |
| QUEUE_TABLE | Name of the queue table |
| TYPE | Name of the payload type |
| OBJECT_TYPE | Name of the payload type for object type payload |
| SORT_ORDER | Sort order for the queue table |
| RECIPIENTS | Mulitple or single recipient queue |
| MESSAGE_GROUPING | Transaction grouping |
| COMPATIBLE | Compatibility version of the queue table |
| PRIMARY_INSTANCE | Instance assigned as the primary owner of the queue table |
| SECONDARY_INSTANCE | Instance assigned as the secondary owner of the queue table |
| OWNER_INSTANCE | Instance which owns the queue table currently |
| USER_COMMENT | User specified comment |
| SECURE | Secure queue table |
| ROWNER | Name of the owner of the refresh group |
| RNAME | Name of the refresh group |
| REFGROUP | Internal identifier of refresh group |
| IMPLICIT_DESTROY | Y or N, if Y then destroy the refresh group when its last item is subtracted |
| PUSH_DEFERRED_RPC | Y or N, if Y then push changes from snapshot to master before refresh |
| REFRESH_AFTER_ERRORS | If Y, proceed with refresh despite error when pushing deferred RPCs |
| ROLLBACK_SEG | Name of the rollback segment to use while refreshing |
| JOB | Identifier of job used to automatically refresh the group |
| NEXT_DATE | Date that this job will next be automatically refreshed, if not broken |
| INTERVAL | A date function used to compute the next NEXT_DATE |
| BROKEN | Y or N, Y is the job is broken and will never be run |
| PURGE_OPTION | The method for purging the transaction queue after each push |
| PARALLELISM | The level of parallelism for transaction propagation |
| HEAP_SIZE | The heap size used for transaction propagation |
| OWNER | Owner of the object in the refresh group |
| NAME | Name of the object in the refresh group |
| TYPE | Type of the object in the refresh group |
| ROWNER | Name of the owner of the refresh group |
| RNAME | Name of the refresh group |
| REFGROUP | Internal identifier of refresh group |
| IMPLICIT_DESTROY | Y or N, if Y then destroy the refresh group when its last item is subtracted |
| PUSH_DEFERRED_RPC | Y or N, if Y then push changes from snapshot to master before refresh |
| REFRESH_AFTER_ERRORS | If Y, proceed with refresh despite error when pushing deferred RPCs |
| ROLLBACK_SEG | Name of the rollback segment to use while refreshing |
| JOB | Identifier of job used to automatically refresh the group |
| NEXT_DATE | Date that this job will next be automatically refreshed, if not broken |
| INTERVAL | A date function used to compute the next NEXT_DATE |
| BROKEN | Y or N, Y is the job is broken and will never be run |
| PURGE_OPTION | The method for purging the transaction queue after each push |
| PARALLELISM | The level of parallelism for transaction propagation |
| HEAP_SIZE | The heap size used for transaction propagation |
| OWNER | Owner of the dependent table |
| TABLE_NAME | Name of the dependent table |
| PARENT_OBJECT_TYPE | Materialized View |
| OLDEST_REFRESH_SCN | The oldest scn of a dependent materialized view |
| OLDEST_REFRESH_DATE | The oldest date scn of a dependent materialized view |
| OWNER | Owner of the table containing the REF column |
| TABLE_NAME | Name of the table containing the REF column |
| COLUMN_NAME | Column name or attribute of object column |
| WITH_ROWID | Is the REF value stored with the rowid? |
| IS_SCOPED | Is the REF column scoped? |
| SCOPE_TABLE_OWNER | Owner of the scope table, if it exists |
| SCOPE_TABLE_NAME | Name of the scope table, if it exists |
| OBJECT_ID_TYPE | If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED |
| OWNER | Owner of the materialized view |
| NAME | The name of the materialized view |
| MVIEW_SITE | Global name of the materialized view site |
| CAN_USE_LOG | If NO, this materialized view is complex and cannot fast refresh |
| UPDATABLE | If NO, the materialized view is read only |
| REFRESH_METHOD | Whether the materialized view uses rowid or primary key or object id for fast refresh |
| MVIEW_ID | Identifier for the materialized view used by the master for fast refresh |
| VERSION | Version of materialized view |
| QUERY_TXT | Query defining the materialized view |
| OWNER | Owner of the snapshot |
| NAME | The name of the snapshot |
| SNAPSHOT_SITE | Global name of the snapshot site |
| CAN_USE_LOG | If NO, this snapshot is complex and cannot fast refresh |
| UPDATABLE | If NO, the snapshot is read only |
| REFRESH_METHOD | Whether the snapshot uses rowid or primary key or object id for fast refresh |
| SNAPSHOT_ID | Identifier for the snapshot used by the master for fast refresh |
| VERSION | Version of snapshot |
| QUERY_TXT | Query defining the snapshot |
| ATTRIBUTE | Description of the attribute |
| DATA_TYPE | Datatype of the attribute value |
| DATA_LENGTH | Length of the attribute value in byte |
| SOURCE | Name of the function which returns the attribute value |
| SNAME | Owner of the shadow table |
| ONAME | Name of the shadow table |
| COLUMN_NAME | Name of the column in the shadow table |
| BASE_SNAME | Owner of replicated table |
| BASE_ONAME | Name of the replicated table |
| BASE_CONFLICT_TYPE | Type of conflict |
| BASE_REFERENCE_NAME | Table name, unique constraint name, or column group name |
| ATTRIBUTE | Description of the attribute |
| ID | Identifying number of repcat log record |
| SOURCE | Name of the database at which the request originated |
| USERID | Name of the user who submitted the request |
| TIMESTAMP | When the request was submitted |
| ROLE | Is this database the masterdef for the request |
| MASTER | Name of the database that processes this request |
| SNAME | Schema of replicated object name, if applicable |
| REQUEST | Name of the requested operation |
| ONAME | Replicated object name, if applicable |
| TYPE | Type of replicated object, if applicable |
| STATUS | Status of the request at this database |
| MESSAGE | Error message associated with processing the request |
| ERRNUM | Oracle error number associated with processing the request |
| GNAME | Name of the replicated object group |
| REFRESH_TEMPLATE_NAME | Name of the refresh group template. |
| OWNER | Owner of the refresh group template. |
| REFRESH_GROUP_NAME | Name of the refresh group to create during instantiation. |
| TEMPLATE_COMMENT | Optional comment field for the refresh group template. |
| PUBLIC_TEMPLATE | Flag specifying public template or private template. |
| REFRESH_TEMPLATE_NAME | Name of the refresh group template. |
| OBJECT_NAME | Name of the database object. |
| OBJECT_TYPE | Type of database object. |
| DDL_NUM | Order of DDLs for creating the object. |
| DDL_TEXT | DDL string for creating the object or WHERE clause for snapshot query. |
| MASTER_ROLLBACK_SEGMENT | Rollback segment for use during snapshot refreshes. |
| DERIVED_FROM_SNAME | Schema name of schema containing object this was derived from. |
| DERIVED_FROM_ONAME | Object name of object this object was derived from. |
| FLAVOR_ID | Foreign key to the REPCAT$_FLAVORS table. |
| REFRESH_TEMPLATE_NAME | Name of the refresh group template. |
| OWNER | Owner of the refresh group template. |
| REFRESH_GROUP_NAME | Name of the refresh group to create during instantiation. |
| TEMPLATE_COMMENT | Optional comment field for the refresh group template. |
| PUBLIC_TEMPLATE | Flag specifying public template or private template. |
| PARAMETER_NAME | name of the parameter. |
| DEFAULT_PARM_VALUE | Default value for the parameter. |
| PROMPT_STRING | String for use in prompting for parameter values. |
| USER_OVERRIDE | User override flag. |
| REFRESH_TEMPLATE_NAME | Name of the refresh group template. |
| REFRESH_GROUP_NAME | Name of the refresh group to create during instantiation. |
| TEMPLATE_OWNER | Owner of the refresh group template. |
| USER_NAME | Database user name. |
| SITE_NAME | Name of the site that has instantiated the template. |
| REPAPI_SITE_NAME | Name of the repapi site that has instantiated the template. |
| STATUS | Status of the instantiation at the site. |
| INSTANTIATION_DATE | Date template was instantiated. |
ALL_REPCAT_USER_AUTHORIZATIONS
| REFRESH_TEMPLATE_NAME | Name of the refresh group template. |
| OWNER | Owner of the refresh group template. |
| REFRESH_GROUP_NAME | Name of the refresh group to create during instantiation. |
| TEMPLATE_COMMENT | Optional comment field for the refresh group template. |
| PUBLIC_TEMPLATE | Flag specifying public template or private template. |
| USER_NAME | Database user name. |
| REFRESH_TEMPLATE_NAME | Name of the refresh group template. |
| OWNER | Owner of the refresh group template. |
| REFRESH_GROUP_NAME | Name of the refresh group to create during instantiation. |
| TEMPLATE_COMMENT | Optional comment field for the refresh group template. |
| PUBLIC_TEMPLATE | Flag specifying public template or private template. |
| PARAMETER_NAME | name of the parameter. |
| DEFAULT_PARM_VALUE | Default value for the parameter. |
| PROMPT_STRING | String for use in prompting for parameter values. |
| PARM_VALUE | Value of the parameter for this user. |
| USER_NAME | Database user name. |
| SNAME | Name of the object owner |
| ONAME | Name of the object |
| TYPE | Type of the object |
| CNAME | Name of the replicated column |
| ID | ID of the replicated column |
| POS | Ordering of the replicated column |
| COMPARE_OLD_ON_DELETE | Compare the old value of the column in replicated deletes |
| COMPARE_OLD_ON_UPDATE | Compare the old value of the column in replicated updates |
| SEND_OLD_ON_DELETE | Send the old value of the column in replicated deletes |
| SEND_OLD_ON_UPDATE | Send the old value of the column in replicated updates |
| CTYPE | Type of the column |
| CTYPE_TOID | Type OID of a column of TYPE |
| CTYPE_OWNER | Type owner of a column of TYPE |
| CTYPE_HASHCODE | Type hashcode of a column of TYPE |
| CTYPE_MOD | Datatype modifier of a column |
| DATA_LENGTH | Length of the column in bytes |
| DATA_PRECISION | Length: decimal digits (NUMBER) or binary digits (FLOAT) |
| DATA_SCALE | Digits to right of decimal point in a number |
| NULLABLE | Does column allow NULL values? |
| CHARACTER_SET_NAME | Name of character set for column, if applicable |
| TOP | Top column name for an attribute |
| CHAR_LENGTH | The maximim length of the column in characters |
| CHAR_USED | C if the width was specified in characters, B if in bytes |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| GROUP_NAME | Name of the column group |
| GROUP_COMMENT | Description of the column group |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| CONFLICT_TYPE | Type of conflict |
| REFERENCE_NAME | Table name, unique constraint name, or column group name |
| LOG_ID | Identifying number of the repcat log record |
| SOURCE | Name of the database at which the request originated |
| ROLE | Is this database the masterdef for the request |
| MASTER | Name of the database that processes this request |
| LINE | Ordering of records within a single request |
| TEXT | Portion of an argument |
| DDL_NUM | Order of ddls to execute |
| FLAVOR_ID | Flavor identifier, unique within object group |
| GNAME | Name of the object group |
| FNAME | Name of the flavor |
| CREATION_DATE | Date on which the flavor was created |
| CREATED_BY | User that created the flavor |
| PUBLISHED | Indicates whether flavor is published (Y/N) or obsolete (O) |
| GROUP_OWNER |
| FNAME | Flavor name |
| GNAME | Object group name |
| SNAME | Schema containing the object |
| ONAME | Object name |
| CNAME | Column name |
| TYPE | Column type |
| POS | Ordering of column used as IN parameter in the replication procedures |
| GROUP_OWNER | Object group owner |
| TYPE_TOID | Type OID of a column of TYPE |
| TYPE_OWNER | Type owner of a column of TYPE |
| TYPE_HASHCODE | Type hashcode of a column of TYPE |
| TYPE_MOD | Datatype modifier of a column |
| TOP | Top column of this attribute column |
| FNAME | Flavor name |
| GNAME | Object group name |
| SNAME | Schema containing object |
| ONAME | Name of object |
| TYPE | Object type |
| GROUP_OWNER | Object group owner |
| SNAME | Schema containing the generated object |
| ONAME | Name of the generated object |
| TYPE | Type of the generated object |
| BASE_SNAME | Name of the object's owner |
| BASE_ONAME | Name of the object |
| BASE_TYPE | Type of the object |
| PACKAGE_PREFIX | Prefix for package wrapper |
| PROCEDURE_PREFIX | Procedure prefix for package wrapper or procedure wrapper |
| DISTRIBUTED | Is the generated object separately generated at each master |
| REASON | Reason the object was generated |
| SNAME | Schema containing the generated object |
| ONAME | Name of the generated object |
| TYPE | Type of the generated object |
| BASE_SNAME | Name of the object's owner |
| BASE_ONAME | Name of the object |
| BASE_TYPE | Type of the object |
| PACKAGE_PREFIX | Prefix for package wrapper |
| PROCEDURE_PREFIX | Procedure prefix for package wrapper or procedure wrapper |
| DISTRIBUTED | Is the generated object separately generated at each master |
| REASON | Reason the object was generated |
| SNAME | OBSOLETE COLUMN: Name of the replicated schema |
| MASTER | Is the site a master site for the replicated object group |
| STATUS | If the site is a master, the master's status |
| SCHEMA_COMMENT | Description of the replicated object group |
| GNAME | Name of the replicated object group |
| FNAME | Flavor name |
| RPC_PROCESSING_DISABLED | |
| OWNER | Owner of the replicated object group |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| GROUP_NAME | Name of the column group |
| COLUMN_NAME | Name of the column in the column group |
| USERNAME | Name of the user |
| GNAME | Name of the replicated object group |
| CREATED | Registration date |
| RECEIVER | Receiver privileges |
| PROXY_SNAPADMIN | Proxy snapadmin privileges |
| OWNER | Owner of the replicated object group |
| SNAME | Schema containing table |
| ONAME | Name of the table |
| COL | Column in the table |
| SNAME | Name of the object owner |
| ONAME | Name of the object |
| TYPE | Type of the object |
| STATUS | Status of the last create or alter request on the local object |
| GENERATION_STATUS | Status of whether the object needs to generate replication packages |
| ID | Identifier of the local object |
| OBJECT_COMMENT | Description of the replicated object |
| GNAME | Name of the replicated object group |
| MIN_COMMUNICATION | Send only necessary OLD and NEW values for an updated row? |
| REPLICATION_TRIGGER_EXISTS | Internal replication trigger exists? |
| INTERNAL_PACKAGE_EXISTS | Internal package exists? |
| GROUP_OWNER | Owner of the replicated object group |
| NESTED_TABLE | Storage table for a nested table column? |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| CONFLICT_TYPE | Type of conflict |
| REFERENCE_NAME | Table name, unique constraint name, or column group name |
| SEQUENCE_NO | Ordering on resolution |
| METHOD_NAME | |
| FUNCTION_NAME | |
| PRIORITY_GROUP | |
| PARAMETER_TABLE_NAME | Name of the table to which the parameter column belongs |
| PARAMETER_COLUMN_NAME | Name of the parameter column used for resolving the conflict |
| PARAMETER_SEQUENCE_NO | Ordering on parameter column |
| SNAME | OBSOLETE COLUMN: Name of the replicated schema |
| PRIORITY_GROUP | Name of the priority group |
| PRIORITY | Priority of the value |
| DATA_TYPE | Datatype of the value |
| FIXED_DATA_LENGTH | Length of the value in bytes if the datatype is CHAR |
| CHAR_VALUE | Blank-padded character string |
| VARCHAR2_VALUE | Character string |
| NUMBER_VALUE | Numeric value |
| DATE_VALUE | Date value |
| RAW_VALUE | Raw value |
| GNAME | Name of the replicated object group |
| NCHAR_VALUE | NCHAR string |
| NVARCHAR2_VALUE | NVARCHAR2 string |
| LARGE_CHAR_VALUE | Blank-padded character string over 255 characters |
| SNAME | OBSOLETE COLUMN: Name of the replicated schema |
| PRIORITY_GROUP | Name of the priority group |
| DATA_TYPE | Datatype of the value in the priority group |
| FIXED_DATA_LENGTH | Length of the value in bytes if the datatype is CHAR |
| PRIORITY_COMMENT | Description of the priority group |
| GNAME | Name of the replicated object group |
| SNAME | Name of the object owner |
| ONAME | Name of the object |
| TYPE | Type of the object |
| DBLINK | Destination database for propagation |
| HOW | Propagation choice for the destination database |
| PROPAGATE_COMMENT | Description of the propagation choice |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| CONFLICT_TYPE | Type of conflict |
| REFERENCE_NAME | Table name, unique constraint name, or column group name |
| SEQUENCE_NO | Ordering on resolution |
| METHOD_NAME | Name of the conflict resolution method |
| FUNCTION_NAME | Name of the resolution function |
| PRIORITY_GROUP | Name of the priority group used in conflict resolution |
| RESOLUTION_COMMENT | Description of the conflict resolution |
| CONFLICT_TYPE | Type of conflict |
| METHOD_NAME | Name of the conflict resolution method |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| CONFLICT_TYPE | Type of conflict |
| REFERENCE_NAME | Table name, unique constraint name, or column group name |
| METHOD_NAME | Name of the conflict resolution method |
| FUNCTION_NAME | Name of the resolution function |
| PRIORITY_GROUP | Name of the priority group used in conflict resolution |
| RESOLVED_DATE | Timestamp for the resolution of the conflict |
| PRIMARY_KEY_VALUE | Primary key of the replicated row (character data) |
| SNAME | Owner of replicated object |
| ONAME | Name of the replicated object |
| CREATED | Timestamp for which statistics collection was first started |
| STATUS | Status of statistics collection: ACTIVE, CANCELLED |
| STATUS_UPDATE_DATE | Timestamp for which the status was last updated |
| PURGED_DATE | Timestamp for the last purge of statistics data |
| LAST_PURGE_START_DATE | The last start date of the statistics purging date range |
| LAST_PURGE_END_DATE | The last end date of the statistics purging date range |
| SNAME | OBSOLETE COLUMN: Name of the replicated schema |
| DBLINK | A database site replicating the object group |
| MASTERDEF | Is the database the master definition site for the replicated object group |
| SNAPMASTER | For a snapshot site, is the database the current refresh master |
| MASTER_COMMENT | Description of the database site |
| GNAME | Name of the replicated object group |
| MASTER | Redundant information from all_repcat.master |
| GROUP_OWNER | Owner of the replicated object group |
| GNAME | Name of the replicated object group |
| DBLINK | A database site replicating the schema |
| MASTERDEF | Is the database the master definition site for the replicated object group |
| SNAPMASTER | For a snapshot site, is the database the current refresh master |
| MASTER_COMMENT | Description of the database site |
| MASTER | Redundant information from all_repcat.master |
| GROUP_OWNER | Owner of the replicated object group |
| RULE_OWNER | Owner of the rule |
| RULE_NAME | Name of the rule |
| RULE_CONDITION | the rule expression |
| RULE_EVALUATION_CONTEXT_OWNER | owner 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 | action context of the rule |
| RULE_COMMENT | user description of the rule |
| OWNER | Owner of the ruleset |
| RULESET_NAME | Name of the ruleset |
| RULESET_STORAGE_TABLE | name of the table to store rules in the ruleset |
| BASE_TABLE | name of the evaluation context for the rule set |
| RULESET_COMMENT | user description of the ruleset |
| RULE_SET_OWNER | Owner of the rule set |
| RULE_SET_NAME | Name of the rule set |
| RULE_SET_EVAL_CONTEXT_OWNER | The evaluation context owner name associated with the rule set, if any |
| RULE_SET_EVAL_CONTEXT_NAME | The evaluation context name associated with the rule set, if any |
| RULE_SET_COMMENT | user description of the rule set |
| RULE_SET_OWNER | Owner of the rule set |
| RULE_SET_NAME | Name of the rule set |
| RULE_OWNER | Owner of the rule |
| RULE_NAME | Name of the rule |
| RULE_SET_RULE_ENABLED | Whether the rule is enabled in this ruleset |
| 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 | User description of this mapping |
| INDEX_OWNER | Name of the domain index owner |
| INDEX_NAME | Name of the domain index |
| SECONDARY_OBJECT_OWNER | Owner of the secondary object |
| SECONDARY_OBJECT_NAME | Name of the secondary object |
| SEQUENCE_OWNER | Name of the owner of the sequence |
| SEQUENCE_NAME | SEQUENCE name |
| MIN_VALUE | Minimum value of the sequence |
| MAX_VALUE | Maximum value of the sequence |
| INCREMENT_BY | Value by which sequence is incremented |
| CYCLE_FLAG | Does sequence wrap around on reaching limit? |
| ORDER_FLAG | Are sequence numbers generated in order? |
| CACHE_SIZE | Number of sequence numbers to cache |
| LAST_NUMBER | Last sequence number written to disk |
| OWNER | Owner of the snapshot |
| NAME | The view used by users and applications for viewing the snapshot |
| TABLE_NAME | Table the snapshot is stored in -- has an extra column for the master rowid |
| MASTER_VIEW | View of the master table, owned by the snapshot owner, used for refreshes |
| MASTER_OWNER | Owner of the master table |
| MASTER | Name of the master table that this snapshot is a copy of |
| MASTER_LINK | Database link name to the master site |
| CAN_USE_LOG | If NO, this snapshot is complex and will never use a log |
| UPDATABLE | If NO, the snapshot is read only. Look up REPLICATION |
| REFRESH_METHOD | The values used to drive a fast refresh of the snapshot |
| LAST_REFRESH | SYSDATE from the master site at the time of the last refresh |
| ERROR | The error returned last time an automatic refresh was attempted |
| FR_OPERATIONS | |
| CR_OPERATIONS | |
| TYPE | The type of refresh (complete,fast,force) for all automatic refreshes |
| NEXT | The date function used to compute next refresh dates |
| START_WITH | The date function used to compute next refresh dates |
| REFRESH_GROUP | All snapshots in a given refresh group get refreshed in the same transaction |
| UPDATE_TRIG | The name of the trigger which fills the UPDATE_LOG |
| UPDATE_LOG | The table which logs changes made to an updatable snapshots |
| QUERY | The original query that this snapshot is an instantiation of |
| MASTER_ROLLBACK_SEG | Rollback segment to use at the master site |
| STATUS | The status of the contents of the snapshot |
| REFRESH_MODE | This indicates how and when the snapshot will be refreshed |
| PREBUILT | If YES, this snapshot uses a prebuilt table as the base table |
| LOG_OWNER | Owner of the snapshot log |
| MASTER | Name of the master table which changes are logged |
| LOG_TABLE | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TRIGGER | An after-row trigger on the master which inserts rows into the log |
| ROWIDS | If YES, the snapshot log records rowid information |
| PRIMARY_KEY | If YES, the snapshot log records primary key information |
| OBJECT_ID | If YES, the snapshot log records object id information |
| FILTER_COLUMNS | If YES, the snapshot log records filter column information |
| SEQUENCE | If YES, the snapshot log records sequence information |
| INCLUDE_NEW_VALUES | If YES, the snapshot log records old and new values (else only old values) |
| CURRENT_SNAPSHOTS | One date per snapshot -- the date the snapshot of the master last refreshed |
| SNAPSHOT_ID | Unique identifier of the snapshot |
| OWNER | Owner of the materialized view |
| NAME | The view used by users and applications for viewing the MV |
| MASTER_OWNER | Owner of the master table |
| MASTER | Name of the master table |
| LAST_REFRESH | SYSDATE from the master site at the time of the last refresh |
| OWNER | Owner of the object |
| NAME | Name of the object |
| TYPE | Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY" or "JAVA SOURCE" |
| LINE | Line number of this line of source |
| TEXT | Source text |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| TYPE_OID | Object identifier (OID) of the type |
| EXTERNAL_NAME | External class name of the type |
| USING | Representation of the type |
| TYPECODE | Typecode of the type |
| ATTRIBUTES | Number of attributes in the type |
| METHODS | Number of methods in the type |
| PREDEFINED | Is the type a predefined type? |
| INCOMPLETE | Is the type an incomplete type? |
| FINAL | Is the type a final type? |
| INSTANTIABLE | Is the type an instantiable type? |
| SUPERTYPE_OWNER | Owner of the supertype (null if type is not a subtype) |
| SUPERTYPE_NAME | Name of the supertype (null if type is not a subtype) |
| LOCAL_ATTRIBUTES | Number of local (not inherited) attributes (if any) in the subtype |
| LOCAL_METHODS | Number of local (not inherited) methods (if any) in the subtype |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| ATTR_NAME | Name of the attribute |
| EXTERNAL_ATTR_NAME | External name of the attribute |
| ATTR_TYPE_MOD | Type modifier of the attribute |
| ATTR_TYPE_OWNER | Owner of the type of the attribute |
| ATTR_TYPE_NAME | Name of the type of the attribute |
| LENGTH | Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute |
| PRECISION | Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute |
| SCALE | Scale of the NUMBER or DECIMAL attribute |
| CHARACTER_SET_NAME | Character set name of the attribute |
| ATTR_NO | Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number) |
| INHERITED | Is the attribute inherited from the supertype ? |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| METHOD_NAME | Name of the method |
| EXTERNAL_VAR_NAME | Name of the external variable |
| METHOD_NO | Method number for distinguishing overloaded method (not to be used as ID number) |
| METHOD_TYPE | Type of the method |
| PARAMETERS | Number of parameters to the method |
| RESULTS | Number of results returned by the method |
| FINAL | Is the method final ? |
| INSTANTIABLE | Is the method instantiable ? |
| OVERRIDING | Is the method overriding a supertype method ? |
| INHERITED | Is the method inherited from the supertype ? |
| OWNER | Username of the owner of the object |
| OBJECT_NAME | Name of the object |
| OBJECT_ID | Object number of the object |
| OBJECT_TYPE | Type of the object |
| PARAM_NAME | Name of the parameter |
| PARAM_VALUE | Value of the parameter |
| STREAMS_NAME | Name of the streams process: capture/propagation/apply process |
| STREAMS_TYPE | Type of the streams process: CAPTURE, PROPAGATION or APPLY |
| RULE_TYPE | Type of rule: DML or DDL |
| INCLUDE_TAGGED_LCR | Whether or not to include tagged LCR |
| SOURCE_DATABASE | Name of the database where the LCRs originated |
| RULE_NAME | Name of the rule to be applied |
| RULE_OWNER | Owner of the rule |
| RULE_CONDITION | Generated rule condition evaluated by the rules engine |
| STREAMS_NAME | Name of the streams process: capture/propagation/apply process |
| STREAMS_TYPE | Type of the streams process: CAPTURE, PROPAGATION or APPLY |
| SCHEMA_NAME | Name of the schema selected by this rule |
| RULE_TYPE | Type of rule: DML or DDL |
| INCLUDE_TAGGED_LCR | Whether or not to include tagged LCR |
| SOURCE_DATABASE | Name of the database where the LCRs originated |
| RULE_NAME | Name of the rule to be applied |
| RULE_OWNER | Owner of the rule |
| RULE_CONDITION | Generated rule condition evaluated by the rules engine |
| STREAMS_NAME | Name of the streams process: capture/propagation/apply process |
| STREAMS_TYPE | Type of the streams process: CAPTURE, PROPAGATION or APPLY |
| TABLE_OWNER | Owner of the table selected by this rule |
| TABLE_NAME | Name of the table selected by this rule |
| RULE_TYPE | Type of rule: DML or DDL |
| DML_CONDITION | Row subsetting condition |
| SUBSETTING_OPERATION | DML operation for row subsetting |
| INCLUDE_TAGGED_LCR | Whether or not to include tagged LCR |
| SOURCE_DATABASE | Name of the database where the LCRs originated |
| RULE_NAME | Name of the rule to be applied |
| RULE_OWNER | Owner of the rule |
| RULE_CONDITION | Generated rule condition evaluated by the rules engine |
| TABLEOBJ# | Object number of the table |
| PARTITIONOBJ# | Object number of table partitions (if the table is partitioned) |
| DMLOPERATION | Type of DML operation applied to the table |
| SCN | SCN when the bulk DML occurred |
| TIMESTAMP | Timestamp of log entry |
| LOWROWID | The start ROWID in the loaded rowid range |
| HIGHROWID | The end ROWID in the loaded rowid range |
| SEQUENCE | The sequence# of the direct load |
| OWNER | Owner of the summary |
| SUMMARY_NAME | Name of the summary |
| CONTAINER_OWNER | Owner of the container table |
| CONTAINER_NAME | Name of the container table for this summary |
| LAST_REFRESH_SCN | The SCN of the last transaction to refresh the summary |
| LAST_REFRESH_DATE | The date of the last refresh of the summary |
| REFRESH_METHOD | User declared method of refresh for the summary |
| SUMMARY | Indicates the presence of either aggregation or a GROUP BY |
| FULLREFRESHTIM | The time that it took to fully refresh the summary |
| INCREFRESHTIM | The time that it took to incrementally refresh the summary |
| CONTAINS_VIEWS | This summary contains views in the FROM clause |
| UNUSABLE | This summary is unusable, the build was deferred |
| RESTRICTED_SYNTAX | This summary contains restrictive syntax |
| INC_REFRESHABLE | This summary is not restricted from being incrementally refreshed |
| KNOWN_STALE | This summary is directly stale |
| QUERY_LEN | |
| QUERY |
| OWNER | Owner of the summary |
| SUMMARY_NAME | Name of the summary |
| POSITION_IN_SELECT | Position of this aggregated measure with the SELECT list |
| CONTAINER_COLUMN | Name of this column in the container table |
| AGG_FUNCTION | Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV |
| DISTINCTFLAG | Set to Y is this is a DISTINCT aggregation |
| MEASURE | The SQL text of the measure, excluding the aggregation function |
| OWNER | Owner of the summary |
| SUMMARY_NAME | Name of the summary |
| DETAIL_OWNER | Owner of the detail relation |
| DETAIL_RELATION | Name of the summary detail table |
| DETAIL_TYPE | Type of summary detail table type |
| DETAIL_ALIAS | Alias of the detail relation if used |
| OWNER | Owner of the summary |
| SUMMARY_NAME | Name of the summary |
| DETAILOBJ1_OWNER | Owner of the 1st detail object |
| DETAILOBJ1_RELATION | Name of the 1st detail object |
| DETAILOBJ1_COLUMN | Name of the 1st detail object column |
| OPERATOR | Name of the join operator. Currently only = is defined |
| DETAILOBJ2_OWNER | Owner of the 2nd detail object |
| DETAILOBJ2_RELATION | Name of the 2nd detail object |
| DETAILOBJ2_COLUMN | Name of the 2nd detail object column |
| OWNER | Owner of the summary |
| SUMMARY_NAME | Name of the summary |
| POSITION_IN_SELECT | Position of this key within the SELECT list |
| CONTAINER_COLUMN | Name of the column in the container table |
| DETAILOBJ_OWNER | Owner of the detail object |
| DETAILOBJ_NAME | Name of the detail object |
| DETAILOBJ_ALIAS | Alias of the detail object |
| DETAILOBJ_TYPE | Type of the detail object: VIEW or TABLE |
| DETAILOBJ_COLUMN | Name of the detail object column |
| OWNER | Owner of the synonym |
| SYNONYM_NAME | Name of the synonym |
| TABLE_OWNER | Owner of the object referenced by the synonym |
| TABLE_NAME | Name of the object referenced by the synonym |
| DB_LINK | Name of the database link referenced in a remote synonym |
| BUFFER_POOL | The default buffer pool to be used for table blocks |
| ROW_MOVEMENT | Whether partitioned row movement is enabled or disabled |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| USER_STATS | Were the statistics entered directly by the user? |
| DURATION | If temporary table, then duration is sys$session or sys$transaction else NULL |
| SKIP_CORRUPT | Whether skip corrupt blocks is enabled or disabled |
| MONITORING | Should we keep track of the amount of modification? |
| CLUSTER_OWNER | Owner of the cluster, if any, to which the table belongs |
| DEPENDENCIES | Should we keep track of row level dependencies? |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table |
| TABLESPACE_NAME | Name of the tablespace containing the table |
| CLUSTER_NAME | Name of the cluster, if any, to which the table belongs |
| IOT_NAME | Name of the index-only table, if any, to which the overflow or mapping table entry belongs |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_USED | Minimum percentage of used space in a block |
| INI_TRANS | Initial number of transactions |
| MAX_TRANS | Maximum number of transactions |
| INITIAL_EXTENT | Size of the initial extent in bytes |
| NEXT_EXTENT | Size of secondary extents in bytes |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE | Percentage increase in extent size |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated in this segment |
| LOGGING | Logging attribute |
| BACKED_UP | Has table been backed up since last modification? |
| NUM_ROWS | The number of rows in the table |
| BLOCKS | The number of used blocks in the table |
| EMPTY_BLOCKS | The number of empty (never used) blocks in the table |
| AVG_SPACE | The average available free space in the table |
| CHAIN_CNT | The number of chained rows in the table |
| AVG_ROW_LEN | The average row length, including row overhead |
| AVG_SPACE_FREELIST_BLOCKS | The average freespace of all blocks on a freelist |
| NUM_FREELIST_BLOCKS | The number of blocks on the freelist |
| DEGREE | The number of threads per instance for scanning the table |
| INSTANCES | The number of instances across which the table is to be scanned |
| CACHE | Whether the table is to be cached in the buffer cache |
| TABLE_LOCK | Whether table locking is enabled or disabled |
| SAMPLE_SIZE | The sample size used in analyzing this table |
| LAST_ANALYZED | The date of the most recent time this table was analyzed |
| PARTITIONED | Is this table partitioned? YES or NO |
| IOT_TYPE | If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL |
| TEMPORARY | Can the current session only see data that it place in this object itself? |
| SECONDARY | Is this table object created as part of icreate for domain indexes? |
| NESTED | Is the table a nested table? |
| COLUMN_ID | Sequence number of the column as created |
| DEFAULT_LENGTH | Length of default value for the column |
| DATA_DEFAULT | Default value for the column |
| NUM_DISTINCT | The number of distinct values in the column |
| LOW_VALUE | The low value in the column |
| HIGH_VALUE | The high value in the column |
| DENSITY | The density of the column |
| NUM_NULLS | The number of nulls in the column |
| NUM_BUCKETS | The number of buckets in histogram for the column |
| LAST_ANALYZED | The date of the most recent time this column was analyzed |
| SAMPLE_SIZE | The sample size used in analyzing this column |
| CHARACTER_SET_NAME | Character set name |
| CHAR_COL_DECL_LENGTH | Declaration length of character type column |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| USER_STATS | Were the statistics entered directly by the user? |
| AVG_COL_LEN | The average length of the column in bytes |
| CHAR_LENGTH | The maximum length of the column in characters |
| CHAR_USED | C if maximum length is specified in characters, B if in bytes |
| V80_FMT_IMAGE | Is column data in 8.0 image format? |
| DATA_UPGRADED | Has column data been upgraded to the latest type version format? |
| HIDDEN_COLUMN | Is this a hidden column? |
| VIRTUAL_COLUMN | Is this a virtual column? |
| SEGMENT_COLUMN_ID | Sequence number of the column in the segment |
| INTERNAL_COLUMN_ID | Internal sequence number of the column |
| OWNER | |
| TABLE_NAME | Table, view or cluster name |
| COLUMN_NAME | Column name |
| DATA_TYPE | Datatype of the column |
| DATA_TYPE_MOD | Datatype modifier of the column |
| DATA_TYPE_OWNER | Owner of the datatype of the column |
| DATA_LENGTH | Length of the column in bytes |
| DATA_PRECISION | Length: decimal digits (NUMBER) or binary digits (FLOAT) |
| DATA_SCALE | Digits to right of decimal point in a number |
| NULLABLE | Does column allow NULL values? |
| OWNER | |
| TABLE_NAME | Table, view or cluster name |
| COLUMN_NAME | Column name |
| DATA_TYPE | Datatype of the column |
| DATA_TYPE_MOD | Datatype modifier of the column |
| DATA_TYPE_OWNER | Owner of the datatype of the column |
| DATA_LENGTH | Length of the column in bytes |
| DATA_PRECISION | Length: decimal digits (NUMBER) or binary digits (FLOAT) |
| DATA_SCALE | Digits to right of decimal point in a number |
| NULLABLE | Does column allow NULL values? |
| COLUMN_ID | Sequence number of the column as created |
| DEFAULT_LENGTH | Length of default value for the column |
| DATA_DEFAULT | Default value for the column |
| NUM_DISTINCT | The number of distinct values in the column |
| LOW_VALUE | The low value in the column |
| HIGH_VALUE | The high value in the column |
| DENSITY | The density of the column |
| NUM_NULLS | The number of nulls in the column |
| NUM_BUCKETS | The number of buckets in histogram for the column |
| LAST_ANALYZED | The date of the most recent time this column was analyzed |
| SAMPLE_SIZE | The sample size used in analyzing this column |
| CHARACTER_SET_NAME | Character set name |
| CHAR_COL_DECL_LENGTH | Declaration length of character type column |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| USER_STATS | Were the statistics entered directly by the user? |
| AVG_COL_LEN | The average length of the column in bytes |
| CHAR_LENGTH | The maximum length of the column in characters |
| CHAR_USED | C if maximum length is specified in characters, B if in bytes |
| V80_FMT_IMAGE | Is column data in 8.0 image format? |
| DATA_UPGRADED | Has column data been upgraded to the latest type version format? |
| OWNER | Table, view or cluster owner |
| TABLE_NAME | Table, view or cluster name |
| COLUMN_NAME | Column name |
| NUM_DISTINCT | The number of distinct values in the column |
| LOW_VALUE | The low value in the column |
| HIGH_VALUE | The high value in the column |
| DENSITY | The density of the column |
| NUM_NULLS | The number of nulls in the column |
| NUM_BUCKETS | The number of buckets in histogram for the column |
| LAST_ANALYZED | The date of the most recent time this column was analyzed |
| SAMPLE_SIZE | The sample size used in analyzing this column |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| USER_STATS | Were the statistics entered directly by the user? |
| AVG_COL_LEN | The average length of the column in bytes |
| OWNER | Owner of the object |
| TABLE_NAME | Name of the object |
| TABLE_TYPE | Type of the object |
| COMMENTS | Comment on the object |
| OWNER | Owner of table |
| TABLE_NAME | Table name |
| COLUMN_NAME | Column name or attribute of object column |
| ENDPOINT_NUMBER | Endpoint number |
| ENDPOINT_VALUE | Normalized endpoint value |
| ENDPOINT_ACTUAL_VALUE | Actual endpoint value |
| TABLE_OWNER | Owner of modified table |
| TABLE_NAME | Modified table |
| PARTITION_NAME | Modified partition |
| SUBPARTITION_NAME | Modified subpartition |
| INSERTS | Approximate number of rows inserted since last analyze |
| UPDATES | Approximate number of rows updated since last analyze |
| DELETES | Approximate number of rows deleted since last analyze |
| TIMESTAMP | Timestamp of last time this row was modified |
| TRUNCATED | Was this object truncated since the last analyze? |
| GRANTOR | Name of the user who performed the grant |
| GRANTEE | Name of the user to whom access was granted |
| TABLE_SCHEMA | Schema of the object |
| TABLE_NAME | Name of the object |
| PRIVILEGE | Table Privilege |
| GRANTABLE | Privilege is grantable |
| HIERARCHY | Privilege is with hierarchy option |
| GRANTEE | Name of the user to whom access was granted |
| OWNER | Owner of the object |
| TABLE_NAME | Name of the object |
| GRANTOR | Name of the user who performed the grant |
| PRIVILEGE | Table Privilege |
| GRANTABLE | Privilege is grantable |
| HIERARCHY | Privilege is with hierarchy option |
| GRANTEE | Name of the user to whom access was granted |
| OWNER | Owner of the object |
| TABLE_NAME | Name of the object |
| GRANTOR | Name of the user who performed the grant |
| PRIVILEGE | Table Privilege |
| GRANTABLE | Privilege is grantable |
| HIERARCHY | Privilege is with hierarchy option |
| OWNER | Owner of the trigger |
| TRIGGER_NAME | Name of the trigger |
| TRIGGER_TYPE | When the trigger fires - BEFORE/AFTER and STATEMENT/ROW |
| TRIGGERING_EVENT | Statement that will fire the trigger - INSERT, UPDATE and/or DELETE |
| TABLE_OWNER | Owner of the table that this trigger is associated with |
| BASE_OBJECT_TYPE | |
| TABLE_NAME | Name of the table that this trigger is associated with |
| COLUMN_NAME | The name of the column on which the trigger is defined over |
| REFERENCING_NAMES | Names used for referencing to OLD and NEW values within the trigger |
| WHEN_CLAUSE | WHEN clause must evaluate to true in order for triggering body to execute |
| STATUS | If DISABLED then trigger will not fire |
| DESCRIPTION | Trigger description, useful for re-creating trigger creation statement |
| ACTION_TYPE | |
| TRIGGER_BODY | Action taken by this trigger when it fires |
| TRIGGER_OWNER | Owner of the trigger |
| TRIGGER_NAME | Name of the trigger |
| TABLE_OWNER | Owner of the table |
| TABLE_NAME | Name of the table on which the trigger is defined |
| COLUMN_NAME | Name of the column or the attribute of the ADT column used in trigger definition |
| COLUMN_LIST | Is column specified in UPDATE OF clause? |
| COLUMN_USAGE | Usage of column within trigger body |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| TYPE_OID | Object identifier (OID) of the type |
| TYPECODE | Typecode of the type |
| ATTRIBUTES | Number of attributes in the type |
| METHODS | Number of methods in the type |
| PREDEFINED | Is the type a predefined type? |
| INCOMPLETE | Is the type an incomplete type? |
| FINAL | Is the type a final type? |
| INSTANTIABLE | Is the type an instantiable type? |
| SUPERTYPE_OWNER | Owner of the supertype (null if type is not a subtype) |
| SUPERTYPE_NAME | Name of the supertype (null if type is not a subtype) |
| LOCAL_ATTRIBUTES | Number of local (not inherited) attributes (if any) in the subtype |
| LOCAL_METHODS | Number of local (not inherited) methods (if any) in the subtype |
| TYPEID | Type id value of the type |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| ATTR_NAME | Name of the attribute |
| ATTR_TYPE_MOD | Type modifier of the attribute |
| ATTR_TYPE_OWNER | Owner of the type of the attribute |
| ATTR_TYPE_NAME | Name of the type of the attribute |
| LENGTH | Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute |
| PRECISION | Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute |
| SCALE | Scale of the NUMBER or DECIMAL attribute |
| CHARACTER_SET_NAME | Character set name of the attribute |
| ATTR_NO | Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number) |
| INHERITED | Is the attribute inherited from the supertype ? |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| METHOD_NAME | Name of the method |
| METHOD_NO | Method number for distinguishing overloaded method (not to be used as ID number) |
| METHOD_TYPE | Type of the method |
| PARAMETERS | Number of parameters to the method |
| RESULTS | Number of results returned by the method |
| FINAL | Is the method final ? |
| INSTANTIABLE | Is the method instantiable ? |
| OVERRIDING | Is the method overriding a supertype method ? |
| INHERITED | Is the method inherited from the supertype ? |
| OWNER | Owner of the type |
| TYPE_NAME | Name of the type |
| VERSION# | Internal version number of the type |
| TYPECODE | Typecode of the type |
| STATUS | Status of the type |
| LINE | Line number of the type's spec |
| TEXT | Text of the type's spec |
| HASHCODE | Hashcode of the type |
| OWNER | Owner of the table |
| TABLE_NAME | Name of the table |
| COUNT | Number of unused columns in table |
| OWNER | Table owner |
| TABLE_NAME | Table name |
| COLUMN_NAME | Column name |
| UPDATABLE | Is the column updatable? |
| INSERTABLE | Is the column insertable? |
| DELETABLE | Is the column deletable? |
| USERNAME | Name of the user |
| USER_ID | ID number of the user |
| CREATED | User creation date |
| OBJECT_OWNER | Owner of the table or index for which the statistics have been collected |
| OBJECT_NAME | Name of the table or index for which the statistics have been collected |
| PARTITION_NAME | Name of the partition (if applicable) for which the stats have been collected |
| OBJECT_TYPE | Type of the object - Column or Index |
| ASSOCIATION | If the statistics type association is direct or implicit |
| COLUMN_NAME | Column name, if property is column for which statistics have been collected |
| STATSTYPE_SCHEMA | Schema of statistics type which was used to collect the statistics |
| STATSTYPE_NAME | Name of statistics type which was used to collect statistics |
| STATISTICS | User collected statistics for the object |
| OWNER | Owner of the varray |
| PARENT_TABLE_NAME | Name of the parent table containing the varray |
| PARENT_TABLE_COLUMN | Column name of the parent table that corresponds to the varray |
| TYPE_OWNER | Owner of the type of which the varray was created |
| TYPE_NAME | Name of the type of the varray |
| LOB_NAME | Name of the lob if varray is stored in a lob |
| STORAGE_SPEC | Indication of default or user-specified storage for the varray |
| RETURN_TYPE | Return type of the varray column locator or value |
| ELEMENT_SUBSTITUTABLE | Indication of whether the varray element is substitutable or not |
| OWNER | Owner of the view |
| VIEW_NAME | Name of the view |
| TEXT_LENGTH | Length of the view text |
| TEXT | View text |
| TYPE_TEXT_LENGTH | Length of the type clause of the object view |
| TYPE_TEXT | Type clause of the object view |
| OID_TEXT_LENGTH | Length of the WITH OBJECT OID clause of the object view |
| OID_TEXT | WITH OBJECT OID clause of the object view |
| VIEW_TYPE_OWNER | Owner of the type of the view if the view is an object view |
| VIEW_TYPE | Type of the view if the view is an object view |
| SUPERVIEW_NAME | Name of the superview, if view is a subview |