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_LOB_SUBPARTITIONS

 

iSelfSchooling-SQL> desc USER_LOB_SUBPARTITIONS;

 Name                          Null?    Type

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

 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)

 

USER_LOB_TEMPLATES

 

iSelfSchooling-SQL> desc USER_LOB_TEMPLATES;

 Name                          Null?    Type

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

 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)

 

USER_LOG_GROUPS: Log group definitions on user's own tables

 

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

 

USER_LOG_GROUP_COLUMNS: Information about columns in log group definitions

 

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

 

USER_METHOD_PARAMS: Description of method parameters of the user's own types

 

iSelfSchooling-SQL> desc USER_METHOD_PARAMS;

 Name                          Null?    Type

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

 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)

 

USER_METHOD_RESULTS: Description of method results of the user's own types

 

iSelfSchooling-SQL> desc USER_METHOD_RESULTS;

 Name                          Null?    Type

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

 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)

 

USER_MVIEWS: All materialized views in the database

 

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

 

USER_MVIEW_AGGREGATES: Description of the materialized view aggregates created by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_AGGREGATES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 POSITION_IN_SELECT            NOT NULL NUMBER

 CONTAINER_COLUMN              NOT NULL VARCHAR2(30)

 AGG_FUNCTION                           VARCHAR2(8)

 DISTINCTFLAG                           VARCHAR2(1)

 MEASURE                                LONG

 

USER_MVIEW_ANALYSIS: Description of the materialized views created by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_ANALYSIS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 MVIEW_TABLE_OWNER             NOT NULL VARCHAR2(30)

 CONTAINER_NAME                         VARCHAR2(30)

 LAST_REFRESH_SCN                       NUMBER

 LAST_REFRESH_DATE                      DATE

 REFRESH_METHOD                         VARCHAR2(8)

 SUMMARY                                VARCHAR2(1)

 FULLREFRESHTIM                         NUMBER

 INCREFRESHTIM                          NUMBER

 CONTAINS_VIEWS                         VARCHAR2(1)

 UNUSABLE                               VARCHAR2(1)

 RESTRICTED_SYNTAX                      VARCHAR2(1)

 INC_REFRESHABLE                        VARCHAR2(1)

 KNOWN_STALE                            VARCHAR2(1)

 INVALID                                VARCHAR2(1)

 REWRITE_ENABLED                        VARCHAR2(1)

 QUERY_LEN                              NUMBER

 QUERY                                  LONG

 REVISION                      NOT NULL NUMBER

 

USER_MVIEW_COMMENTS: Comments on materialized views owned by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_COMMENTS;

 Name                          Null?    Type

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

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 COMMENTS                               VARCHAR2(4000)

 

USER_MVIEW_DETAIL_RELATIONS: Description of the materialized view detail tables of the materialized views created by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_DETAIL_RELATIONS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 DETAILOBJ_OWNER               NOT NULL VARCHAR2(30)

 DETAILOBJ_NAME                NOT NULL VARCHAR2(30)

 DETAILOBJ_TYPE                         VARCHAR2(9)

 DETAILOBJ_ALIAS                        VARCHAR2(30)

 

USER_MVIEW_JOINS: Description of a join between two columns in the WHERE clause of a materialized view created by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_JOINS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 DETAILOBJ1_OWNER              NOT NULL VARCHAR2(30)

 DETAILOBJ1_RELATION           NOT NULL VARCHAR2(30)

 DETAILOBJ1_COLUMN             NOT NULL VARCHAR2(30)

 OPERATOR                               CHAR(1)

 OPERATOR_TYPE                          VARCHAR2(1)

 DETAILOBJ2_OWNER              NOT NULL VARCHAR2(30)

 DETAILOBJ2_RELATION           NOT NULL VARCHAR2(30)

 DETAILOBJ2_COLUMN             NOT NULL VARCHAR2(30)

 

USER_MVIEW_KEYS: Description of the columns that appear in the GROUP BY list of a materialized view created by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_KEYS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 POSITION_IN_SELECT            NOT NULL NUMBER

 CONTAINER_COLUMN              NOT NULL VARCHAR2(30)

 DETAILOBJ_OWNER               NOT NULL VARCHAR2(30)

 DETAILOBJ_NAME                NOT NULL VARCHAR2(30)

 DETAILOBJ_ALIAS                        VARCHAR2(30)

 DETAILOBJ_TYPE                         VARCHAR2(5)

 DETAILOBJ_COLUMN              NOT NULL VARCHAR2(30)

 

USER_MVIEW_LOGS: All materialized view logs owned by the user

 

