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

ADV... | AUD... | FIL... | LOB... | PAR... | REP... | SEQ... | TAB...

USER_FILE_GROUP_FILES: Details about file group files

iSelfSchooling-SQL> desc USER_FILE_GROUP_FILES;

Name Null? Type

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

FILE_GROUP_NAME NOT NULL VARCHAR2(30)

VERSION_NAME NOT NULL VARCHAR2(30)

VERSION NOT NULL NUMBER

FILE_NAME NOT NULL VARCHAR2(512)

FILE_DIRECTORY NOT NULL VARCHAR2(30)

FILE_TYPE VARCHAR2(32)

FILE_SIZE NUMBER

FILE_BLOCK_SIZE NUMBER

COMMENTS VARCHAR2(4000)

USER_FILE_GROUP_TABLES: Details about the tables in the file group repository

iSelfSchooling-SQL> desc USER_FILE_GROUP_TABLES;

Name Null? Type

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

FILE_GROUP_NAME NOT NULL VARCHAR2(30)

VERSION_NAME NOT NULL VARCHAR2(30)

VERSION NOT NULL NUMBER

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

TABLESPACE_NAME VARCHAR2(30)

SCN NUMBER

USER_FILE_GROUP_TABLESPACES: Details about the transportable tablespaces in the file group repository

iSelfSchooling-SQL> desc USER_FILE_GROUP_TABLESPACES;

Name Null? Type

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

FILE_GROUP_NAME NOT NULL VARCHAR2(30)

VERSION_NAME NOT NULL VARCHAR2(30)

VERSION NOT NULL NUMBER

TABLESPACE_NAME NOT NULL VARCHAR2(30)

USER_FILE_GROUP_VERSIONS: Details about file group versions

iSelfSchooling-SQL> desc USER_FILE_GROUP_VERSIONS;

Name Null? Type

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

FILE_GROUP_NAME NOT NULL VARCHAR2(30)

VERSION_NAME NOT NULL VARCHAR2(30)

VERSION NOT NULL NUMBER

CREATOR NOT NULL VARCHAR2(30)

CREATED NOT NULL TIMESTAMP(6)

COMMENTS VARCHAR2(4000)

DEFAULT_DIRECTORY VARCHAR2(30)

USER_FREE_SPACE: Free extents in tablespaces accessible to the user

iSelfSchooling-SQL> desc USER_FREE_SPACE;

Name Null? Type

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

TABLESPACE_NAME VARCHAR2(30)

FILE_ID NUMBER

BLOCK_ID NUMBER

BYTES NUMBER

BLOCKS NUMBER

RELATIVE_FNO NUMBER

USER_HISTOGRAMS: Synonym for USER_TAB_HISTOGRAMS

iSelfSchooling-SQL> desc USER_HISTOGRAMS;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

ENDPOINT_NUMBER NUMBER

ENDPOINT_VALUE NUMBER

ENDPOINT_ACTUAL_VALUE VARCHAR2(1000)

USER_INDEXES: Description of the user's own indexes

iSelfSchooling-SQL> desc USER_INDEXES;

Name Null? Type

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

INDEX_NAME NOT NULL VARCHAR2(30)

INDEX_TYPE VARCHAR2(27)

TABLE_OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

TABLE_TYPE VARCHAR2(11)

UNIQUENESS VARCHAR2(9)

COMPRESSION VARCHAR2(8)

PREFIX_LENGTH NUMBER

TABLESPACE_NAME VARCHAR2(30)

INI_TRANS NUMBER

MAX_TRANS NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENTS NUMBER

MAX_EXTENTS NUMBER

PCT_INCREASE NUMBER

PCT_THRESHOLD NUMBER

INCLUDE_COLUMN NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

PCT_FREE NUMBER

LOGGING VARCHAR2(3)

BLEVEL NUMBER

LEAF_BLOCKS NUMBER

DISTINCT_KEYS NUMBER

AVG_LEAF_BLOCKS_PER_KEY NUMBER

AVG_DATA_BLOCKS_PER_KEY NUMBER

CLUSTERING_FACTOR NUMBER

STATUS VARCHAR2(8)

NUM_ROWS NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

DEGREE VARCHAR2(40)

INSTANCES VARCHAR2(40)

