iSelfSchooling.com Since 1999 References | Search more | Oracle Syntax | Free Online Oracle Training

Home .Services Login Start Learning Certification . .Share your BELIEF(s)...

. Online Accounting     .Copyright & User Agreement   |

    .Vision      .Biography     .Acknowledgement
.Contact Us      .Comments/Suggestions       Email2aFriend    |

Complete Syntax | Oracle Functions | PL/SQL Syntax | SQL Syntax | Tables

Oracle Dictionary Tables

ALL_ | DBA_ | USER_ | GV$ | V$ | Others

ALL... | CLU... | IND... | MVI... | PRO... | REP... | SNA... | TAB...

ALL_INDEXTYPE_ARRAYTYPES: All array types specified by the indextype

iSelfSchooling-SQL> desc ALL_INDEXTYPE_ARRAYTYPES;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

INDEXTYPE_NAME NOT NULL VARCHAR2(30)

BASE_TYPE_SCHEMA VARCHAR2(30)

BASE_TYPE_NAME VARCHAR2(30)

BASE_TYPE VARCHAR2(30)

ARRAY_TYPE_SCHEMA NOT NULL VARCHAR2(30)

ARRAY_TYPE_NAME NOT NULL VARCHAR2(30)

ALL_INDEXTYPE_COMMENTS: Comments for user-defined indextypes

iSelfSchooling-SQL> desc ALL_INDEXTYPE_COMMENTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

INDEXTYPE_NAME NOT NULL VARCHAR2(30)

COMMENTS VARCHAR2(4000)

ALL_INDEXTYPE_OPERATORS: All operators available to the user

iSelfSchooling-SQL> desc ALL_INDEXTYPE_OPERATORS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

INDEXTYPE_NAME NOT NULL VARCHAR2(30)

OPERATOR_SCHEMA NOT NULL VARCHAR2(30)

OPERATOR_NAME NOT NULL VARCHAR2(30)

BINDING# NOT NULL NUMBER

ALL_IND_COLUMNS: COLUMNs comprising INDEXes on accessible TABLES

iSelfSchooling-SQL> desc ALL_IND_COLUMNS;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER NOT NULL VARCHAR2(30)

INDEX_NAME NOT NULL VARCHAR2(30)

TABLE_OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

COLUMN_POSITION NOT NULL NUMBER

COLUMN_LENGTH NOT NULL NUMBER

CHAR_LENGTH NUMBER

DESCEND VARCHAR2(4)

ALL_IND_EXPRESSIONS: FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES

iSelfSchooling-SQL> desc ALL_IND_EXPRESSIONS;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER NOT NULL VARCHAR2(30)

INDEX_NAME NOT NULL VARCHAR2(30)

TABLE_OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_EXPRESSION LONG

COLUMN_POSITION NOT NULL NUMBER

ALL_IND_PARTITIONS

iSelfSchooling-SQL> desc ALL_IND_PARTITIONS;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER VARCHAR2(30)

INDEX_NAME VARCHAR2(30)

COMPOSITE VARCHAR2(3)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_COUNT NUMBER

HIGH_VALUE LONG

HIGH_VALUE_LENGTH NUMBER

PARTITION_POSITION NUMBER

STATUS VARCHAR2(8)

TABLESPACE_NAME VARCHAR2(30)

PCT_FREE NUMBER

INI_TRANS NUMBER

MAX_TRANS NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENT NUMBER

MAX_EXTENT NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

LOGGING VARCHAR2(7)

COMPRESSION VARCHAR2(8)

BLEVEL NUMBER

LEAF_BLOCKS NUMBER

DISTINCT_KEYS NUMBER

AVG_LEAF_BLOCKS_PER_KEY NUMBER

AVG_DATA_BLOCKS_PER_KEY NUMBER

CLUSTERING_FACTOR NUMBER

NUM_ROWS NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

BUFFER_POOL VARCHAR2(7)

USER_STATS VARCHAR2(3)

PCT_DIRECT_ACCESS NUMBER

GLOBAL_STATS VARCHAR2(3)

DOMIDX_OPSTATUS VARCHAR2(6)

