| 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? |
| 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 |
| ROLE | Name of Application Role |
| SCHEMA | Schema name of authorizing package |
| PACKAGE | Name of authorizing package |
| 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 - table, 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 | Interface number of Statistics type interface implemented |
| 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? |
| LOGOFF_LWRITE | Logical writes for the session |
| LOGOFF_DLOCK | Deadlocks detected during the session |
| COMMENT_TEXT | Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authe |
| ntication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type. | |
| SESSIONID | Numeric ID for each Oracle session |
| ENTRYID | Numeric ID for each audit trail entry in the session |
| STATEMENTID | Numeric ID for each statement run (a statement may cause many actions) |
| RETURNCODE | Oracle error code generated by the action. Zero if the action succeeded |
| PRIV_USED | System privilege used to execute the action |
| CLIENT_ID | Client identifier in each Oracle session |
| SESSION_CPU | Amount cpu time used by each oracel session |
| OS_USERNAME | Operating System logon user name of the user whose actions were audited |
| USERNAME | Name (not ID number) of the user whose actions were audited |
| USERHOST | Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files (e.g., clustered Oracle on |
| DEC VAX/VMS clusters) | |
| TERMINAL | Identifier for the user's terminal |
| TIMESTAMP | Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION) |
| OWNER | Creator of object affected by the action |
| OBJ_NAME | Name of the object affected by the action |
| ACTION | Numeric action type code. The corresponding name of the action type (CREATE TABLE, INSERT, etc.) is in the column ACTION_NAME |
| ACTION_NAME | Name of the action type corresponding to the numeric code in ACTION |
| NEW_OWNER | The owner of the object named in the NEW_NAME column |
| NEW_NAME | New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name) |
| OBJ_PRIVILEGE | Object privileges granted/revoked by a GRANT/REVOKE statement |
| SYS_PRIVILEGE | System privileges granted/revoked by a GRANT/REVOKE statement |
| ADMIN_OPTION | If role/sys_priv was granted WITH ADMIN OPTON, A/- |
| GRANTEE | The name of the grantee specified in a GRANT/REVOKE statement |
| AUDIT_OPTION | Auditing option set with the audit statement |
| SES_ACTIONS | Session summary. A string of 11 characters, one for each action type, in thisorder: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update. Values: "-" = None, "S" = Succ |
| ess, "F" = Failure, "B" = Both | |
| LOGOFF_TIME | Timestamp for user logoff |
| LOGOFF_LREAD | Logical reads for the session |
| LOGOFF_PREAD | Physical reads for the session |
| AW_NUMBER | |
| AW_NAME | Name of the Analytic Workspace |
| PAGESPACES | Number of pagespaces in the Analytic Workspace |
| GENERATIONS | Number of active generations in the Analytic Workspace |
| AW_NUMBER | |
| AW_NAME | Name of the Analytic Workspace |
| PSNUMBER | Number of the pagespace |
| GENERATIONS | Number of active generations in the pagespace |
| 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 |
| TABLE_NAME | Name of the object |
| TABLE_TYPE | Type of the object |
| 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 |
| CLUSTER_NAME | Cluster name |
| CLU_COLUMN_NAME | Key column in the cluster |
| TABLE_NAME | Clustered table name |
| TAB_COLUMN_NAME | Key column or attribute of object column in the table |
| 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? |
| TABLE_NAME | Object name |
| COLUMN_NAME | Column name |
| COMMENTS | Comment on the column |
| 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 |
| 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 | 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 the constraint |
| INDEX_NAME | The index used by the 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 |
| 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 |
| DB_LINK | Name of the database link |
| USERNAME | Name of user to log on as |
| PASSWORD | Password for logon |
| HOST | SQL*Net string for connect |
| CREATED | Creation time of the database link |
| 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 |
| SCHEMAID | |
| 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 |
| 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_NAME | Name of the evaluation context |
| EVALUATION_FUNCTION | User supplied function to evaluate rules |
| EVALUATION_CONTEXT_COMMENT | user description of the evaluation context |
USER_EVALUATION_CONTEXT_TABLES
| EVALUATION_CONTEXT_NAME | Name of the evaluation context |
| TABLE_ALIAS | Alias of the table |
| TABLE_NAME | Name of the table |
| 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 |
| SEGMENT_NAME | Name of the segment associated with the extent |
| PARTITION_NAME | Partition/Subpartition Name, if any, of the segment |
| SEGMENT_TYPE | Type of the segment |
| TABLESPACE_NAME | Name of the tablespace containing the extent |
| EXTENT_ID | Extent number in the segment |
| BYTES | Size of the extent in bytes |
| BLOCKS | Size of the extent in ORACLE blocks |
| 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 |
| 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 |
| TABLESPACE_NAME | Name of the tablespace containing the extent |
| FILE_ID | ID number of the file containing the extent |
| BLOCK_ID | Starting block number of the extent |
| BYTES | Size of the extent in bytes |
| BLOCKS | Size of the extent in ORACLE blocks |
| RELATIVE_FNO | Relative number of the file containing the extent |
| 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 |
| 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? |
| 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 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 |
| PCT_THRESHOLD | Threshold percentage of block space allowed per index entry |
| INCLUDE_COLUMN | User column-id for last column to be included in index-only 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 | Number of rows in the index |
| 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 |
| 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_NAME | Index name |
| 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 descending on disk, otherwise ASC |
| INDEX_NAME | Index name |
| 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_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) |
| 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 |
| 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 |
| 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 |
| 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 | |
| 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 | Trigger on master table; fills the materialized view 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 |
| 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 |
| 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 place 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? |
| NAME | Name of the object |
| TYPE | Type of the object: "TYPE", "TYPE BODY", "TABLE", "VIEW", "SYNONYM", "SEQUENCE", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "JAVA SOURCE", "JAVA CLASS", "JAVA RESOURCE" or "JAVA DATA" |
| SOURCE_SIZE | Size of the source, in bytes. Must be in memory during compilation, or dynamic recompilation |
| PARSED_SIZE | Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object |
| CODE_SIZE | Code size, in bytes. Must be in memory when this object is executing |
| ERROR_SIZE | Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors |
| 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? |
| 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 |
| OBJECT_NAME | Name of the object |
| OBJECT_TYPE | Type of the object: "TABLE" or "VIEW" |
| 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 (no used) |
| EXE | Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| CRE | |
| REA | |
| WRI | |
| 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 |
| TABLE_NAME | Name of the table |
| RESOURCE_NAME | Resource name |
| LIMIT | Limit placed on this resource |
| TABLE_NAME | Name of the table |
| 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_NAME | Name of the synonym, table, or view |
| NAMESPACE | Namespace of the context |
| ATTRIBUTE | Attribute of the context |
| OBJECT_NAME | Name of the synonym, table, or view |
| POLICY_GROUP | Policy group defined |
| 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 | |
| CLIENT | Name of the client user who the proxy user can act on behalf of |
| CREDENTIAL | Credential passed by the proxy for the client (if any) |
| TYPE | Type of the credential |
| VERSION | Version of the credential |
| AUTHORIZATION_CONSTRAINT | Indicates the proxy's authority to exercise roles on client's behalf |
| ROLE | Name of the role referenced in authorization constraint |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | |
USER_REPCAT_USER_AUTHORIZATION
| 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. |
| 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 maximum length of the column in characters |
| CHAR_USED | C if the width was specified in characters, B if in bytes |
| SNAME | Name of the user |
| 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 |
| ONAME | Name of the replicated object |
| GROUP_NAME | Name of the column group |
| GROUP_COMMENT | Description of the column group |
| 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 | Owner of the object group |
| 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 user |
| BASE_ONAME | Name of the user's object |
| BASE_TYPE | Type of the user's 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 user |
| BASE_ONAME | Name of the user's object |
| BASE_TYPE | Type of the user's 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 user |
| MASTER | Is the site a master site |
| STATUS | If site is master, the master's status |
| SCHEMA_COMMENT | User description of the replicated object group |
| GNAME | Name of the replicated object group |
| FNAME | Flavor name |
| RPC_PROCESSING_DISABLED | Whether this site disables processing of replication RPC |
| OWNER | Owner of the replicated object group |
| 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 | |
| SNAME | Schema containing table |
| ONAME | Name of the table |
| COL | Column in the table |
| SNAME | Name of the user |
| 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 | User description of the replicated object |
| GNAME | Name of the replicated objects group |
| MIN_COMMUNICATION | Send only necessary OLD and NEW values for an updated row? |
| REPLICATION_TRIGGER_EXISTS | Inline trigger flag exists? |
| INTERNAL_PACKAGE_EXISTS | Internal package exists? |
| GROUP_OWNER | Owner of the replicated objects group |
| NESTED_TABLE | Storage table for a nested table column? |
| SNAME | |
| 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 |
| 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 |
| NCHAR_VALUE | NCHAR string |
| NVARCHAR2_VALUE | NVARCHAR2 string |
| LARGE_CHAR_VALUE | Blank-padded character string over 255 characters |
| PRIORITY_GROUP | Name of the priority group |
| DATA_TYPE | Datatype of the value |
| FIXED_DATA_LENGTH | Length of the value in bytes if the datatype is CHAR |
| PRIORITY_COMMENT | Description of the priority group |
| SNAME | Name of the user |
| ONAME | Name of the object |
| TYPE | Type of the object |
| DBLINK | Destination database for propagation |
| HOW | Propagation choice for the destination database |
| PROPAGATE_COMMENT | User description of the propagation choice |
| 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 |
| 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) |
| 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 user |
| DBLINK | A database site replicating the object group |
| MASTERDEF | Is the database the master definition site for the replicated object group |
| SNAPMASTER | For snapshot sites, is the database the current refresh master |
| MASTER_COMMENT | User description of the database site |
| GNAME | Name of the replicated object group |
| MASTER | Redundant information from user_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 snapshot sites, is the database the current refresh master |
| MASTER_COMMENT | User description of the database site |
| MASTER | Redundant information from user_repcat.master |
| GROUP_OWNER | Owner of the replicated object group |
| RESOURCE_NAME | Resource name |
| LIMIT | Limit placed on this resource |
| ERROR_MSG | The current error message |
| SESSION_ID | Session ID of this resumable session |
| INSTANCE_ID | Instance ID of this resumable session |
| COORD_INSTANCE_ID | Instance number of parallel query coordinator |
| COORD_SESSION_ID | Session number of parallel query coordinator |
| STATUS | Status of this resumable session |
| TIMEOUT | Timeout of this resumable session |
| START_TIME | Start time of the current transaction |
| SUSPEND_TIME | Suspend time of the current statement |
| RESUME_TIME | Resume time of the current statement |
| NAME | Name of this resumable session |
| SQL_TEXT | The current SQL text |
| ERROR_NUMBER | The current error number |
| ERROR_PARAMETER1 | The 1st parameter to the current error message |
| ERROR_PARAMETER2 | The 2nd parameter to the current error message |
| ERROR_PARAMETER3 | The 3rd parameter to the current error message |
| ERROR_PARAMETER4 | The 4th parameter to the current error message |
| ERROR_PARAMETER5 | The 5th parameter to the current error message |
| USERNAME | User Name or PUBLIC |
| GRANTED_ROLE | Granted role name |
| ADMIN_OPTION | Grant was with the ADMIN option |
| DEFAULT_ROLE | Role is designated as a DEFAULT ROLE for the user |
| OS_GRANTED | Role is granted via the operating system (using OS_ROLES = TRUE) |
USER_RSRC_CONSUMER_GROUP_PRIVS
| GRANTED_GROUP | consumer groups to which the user can switch |
| GRANT_OPTION | whether the user can grant the privilege to others |
| INITIAL_GROUP | |
USER_RSRC_MANAGER_SYSTEM_PRIVS
| PRIVILEGE | name of the system privilege |
| ADMIN_OPTION | whether the user can grant the privilege to others |
| 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 |
| 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_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_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 |
| FREELIST_GROUPS | Number of freelist groups allocated to this segment |
| BUFFER_POOL | The default buffer pool to be used for blocks from this segment |
| SEGMENT_NAME | Name, if any, of the segment |
| PARTITION_NAME | Partition/Subpartition Name, if any, of the segment |
| SEGMENT_TYPE | Type of segment: "TABLE", "CLUSTER", "INDEX", "ROLLBACK", "DEFERRED ROLLBACK", "TEMPORARY", "SPACE HEADER", "TYPE2 UNDO" or "CACHE" |
| TABLESPACE_NAME | Name of the tablespace containing the segment |
| BYTES | Size, in bytes, of the segment |
| BLOCKS | Size, in Oracle blocks, of the segment |
| EXTENTS | Number of extents allocated to the segment |
| INITIAL_EXTENT | Size, in bytes, of the initial extent of the segment |
| NEXT_EXTENT | Size, in bytes, of the next extent to be allocated to the segment |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE | Percent by which to increase the size of the next extent to be allocated |
| FREELISTS | Number of process freelists allocated to this segment |
| 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 |
| 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 |
| 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 |
| 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 | Trigger on master table; fills the snapshot 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 | Dates that all known simple snapshots last refreshed |
| SNAPSHOT_ID | |
| 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 |
| 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 |
| 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 (if any) in the type |
| METHODS | Number of methods (if any) 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 |
| 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 ? |
| 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 ? |
| 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 |
| 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 |
| 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 | Database link referenced in a remote synonym |
| USERNAME | User Name or PUBLIC |
| PRIVILEGE | System privilege |
| ADMIN_OPTION | Grant was with the ADMIN option |
| 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? |
| 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? |
| TABLESPACE_NAME | Tablespace name |
| BLOCK_SIZE | Tablespace block size |
| INITIAL_EXTENT | Default initial extent size |
| NEXT_EXTENT | Default incremental extent size |
| MIN_EXTENTS | Default minimum number of extents |
| MAX_EXTENTS | Default maximum number of extents |
| PCT_INCREASE | Default percent increase for extent size |
| MIN_EXTLEN | Minimum extent size for the tablespace |
| STATUS | Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY" |
| CONTENTS | Tablespace contents: "PERMANENT", or "TEMPORARY" |
| LOGGING | Default logging attribute |
| FORCE_LOGGING | Tablespace force logging mode |
| EXTENT_MANAGEMENT | Extent management tracking: "DICTIONARY" or "LOCAL" |
| ALLOCATION_TYPE | Type of extent allocation in effect for this tablespace |
| SEGMENT_SPACE_MANAGEMENT | Segment space management tracking: "AUTO" or "MANUAL" |
| 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 is maximum length given 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 |
| 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 is maximum length given 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? |
| 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 |
| TABLE_NAME | Name of the object |
| TABLE_TYPE | Type of the object: "TABLE" or "VIEW" |
| COMMENTS | Comment on the object |
| 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_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? |
| 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 |
| 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 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 |
| TRIGGER_NAME | Name of the trigger |
| TRIGGER_TYPE | Type of the trigger (when it 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, NEW and PARENT 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 |
| TABLESPACE_NAME | Tablespace name |
| BYTES | Number of bytes charged to the user |
| MAX_BYTES | User's quota in bytes. NULL if no limit |
| BLOCKS | Number of ORACLE blocks charged to the user |
| MAX_BLOCKS | User's quota in ORACLE blocks. NULL if no limit |
| TYPE_NAME | Name of the type |
| TYPE_OID | Object identifier (OID) of the type |
| TYPECODE | Typecode of the type |
| ATTRIBUTES | Number of attributes (if any) in the type |
| METHODS | Number of methods (if any) 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 |
| 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 ? |
| 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 ? |
| 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 |
| 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 |
| ACCOUNT_STATUS | |
| LOCK_DATE | |
| EXPIRY_DATE | |
| DEFAULT_TABLESPACE | Default tablespace for data |
| TEMPORARY_TABLESPACE | Default tablespace for temporary tables |
| CREATED | User creation date |
| INITIAL_RSRC_CONSUMER_GROUP | User's initial consumer group |
| EXTERNAL_NAME | User external name |
| 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 |
| 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 |
| 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 a object view |
| VIEW_TYPE | Type of the view if the view is a object view |
| SUPERVIEW_NAME | Name of the superview, if view is a subview |