iSelfSchooling.com - Since 1999 References | Job Openings

Home | Search more | Oracle Syntax | Computer Institute | (Login or Register to access to VIDEOS)

Copyright & User Agreement

Suggestions | Email2aFriend | Homepage us! | Bookmark

Services

ShareUrNotes

...

Acknowledgement

Who is who

University Directory

Links...

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

Oracle Dictionary Tables

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

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

DBA_INDEXES: Description for all indexes in the database

iSelfSchooling-SQL> desc DBA_INDEXES;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

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)

DBA_INDEXTYPES: All index types

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

DBA_INDEXTYPE_ARRAYTYPES: All array types specified by the indextype

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

DBA_INDEXTYPE_COMMENTS: Comments for user-defined indextypes

iSelfSchooling-SQL> desc DBA_INDEXTYPE_COMMENTS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

INDEXTYPE_NAME NOT NULL VARCHAR2(30)

COMMENTS VARCHAR2(4000)

DBA_INDEXTYPE_OPERATORS: All indextype operators

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

DBA_IND_COLUMNS: COLUMNs comprising INDEXes on all TABLEs and CLUSTERs

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

DBA_IND_EXPRESSIONS: FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS

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

DBA_IND_PARTITIONS

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

DBA_IND_STATISTICS: Optimizer statistics for all indexes in the database

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

DBA_IND_SUBPARTITIONS

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

DBA_INTERNAL_TRIGGERS: Description of the internal triggers on all tables in the database

iSelfSchooling-SQL> desc DBA_INTERNAL_TRIGGERS;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

OWNER_NAME VARCHAR2(30)

INTERNAL_TRIGGER_TYPE VARCHAR2(19)

DBA_JAVA_ARGUMENTS: argument information of all stored java class

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

DBA_JAVA_CLASSES: class level information of all stored java classes

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

DBA_JAVA_DERIVATIONS: this view maps java source objects and their derived java class objects and java resource objects for all java classes

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

DBA_JAVA_FIELDS: field information of all stored java class

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

DBA_JAVA_IMPLEMENTS: interfaces implemented by the stored java class

iSelfSchooling-SQL> desc DBA_JAVA_IMPLEMENTS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

INTERFACE_INDEX NUMBER

INTERFACE_NAME VARCHAR2(4000)

DBA_JAVA_INNERS: list of inner classes refered by the stored java class

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

DBA_JAVA_LAYOUTS: class layout information about stored java class

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

DBA_JAVA_METHODS: method information of all stored java class

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

DBA_JAVA_NCOMPS

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

DBA_JAVA_POLICY: java security Permissions for all users

iSelfSchooling-SQL> desc DBA_JAVA_POLICY;

Name Null? Type

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

KIND VARCHAR2(8)

GRANTEE 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

DBA_JAVA_RESOLVERS: resolver of java class owned by user

iSelfSchooling-SQL> desc DBA_JAVA_RESOLVERS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

NAME VARCHAR2(4000)

TERM_INDEX NUMBER

PATTERN VARCHAR2(4000)

SCHEMA VARCHAR2(64)

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

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

DBA_JOBS: All jobs in the database

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

DBA_JOBS_RUNNING: All jobs in the database which are currently running, join v$lock and job$

iSelfSchooling-SQL> desc DBA_JOBS_RUNNING;

Name Null? Type

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

SID NUMBER

JOB NUMBER

FAILURES NUMBER

LAST_DATE DATE

LAST_SEC VARCHAR2(8)

THIS_DATE DATE

THIS_SEC VARCHAR2(8)

INSTANCE NUMBER

DBA_JOIN_IND_COLUMNS: Join Index columns comprising the join conditions

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

DBA_KGLLOCK

iSelfSchooling-SQL> desc DBA_KGLLOCK;

Name Null? Type

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

KGLLKUSE RAW(8)

KGLLKHDL RAW(8)

KGLLKMOD NUMBER

KGLLKREQ NUMBER

KGLLKTYPE VARCHAR2(4)

DBA_LIBRARIES: Description of all libraries in the database

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

DBA_LMT_FREE_SPACE: Free extents in all locally managed tablespaces

iSelfSchooling-SQL> desc DBA_LMT_FREE_SPACE;

Name Null? Type

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

TABLESPACE_ID NUMBER

FILE_ID NUMBER

BLOCK_ID NUMBER

BLOCKS NUMBER

DBA_LMT_USED_EXTENTS: All extents in the locally managed tablespaces

iSelfSchooling-SQL> desc DBA_LMT_USED_EXTENTS;

Name Null? Type

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

SEGMENT_FILEID NUMBER

SEGMENT_BLOCK NUMBER

TABLESPACE_ID NUMBER

EXTENT_ID NUMBER

FILEID NUMBER

BLOCK NUMBER

LENGTH NUMBER

DBA_LOBS: Description of LOBs contained in all tables

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

DBA_LOB_PARTITIONS

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

DBA_LOB_SUBPARTITIONS

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

DBA_LOB_TEMPLATES

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