PARAMETERS VARCHAR2(1000)

ALL_IND_STATISTICS: Optimizer statistics for all indexes on tables accessible to the user

iSelfSchooling-SQL> desc ALL_IND_STATISTICS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

INDEX_NAME VARCHAR2(30)

TABLE_OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

PARTITION_POSITION NUMBER

SUBPARTITION_NAME VARCHAR2(30)

SUBPARTITION_POSITION NUMBER

OBJECT_TYPE VARCHAR2(12)

BLEVEL NUMBER

LEAF_BLOCKS NUMBER

DISTINCT_KEYS NUMBER

AVG_LEAF_BLOCKS_PER_KEY NUMBER

AVG_DATA_BLOCKS_PER_KEY NUMBER

CLUSTERING_FACTOR NUMBER

NUM_ROWS NUMBER

AVG_CACHED_BLOCKS NUMBER

AVG_CACHE_HIT_RATIO NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

STATTYPE_LOCKED VARCHAR2(5)

STALE_STATS VARCHAR2(3)

ALL_IND_SUBPARTITIONS

iSelfSchooling-SQL> desc ALL_IND_SUBPARTITIONS;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER NOT NULL VARCHAR2(30)

INDEX_NAME NOT NULL VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_NAME VARCHAR2(30)

HIGH_VALUE LONG

HIGH_VALUE_LENGTH NOT NULL NUMBER

SUBPARTITION_POSITION NUMBER

STATUS VARCHAR2(8)

TABLESPACE_NAME NOT NULL VARCHAR2(30)

PCT_FREE NOT NULL NUMBER

INI_TRANS NOT NULL NUMBER

MAX_TRANS NOT NULL NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENT NOT NULL NUMBER

MAX_EXTENT NOT NULL NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

LOGGING VARCHAR2(3)

COMPRESSION VARCHAR2(8)

BLEVEL NUMBER

LEAF_BLOCKS NUMBER

DISTINCT_KEYS NUMBER

AVG_LEAF_BLOCKS_PER_KEY NUMBER

AVG_DATA_BLOCKS_PER_KEY NUMBER

CLUSTERING_FACTOR NUMBER

NUM_ROWS NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

BUFFER_POOL VARCHAR2(7)

USER_STATS VARCHAR2(3)

GLOBAL_STATS VARCHAR2(3)

ALL_INTERNAL_TRIGGERS: Description of the internal triggers on the tables accessible to the user

iSelfSchooling-SQL> desc ALL_INTERNAL_TRIGGERS;

Name Null? Type

----------------------------- -------- --------------------

TABLE_NAME VARCHAR2(30)

INTERNAL_TRIGGER_TYPE VARCHAR2(19)

ALL_JAVA_ARGUMENTS: argument information of stored java class accessible to the user

iSelfSchooling-SQL> desc ALL_JAVA_ARGUMENTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

METHOD_INDEX NUMBER

METHOD_NAME VARCHAR2(4000)

ARGUMENT_POSITION NUMBER

ARRAY_DEPTH NUMBER

BASE_TYPE VARCHAR2(7)

ARGUMENT_CLASS VARCHAR2(4000)

ALL_JAVA_CLASSES: class level information of stored java class accessible to the user

iSelfSchooling-SQL> desc ALL_JAVA_CLASSES;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

MAJOR NUMBER

MINOR NUMBER

KIND VARCHAR2(9)

ACCESSIBILITY VARCHAR2(6)

IS_INNER VARCHAR2(3)

IS_ABSTRACT VARCHAR2(3)

IS_FINAL VARCHAR2(3)

IS_DEBUG VARCHAR2(3)

SOURCE VARCHAR2(4000)

SUPER VARCHAR2(4000)

OUTER VARCHAR2(4000)

ALL_JAVA_DERIVATIONS: this view maps java source objects and their derived java class objects and java resource objects for the java class accessible to user

iSelfSchooling-SQL> desc ALL_JAVA_DERIVATIONS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

SOURCE_NAME VARCHAR2(4000)

CLASS_INDEX NUMBER

