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

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. 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

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)

 

 

 

Google
 
Web web site