iSelfSchooling-SQL> desc USER_MVIEW_LOGS;

 Name                          Null?    Type

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

 LOG_OWNER                              VARCHAR2(30)

 MASTER                                 VARCHAR2(30)

 LOG_TABLE                              VARCHAR2(30)

 LOG_TRIGGER                            VARCHAR2(30)

 ROWIDS                                 VARCHAR2(3)

 PRIMARY_KEY                            VARCHAR2(3)

 OBJECT_ID                              VARCHAR2(3)

 FILTER_COLUMNS                         VARCHAR2(3)

 SEQUENCE                               VARCHAR2(3)

 INCLUDE_NEW_VALUES                     VARCHAR2(3)

 

USER_MVIEW_REFRESH_TIMES: Materialized views and their last refresh times for each master table that the user can look at

 

iSelfSchooling-SQL> desc USER_MVIEW_REFRESH_TIMES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 MASTER_OWNER                           VARCHAR2(30)

 MASTER                                 VARCHAR2(30)

 LAST_REFRESH                           DATE

 

USER_NESTED_TABLES: Description of nested tables contained in the user's own tables

 

iSelfSchooling-SQL> desc USER_NESTED_TABLES;

 Name                          Null?    Type

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

 TABLE_NAME                             VARCHAR2(30)

 TABLE_TYPE_OWNER                       VARCHAR2(30)

 TABLE_TYPE_NAME                        VARCHAR2(30)

 PARENT_TABLE_NAME                      VARCHAR2(30)

 PARENT_TABLE_COLUMN                    VARCHAR2(4000)

 STORAGE_SPEC                           VARCHAR2(30)

 RETURN_TYPE                            VARCHAR2(20)

 ELEMENT_SUBSTITUTABLE                  VARCHAR2(25)

 

USER_NESTED_TABLE_COLS: Columns of nested tables

 

iSelfSchooling-SQL> desc USER_NESTED_TABLE_COLS;

 Name                          Null?    Type

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

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 DATA_TYPE                              VARCHAR2(106)

 DATA_TYPE_MOD                          VARCHAR2(3)

 DATA_TYPE_OWNER                        VARCHAR2(30)

 DATA_LENGTH                   NOT NULL NUMBER

 DATA_PRECISION                         NUMBER

 DATA_SCALE                             NUMBER

 NULLABLE                               VARCHAR2(1)

 COLUMN_ID                              NUMBER

 DEFAULT_LENGTH                         NUMBER

 DATA_DEFAULT                           LONG

 NUM_DISTINCT                           NUMBER

 LOW_VALUE                              RAW(32)

 HIGH_VALUE                             RAW(32)

 DENSITY                                NUMBER

 NUM_NULLS                              NUMBER

 NUM_BUCKETS                            NUMBER

 LAST_ANALYZED                          DATE

 SAMPLE_SIZE                            NUMBER

 CHARACTER_SET_NAME                     VARCHAR2(44)

 CHAR_COL_DECL_LENGTH                   NUMBER

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 AVG_COL_LEN                            NUMBER

 CHAR_LENGTH                            NUMBER

 CHAR_USED                              VARCHAR2(1)

 V80_FMT_IMAGE                          VARCHAR2(3)

 DATA_UPGRADED                          VARCHAR2(3)

 HIDDEN_COLUMN                          VARCHAR2(3)

 VIRTUAL_COLUMN                         VARCHAR2(3)

 SEGMENT_COLUMN_ID                      NUMBER

 INTERNAL_COLUMN_ID            NOT NULL NUMBER

 HISTOGRAM                              VARCHAR2(15)

 QUALIFIED_COL_NAME                     VARCHAR2(4000)

 

USER_OBJECTS: Objects owned by the user

 

iSelfSchooling-SQL> desc USER_OBJECTS;

 Name                          Null?    Type

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

 OBJECT_NAME                            VARCHAR2(128)

 SUBOBJECT_NAME                         VARCHAR2(30)

 OBJECT_ID                              NUMBER

 DATA_OBJECT_ID                         NUMBER

 OBJECT_TYPE                            VARCHAR2(19)

 CREATED                                DATE

 LAST_DDL_TIME                          DATE

 TIMESTAMP                              VARCHAR2(19)

 STATUS                                 VARCHAR2(7)

 TEMPORARY                              VARCHAR2(1)

 GENERATED                              VARCHAR2(1)

 SECONDARY                              VARCHAR2(1)

 

USER_OBJECT_SIZE: Sizes, in bytes, of various pl/sql objects

 

iSelfSchooling-SQL> desc USER_OBJECT_SIZE;

 Name                          Null?    Type

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

 NAME                          NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(13)

 SOURCE_SIZE                            NUMBER

 PARSED_SIZE                            NUMBER

 CODE_SIZE                              NUMBER

 ERROR_SIZE                             NUMBER

 