PARTITIONED VARCHAR2(3)

TEMPORARY VARCHAR2(1)

GENERATED VARCHAR2(1)

SECONDARY VARCHAR2(1)

BUFFER_POOL VARCHAR2(7)

USER_STATS VARCHAR2(3)

DURATION VARCHAR2(15)

PCT_DIRECT_ACCESS NUMBER

ITYP_OWNER VARCHAR2(30)

ITYP_NAME VARCHAR2(30)

PARAMETERS VARCHAR2(1000)

GLOBAL_STATS VARCHAR2(3)

DOMIDX_STATUS VARCHAR2(12)

DOMIDX_OPSTATUS VARCHAR2(6)

FUNCIDX_STATUS VARCHAR2(8)

JOIN_INDEX VARCHAR2(3)

IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)

DROPPED VARCHAR2(3)

USER_INDEXTYPES: All user indextypes

iSelfSchooling-SQL> desc USER_INDEXTYPES;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

INDEXTYPE_NAME NOT NULL VARCHAR2(30)

IMPLEMENTATION_SCHEMA NOT NULL VARCHAR2(30)

IMPLEMENTATION_NAME NOT NULL VARCHAR2(30)

INTERFACE_VERSION NUMBER

IMPLEMENTATION_VERSION NOT NULL NUMBER

NUMBER_OF_OPERATORS NUMBER

PARTITIONING VARCHAR2(10)

ARRAY_DML VARCHAR2(3)

USER_INDEXTYPE_ARRAYTYPES: All array types specified by the indextype

iSelfSchooling-SQL> desc USER_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)

USER_INDEXTYPE_COMMENTS: Comments for user-defined indextypes

iSelfSchooling-SQL> desc USER_INDEXTYPE_COMMENTS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

INDEXTYPE_NAME NOT NULL VARCHAR2(30)

COMMENTS VARCHAR2(4000)

USER_INDEXTYPE_OPERATORS: All user indextype operators

iSelfSchooling-SQL> desc USER_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

USER_IND_COLUMNS: COLUMNs comprising user's INDEXes and INDEXes on user's TABLES

iSelfSchooling-SQL> desc USER_IND_COLUMNS;

Name Null? Type

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

INDEX_NAME VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

COLUMN_POSITION NUMBER

COLUMN_LENGTH NUMBER

CHAR_LENGTH NUMBER

DESCEND VARCHAR2(4)

USER_IND_EXPRESSIONS: Functional index expressions in user's indexes and indexes on user's tables

iSelfSchooling-SQL> desc USER_IND_EXPRESSIONS;

Name Null? Type

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

INDEX_NAME VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_EXPRESSION LONG

COLUMN_POSITION NUMBER

USER_IND_PARTITIONS

iSelfSchooling-SQL> desc USER_IND_PARTITIONS;

Name Null? Type

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

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)

USER_IND_STATISTICS: Optimizer statistics for user's own indexes

iSelfSchooling-SQL> desc USER_IND_STATISTICS;

Name Null? Type

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

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)

USER_IND_SUBPARTITIONS

iSelfSchooling-SQL> desc USER_IND_SUBPARTITIONS;

Name Null? Type

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

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)

USER_INTERNAL_TRIGGERS: Description of the internal triggers on the user's own tables

iSelfSchooling-SQL> desc USER_INTERNAL_TRIGGERS;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

INTERNAL_TRIGGER_TYPE VARCHAR2(19)

USER_JAVA_ARGUMENTS: argument information of stored java class owned by the user

iSelfSchooling-SQL> desc USER_JAVA_ARGUMENTS;

Name Null? Type

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

NAME VARCHAR2(4000)

METHOD_INDEX NUMBER

METHOD_NAME VARCHAR2(4000)

ARGUMENT_POSITION NUMBER

ARRAY_DEPTH NUMBER

BASE_TYPE VARCHAR2(7)

ARGUMENT_CLASS VARCHAR2(4000)

USER_JAVA_CLASSES: class level information of stored java class owned by the user

iSelfSchooling-SQL> desc USER_JAVA_CLASSES;

Name Null? Type

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

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)

USER_JAVA_DERIVATIONS: this view maps java source objects and their derived java class objects and java resource objects for the java class owned by user

iSelfSchooling-SQL> desc USER_JAVA_DERIVATIONS;