CLASS_NAME VARCHAR2(4000)

RESOURCE_INDEX NUMBER

RESOURCE_NAME VARCHAR2(4000)

ALL_JAVA_FIELDS: field information of stored java class accessible to user

iSelfSchooling-SQL> desc ALL_JAVA_FIELDS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

FIELD_INDEX NUMBER

FIELD_NAME VARCHAR2(4000)

ACCESSIBILITY VARCHAR2(9)

IS_STATIC VARCHAR2(3)

IS_FINAL VARCHAR2(3)

IS_VOLATILE VARCHAR2(3)

IS_TRANSIENT VARCHAR2(3)

ARRAY_DEPTH NUMBER

BASE_TYPE VARCHAR2(7)

FIELD_CLASS VARCHAR2(4000)

ALL_JAVA_IMPLEMENTS: interfaces implemented by the stored java class accessible to the user

iSelfSchooling-SQL> desc ALL_JAVA_IMPLEMENTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

INTERFACE_INDEX NUMBER

INTERFACE_NAME VARCHAR2(4000)

ALL_JAVA_INNERS: list of inner classes refered by the stored java class accessible to user

iSelfSchooling-SQL> desc ALL_JAVA_INNERS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

INNER_INDEX NUMBER

SIMPLE_NAME VARCHAR2(4000)

FULL_NAME VARCHAR2(4000)

ACCESSIBILITY VARCHAR2(9)

IS_STATIC VARCHAR2(3)

IS_FINAL VARCHAR2(3)

IS_ABSTRACT VARCHAR2(3)

IS_INTERFACE VARCHAR2(3)

ALL_JAVA_LAYOUTS: class layout information about stored java class accessible to the user

iSelfSchooling-SQL> desc ALL_JAVA_LAYOUTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

INTERFACES NUMBER

INNER_CLASSES NUMBER

FIELDS NUMBER

STATIC_FIELDS NUMBER

METHODS NUMBER

STATIC_METHODS NUMBER

NATIVE_METHODS NUMBER

ALL_JAVA_METHODS: method information of stored java class accessible to user

iSelfSchooling-SQL> desc ALL_JAVA_METHODS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

METHOD_INDEX NUMBER

METHOD_NAME VARCHAR2(4000)

ACCESSIBILITY VARCHAR2(9)

IS_STATIC VARCHAR2(3)

IS_FINAL VARCHAR2(3)

IS_SYNCHRONIZED VARCHAR2(3)

IS_NATIVE VARCHAR2(3)

IS_ABSTRACT VARCHAR2(3)

IS_STRICT VARCHAR2(3)

ARGUMENTS NUMBER

THROWS NUMBER

ARRAY_DEPTH NUMBER

BASE_TYPE VARCHAR2(7)

RETURN_CLASS VARCHAR2(4000)

ALL_JAVA_NCOMPS: ncomp related information of all java classes

iSelfSchooling-SQL> desc ALL_JAVA_NCOMPS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

SOURCE VARCHAR2(4000)

INITIALIZER VARCHAR2(4000)

LIBRARYFILE VARCHAR2(4000)

LIBRARY VARCHAR2(4000)

ALL_JAVA_RESOLVERS: resolver of java class owned by user

iSelfSchooling-SQL> desc ALL_JAVA_RESOLVERS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

TERM_INDEX NUMBER

PATTERN VARCHAR2(4000)

SCHEMA VARCHAR2(64)

ALL_JAVA_THROWS: list of exceptions thrown from a method of a class accessible to user

iSelfSchooling-SQL> desc ALL_JAVA_THROWS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

METHOD_INDEX NUMBER

METHOD_NAME VARCHAR2(4000)

EXCEPTION_INDEX NUMBER

EXCEPTION_CLASS VARCHAR2(4000)

ALL_JOBS: Synonym for USER_JOBS

iSelfSchooling-SQL> desc ALL_JOBS;

Name Null? Type

----------------------------- -------- --------------------

JOB NOT NULL NUMBER

LOG_USER NOT NULL VARCHAR2(30)

PRIV_USER NOT NULL VARCHAR2(30)