USER_OBJECT_TABLES: Description of the user's own object tables

 

iSelfSchooling-SQL> desc USER_OBJECT_TABLES;

 Name                          Null?    Type

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

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TABLESPACE_NAME                        VARCHAR2(30)

 CLUSTER_NAME                           VARCHAR2(30)

 IOT_NAME                               VARCHAR2(30)

 STATUS                                 VARCHAR2(8)

 PCT_FREE                               NUMBER

 PCT_USED                               NUMBER

 INI_TRANS                              NUMBER

 MAX_TRANS                              NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                            NUMBER

 MAX_EXTENTS                            NUMBER

 PCT_INCREASE                           NUMBER

 FREELISTS                              NUMBER

 FREELIST_GROUPS                        NUMBER

 LOGGING                                VARCHAR2(3)

 BACKED_UP                              VARCHAR2(1)

 NUM_ROWS                               NUMBER

 BLOCKS                                 NUMBER

 EMPTY_BLOCKS                           NUMBER

 AVG_SPACE                              NUMBER

 CHAIN_CNT                              NUMBER

 AVG_ROW_LEN                            NUMBER

 AVG_SPACE_FREELIST_BLOCKS              NUMBER

 NUM_FREELIST_BLOCKS                    NUMBER

 DEGREE                                 VARCHAR2(10)

 INSTANCES                              VARCHAR2(10)

 CACHE                                  VARCHAR2(5)

 TABLE_LOCK                             VARCHAR2(8)

 SAMPLE_SIZE                            NUMBER

 LAST_ANALYZED                          DATE

 PARTITIONED                            VARCHAR2(3)

 IOT_TYPE                               VARCHAR2(12)

 OBJECT_ID_TYPE                         VARCHAR2(16)

 TABLE_TYPE_OWNER                       VARCHAR2(30)

 TABLE_TYPE                             VARCHAR2(30)

 TEMPORARY                              VARCHAR2(1)

 SECONDARY                              VARCHAR2(1)

 NESTED                                 VARCHAR2(3)

 BUFFER_POOL                            VARCHAR2(7)

 ROW_MOVEMENT                           VARCHAR2(8)

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 DURATION                               VARCHAR2(15)

 SKIP_CORRUPT                           VARCHAR2(8)

 MONITORING                             VARCHAR2(3)

 CLUSTER_OWNER                          VARCHAR2(30)

 DEPENDENCIES                           VARCHAR2(8)

 COMPRESSION                            VARCHAR2(8)

 DROPPED                                VARCHAR2(3)

 

USER_OBJ_AUDIT_OPTS: Auditing options for user's own tables and views with atleast one option set

 

iSelfSchooling-SQL> desc USER_OBJ_AUDIT_OPTS;

 Name                          Null?    Type

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

 OBJECT_NAME                            VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(17)

 ALT                                    VARCHAR2(3)

 AUD                                    VARCHAR2(3)

 COM                                    VARCHAR2(3)

 DEL                                    VARCHAR2(3)

 GRA                                    VARCHAR2(3)

 IND                                    VARCHAR2(3)

 INS                                    VARCHAR2(3)

 LOC                                    VARCHAR2(3)

 REN                                    VARCHAR2(3)

 SEL                                    VARCHAR2(3)

 UPD                                    VARCHAR2(3)

 REF                                    CHAR(3)

 EXE                                    VARCHAR2(3)

 CRE                                    VARCHAR2(3)

 REA                                    VARCHAR2(3)

 WRI                                    VARCHAR2(3)

 FBK                                    VARCHAR2(3)

 

USER_OBJ_COLATTRS: Description of object columns and attributes contained in tables owned by the user

 

iSelfSchooling-SQL> desc USER_OBJ_COLATTRS;

 Name                          Null?    Type

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

 TABLE_NAME                             VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 SUBSTITUTABLE                          VARCHAR2(15)

 

USER_OPANCILLARY: All ancillary operators defined by user

 

iSelfSchooling-SQL> desc USER_OPANCILLARY;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 BINDING#                      NOT NULL NUMBER

 PRIMOP_OWNER                  NOT NULL VARCHAR2(30)

 PRIMOP_NAME                   NOT NULL VARCHAR2(30)

 PRIMOP_BIND#                  NOT NULL NUMBER

 

USER_OPARGUMENTS: All operator arguments of operators defined by user

 

iSelfSchooling-SQL> desc USER_OPARGUMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 BINDING#                      NOT NULL NUMBER

 POSITION                      NOT NULL NUMBER

 ARGUMENT_TYPE                          VARCHAR2(61)

 

USER_OPBINDINGS: All binding functions or methods on operators defined by the user

 