Name Null? Type

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

SOURCE_NAME VARCHAR2(4000)

CLASS_INDEX NUMBER

CLASS_NAME VARCHAR2(4000)

RESOURCE_INDEX NUMBER

RESOURCE_NAME VARCHAR2(4000)

USER_JAVA_FIELDS: field information of stored java class owned by the user

iSelfSchooling-SQL> desc USER_JAVA_FIELDS;

Name Null? Type

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

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)

USER_JAVA_IMPLEMENTS: interfaces implemented by the stored java class owned by user

iSelfSchooling-SQL> desc USER_JAVA_IMPLEMENTS;

Name Null? Type

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

NAME VARCHAR2(4000)

INTERFACE_INDEX NUMBER

INTERFACE_NAME VARCHAR2(4000)

USER_JAVA_INNERS: list of inner classes referred by the stored java class owned by user

iSelfSchooling-SQL> desc USER_JAVA_INNERS;

Name Null? Type

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

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)

USER_JAVA_LAYOUTS: class layout information about stored java class owned by the user

iSelfSchooling-SQL> desc USER_JAVA_LAYOUTS;

Name Null? Type

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

NAME VARCHAR2(4000)

INTERFACES NUMBER

INNER_CLASSES NUMBER

FIELDS NUMBER

STATIC_FIELDS NUMBER

METHODS NUMBER

STATIC_METHODS NUMBER

NATIVE_METHODS NUMBER

USER_JAVA_METHODS: method information of stored java class owned by the user

iSelfSchooling-SQL> desc USER_JAVA_METHODS;

Name Null? Type

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

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)

USER_JAVA_NCOMPS: ncomp related information of java classes owned by user

iSelfSchooling-SQL> desc USER_JAVA_NCOMPS;

Name Null? Type

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

NAME VARCHAR2(4000)

SOURCE VARCHAR2(4000)

INITIALIZER VARCHAR2(4000)

LIBRARYFILE VARCHAR2(4000)

LIBRARY VARCHAR2(4000)

USER_JAVA_POLICY: java security Permissions for current user

iSelfSchooling-SQL> desc USER_JAVA_POLICY;

Name Null? Type

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

KIND VARCHAR2(8)

GRANTEE_NAME NOT NULL VARCHAR2(30)

TYPE_SCHEMA NOT NULL VARCHAR2(30)

TYPE_NAME VARCHAR2(4000)

NAME VARCHAR2(4000)

ACTION VARCHAR2(4000)

ENABLED VARCHAR2(8)

SEQ NUMBER

USER_JAVA_RESOLVERS: resolver of java class owned by user

iSelfSchooling-SQL> desc USER_JAVA_RESOLVERS;

Name Null? Type

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

NAME VARCHAR2(4000)

TERM_INDEX NUMBER

PATTERN VARCHAR2(4000)

SCHEMA VARCHAR2(64)

USER_JAVA_THROWS: list of exceptions thrown from a method of a class owned by user

iSelfSchooling-SQL> desc USER_JAVA_THROWS;

Name Null? Type

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

NAME VARCHAR2(4000)

METHOD_INDEX NUMBER

METHOD_NAME VARCHAR2(4000)

EXCEPTION_INDEX NUMBER

EXCEPTION_CLASS VARCHAR2(4000)

USER_JOBS: All jobs owned by this user

iSelfSchooling-SQL> desc USER_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

USER_JOIN_IND_COLUMNS: Join Index columns comprising the join conditions

iSelfSchooling-SQL> desc USER_JOIN_IND_COLUMNS;

Name Null? Type

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

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)

USER_LIBRARIES: Description of the user's own libraries

iSelfSchooling-SQL> desc USER_LIBRARIES;

Name Null? Type

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

LIBRARY_NAME NOT NULL VARCHAR2(30)

FILE_SPEC VARCHAR2(2000)

DYNAMIC VARCHAR2(1)

STATUS VARCHAR2(7)

USER_LOBS: Description of the user's own LOBs contained in the user's own tables

iSelfSchooling-SQL> desc USER_LOBS;

Name Null? Type

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

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)

USER_LOB_PARTITIONS

iSelfSchooling-SQL> desc USER_LOB_PARTITIONS;

Name Null? Type

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

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)