SCHEMA_USER NOT NULL VARCHAR2(30)

LAST_DATE DATE

LAST_SEC VARCHAR2(8)

THIS_DATE DATE

THIS_SEC VARCHAR2(8)

NEXT_DATE NOT NULL DATE

NEXT_SEC VARCHAR2(8)

TOTAL_TIME NUMBER

BROKEN VARCHAR2(1)

INTERVAL NOT NULL VARCHAR2(200)

FAILURES NUMBER

WHAT VARCHAR2(4000)

NLS_ENV VARCHAR2(4000)

MISC_ENV RAW(32)

INSTANCE NUMBER

ALL_JOIN_IND_COLUMNS: Join Index columns comprising the join conditions

iSelfSchooling-SQL> desc ALL_JOIN_IND_COLUMNS;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER NOT NULL VARCHAR2(30)

INDEX_NAME NOT NULL VARCHAR2(30)

INNER_TABLE_OWNER NOT NULL VARCHAR2(30)

INNER_TABLE_NAME NOT NULL VARCHAR2(30)

INNER_TABLE_COLUMN NOT NULL VARCHAR2(30)

OUTER_TABLE_OWNER NOT NULL VARCHAR2(30)

OUTER_TABLE_NAME NOT NULL VARCHAR2(30)

OUTER_TABLE_COLUMN NOT NULL VARCHAR2(30)

ALL_LIBRARIES: Description of libraries accessible to the user

iSelfSchooling-SQL> desc ALL_LIBRARIES;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

LIBRARY_NAME NOT NULL VARCHAR2(30)

FILE_SPEC VARCHAR2(2000)

DYNAMIC VARCHAR2(1)

STATUS VARCHAR2(7)

ALL_LOBS: Description of LOBs contained in tables accessible to the user

iSelfSchooling-SQL> desc ALL_LOBS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

SEGMENT_NAME VARCHAR2(30)

TABLESPACE_NAME VARCHAR2(30)

INDEX_NAME VARCHAR2(30)

CHUNK NUMBER

PCTVERSION NUMBER

RETENTION NUMBER

FREEPOOLS NUMBER

CACHE VARCHAR2(10)

LOGGING VARCHAR2(7)

IN_ROW VARCHAR2(3)

FORMAT VARCHAR2(15)

PARTITIONED VARCHAR2(3)

ALL_LOB_PARTITIONS

iSelfSchooling-SQL> desc ALL_LOB_PARTITIONS;

Name Null? Type

----------------------------- -------- --------------------

TABLE_OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

LOB_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

LOB_PARTITION_NAME VARCHAR2(30)

LOB_INDPART_NAME VARCHAR2(30)

PARTITION_POSITION NUMBER

COMPOSITE VARCHAR2(3)

CHUNK NUMBER

PCTVERSION NUMBER

CACHE VARCHAR2(10)

IN_ROW VARCHAR2(3)

TABLESPACE_NAME VARCHAR2(30)

INITIAL_EXTENT VARCHAR2(40)

NEXT_EXTENT VARCHAR2(40)

MIN_EXTENTS VARCHAR2(40)

MAX_EXTENTS VARCHAR2(40)

PCT_INCREASE VARCHAR2(40)

FREELISTS VARCHAR2(40)

FREELIST_GROUPS VARCHAR2(40)

LOGGING VARCHAR2(7)

BUFFER_POOL VARCHAR2(7)

ALL_LOB_SUBPARTITIONS

iSelfSchooling-SQL> desc ALL_LOB_SUBPARTITIONS;

Name Null? Type

----------------------------- -------- --------------------

TABLE_OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

LOB_NAME NOT NULL VARCHAR2(30)

LOB_PARTITION_NAME VARCHAR2(30)

SUBPARTITION_NAME VARCHAR2(30)

LOB_SUBPARTITION_NAME VARCHAR2(30)

LOB_INDSUBPART_NAME VARCHAR2(30)

SUBPARTITION_POSITION NUMBER

CHUNK NUMBER

PCTVERSION NOT NULL NUMBER

CACHE VARCHAR2(10)

IN_ROW VARCHAR2(3)