iSelfSchooling-SQL> desc USER_OPBINDINGS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 BINDING#                      NOT NULL NUMBER

 FUNCTION_NAME                          VARCHAR2(92)

 RETURN_SCHEMA                          VARCHAR2(30)

 RETURN_TYPE                            VARCHAR2(30)

 IMPLEMENTATION_TYPE_SCHEMA             VARCHAR2(30)

 IMPLEMENTATION_TYPE                    VARCHAR2(30)

 PROPERTY                               VARCHAR2(43)

 

USER_OPERATORS: All user operators

 

iSelfSchooling-SQL> desc USER_OPERATORS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 NUMBER_OF_BINDS               NOT NULL NUMBER

 

USER_OPERATOR_COMMENTS: Comments for user-defined operators

 

iSelfSchooling-SQL> desc USER_OPERATOR_COMMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 COMMENTS                               VARCHAR2(4000)

 

USER_OUTLINES: Stored outlines owned by the user

 

iSelfSchooling-SQL> desc USER_OUTLINES;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 CATEGORY                               VARCHAR2(30)

 USED                                   VARCHAR2(6)

 TIMESTAMP                              DATE

 VERSION                                VARCHAR2(64)

 SQL_TEXT                               LONG

 SIGNATURE                              RAW(16)

 COMPATIBLE                             VARCHAR2(12)

 ENABLED                                VARCHAR2(8)

 FORMAT                                 VARCHAR2(6)

 

USER_OUTLINE_HINTS: Hints stored in outlines owned by the user

 

iSelfSchooling-SQL> desc USER_OUTLINE_HINTS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 NODE                                   NUMBER

 STAGE                                  NUMBER

 JOIN_POS                               NUMBER

 HINT                                   CLOB

 

USER_PARTIAL_DROP_TABS: User tables with unused columns

 

iSelfSchooling-SQL> desc USER_PARTIAL_DROP_TABS;

 Name                          Null?    Type

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

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 

USER_PART_COL_STATISTICS

 

iSelfSchooling-SQL> desc USER_PART_COL_STATISTICS;

 Name                          Null?    Type

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

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 PARTITION_NAME                         VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 NUM_DISTINCT                           NUMBER

 LOW_VALUE                              RAW(32)

 HIGH_VALUE                             RAW(32)

 DENSITY                                NUMBER

 NUM_NULLS                              NUMBER

 NUM_BUCKETS                            NUMBER

 SAMPLE_SIZE                            NUMBER

 LAST_ANALYZED                          DATE

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 AVG_COL_LEN                            NUMBER

 HISTOGRAM                              VARCHAR2(15)

 

USER_PART_HISTOGRAMS

 

iSelfSchooling-SQL> desc USER_PART_HISTOGRAMS;

 Name                          Null?    Type

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

 TABLE_NAME                             VARCHAR2(30)

 PARTITION_NAME                         VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 BUCKET_NUMBER                          NUMBER

 ENDPOINT_VALUE                         NUMBER

 ENDPOINT_ACTUAL_VALUE                  VARCHAR2(1000)

 

USER_PART_INDEXES

 

iSelfSchooling-SQL> desc USER_PART_INDEXES;

 Name                          Null?    Type

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

 INDEX_NAME                    NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 PARTITIONING_TYPE                      VARCHAR2(7)

 SUBPARTITIONING_TYPE                   VARCHAR2(7)

 PARTITION_COUNT               NOT NULL NUMBER

 DEF_SUBPARTITION_COUNT                 NUMBER

 PARTITIONING_KEY_COUNT        NOT NULL NUMBER

 SUBPARTITIONING_KEY_COUNT              NUMBER

 LOCALITY                               VARCHAR2(6)

 ALIGNMENT                              VARCHAR2(12)

 DEF_TABLESPACE_NAME                    VARCHAR2(30)

 DEF_PCT_FREE                  NOT NULL NUMBER

 DEF_INI_TRANS                 NOT NULL NUMBER

 DEF_MAX_TRANS                 NOT NULL NUMBER

 DEF_INITIAL_EXTENT                     VARCHAR2(40)

 DEF_NEXT_EXTENT                        VARCHAR2(40)

 DEF_MIN_EXTENTS                        VARCHAR2(40)

 DEF_MAX_EXTENTS                        VARCHAR2(40)

 DEF_PCT_INCREASE                       VARCHAR2(40)

 DEF_FREELISTS                 NOT NULL NUMBER

 DEF_FREELIST_GROUPS           NOT NULL NUMBER

 DEF_LOGGING                            VARCHAR2(7)

 DEF_BUFFER_POOL                        VARCHAR2(7)

 DEF_PARAMETERS                         VARCHAR2(1000)

 

 

 

Google
 
Web web site