TABLESPACE_NAME NOT NULL VARCHAR2(30)

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENTS NOT NULL NUMBER

MAX_EXTENTS NOT NULL NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

LOGGING VARCHAR2(3)

BUFFER_POOL VARCHAR2(7)

ALL_LOB_TEMPLATES

iSelfSchooling-SQL> desc ALL_LOB_TEMPLATES;

Name Null? Type

----------------------------- -------- --------------------

USER_NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

LOB_COL_NAME VARCHAR2(4000)

SUBPARTITION_NAME NOT NULL VARCHAR2(34)

LOB_SEGMENT_NAME NOT NULL VARCHAR2(34)

TABLESPACE_NAME VARCHAR2(30)

ALL_LOG_GROUPS: Log group definitions on accessible tables

iSelfSchooling-SQL> desc ALL_LOG_GROUPS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

LOG_GROUP_NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

LOG_GROUP_TYPE VARCHAR2(19)

ALWAYS VARCHAR2(11)

GENERATED VARCHAR2(14)

ALL_LOG_GROUP_COLUMNS: Information about columns in log group definitions

iSelfSchooling-SQL> desc ALL_LOG_GROUP_COLUMNS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

LOG_GROUP_NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

POSITION NUMBER

LOGGING_PROPERTY VARCHAR2(6)

ALL_METHOD_PARAMS: Description of method parameters of types accessible to the user

iSelfSchooling-SQL> desc ALL_METHOD_PARAMS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

METHOD_NAME NOT NULL VARCHAR2(30)

METHOD_NO NOT NULL NUMBER

PARAM_NAME NOT NULL VARCHAR2(30)

PARAM_NO NOT NULL NUMBER

PARAM_MODE VARCHAR2(6)

PARAM_TYPE_MOD VARCHAR2(7)

PARAM_TYPE_OWNER VARCHAR2(30)

PARAM_TYPE_NAME VARCHAR2(30)

CHARACTER_SET_NAME VARCHAR2(44)

ALL_METHOD_RESULTS: Description of method results of types accessible to the user

iSelfSchooling-SQL> desc ALL_METHOD_RESULTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

METHOD_NAME NOT NULL VARCHAR2(30)

METHOD_NO NOT NULL NUMBER

RESULT_TYPE_MOD VARCHAR2(7)

RESULT_TYPE_OWNER VARCHAR2(30)

RESULT_TYPE_NAME VARCHAR2(30)

CHARACTER_SET_NAME VARCHAR2(44)

ALL_MVIEWS: All materialized views in the database

iSelfSchooling-SQL> desc ALL_MVIEWS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

MVIEW_NAME NOT NULL VARCHAR2(30)

CONTAINER_NAME NOT NULL VARCHAR2(30)

QUERY LONG

QUERY_LEN NUMBER(38)

UPDATABLE VARCHAR2(1)

UPDATE_LOG VARCHAR2(30)

MASTER_ROLLBACK_SEG VARCHAR2(30)

MASTER_LINK VARCHAR2(128)

REWRITE_ENABLED VARCHAR2(1)

REWRITE_CAPABILITY VARCHAR2(9)

REFRESH_MODE VARCHAR2(6)

REFRESH_METHOD VARCHAR2(8)

BUILD_MODE VARCHAR2(9)

FAST_REFRESHABLE VARCHAR2(18)

LAST_REFRESH_TYPE VARCHAR2(8)

LAST_REFRESH_DATE DATE

STALENESS VARCHAR2(19)

AFTER_FAST_REFRESH VARCHAR2(19)

UNKNOWN_PREBUILT VARCHAR2(1)

UNKNOWN_PLSQL_FUNC VARCHAR2(1)

UNKNOWN_EXTERNAL_TABLE VARCHAR2(1)

UNKNOWN_CONSIDER_FRESH VARCHAR2(1)

UNKNOWN_IMPORT VARCHAR2(1)

UNKNOWN_TRUSTED_FD VARCHAR2(1)

COMPILE_STATE VARCHAR2(19)

USE_NO_INDEX VARCHAR2(1)

STALE_SINCE DATE