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_SNAPSHOT_LOGS: All snapshot logs in the database that the user can see

 

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

 CURRENT_SNAPSHOTS                      DATE

 SNAPSHOT_ID                            NUMBER

 

ALL_SNAPSHOT_REFRESH_TIMES: Synonym for ALL_MVIEW_REFRESH_TIMES

 

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

 

ALL_SOURCE

Current source on stored objects that user is allowed to create

 

iSelfSchooling-SQL> desc ALL_SOURCE;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 NAME                                   VARCHAR2(30)

 TYPE                                   VARCHAR2(12)

 LINE                                   NUMBER

 TEXT                                   VARCHAR2(4000)

 

ALL_SOURCE_TABLES: Source tables available for Change Data Capture

 

iSelfSchooling-SQL> desc ALL_SOURCE_TABLES;

 Name                          Null?    Type

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

 SOURCE_SCHEMA_NAME            NOT NULL VARCHAR2(30)

 SOURCE_TABLE_NAME             NOT NULL VARCHAR2(30)

 

ALL_SQLJ_TYPES: Description of types accessible to the user

 

iSelfSchooling-SQL> desc ALL_SQLJ_TYPES;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TYPE_NAME                     NOT NULL VARCHAR2(30)

 TYPE_OID                      NOT NULL RAW(16)

 EXTERNAL_NAME                          VARCHAR2(4000)

 USING                                  VARCHAR2(21)

 TYPECODE                               VARCHAR2(30)

 ATTRIBUTES                             NUMBER

 METHODS                                NUMBER

 PREDEFINED                             VARCHAR2(3)

 INCOMPLETE                             VARCHAR2(3)

 FINAL                                  VARCHAR2(3)

 INSTANTIABLE                           VARCHAR2(3)

 SUPERTYPE_OWNER                        VARCHAR2(30)

 SUPERTYPE_NAME                         VARCHAR2(30)

 LOCAL_ATTRIBUTES                       NUMBER

 LOCAL_METHODS                          NUMBER

 

ALL_SQLJ_TYPE_ATTRS: Description of attributes of types accessible to the user

 

iSelfSchooling-SQL> desc ALL_SQLJ_TYPE_ATTRS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TYPE_NAME                     NOT NULL VARCHAR2(30)

 ATTR_NAME                     NOT NULL VARCHAR2(30)

 EXTERNAL_ATTR_NAME                     VARCHAR2(4000)

 ATTR_TYPE_MOD                          VARCHAR2(7)

 ATTR_TYPE_OWNER                        VARCHAR2(30)

 ATTR_TYPE_NAME                         VARCHAR2(30)

 LENGTH                                 NUMBER

 PRECISION                              NUMBER

 SCALE                                  NUMBER

 CHARACTER_SET_NAME                     VARCHAR2(44)

 ATTR_NO                       NOT NULL NUMBER

 INHERITED                              VARCHAR2(3)

 

ALL_SQLJ_TYPE_METHODS: Description of methods of types accessible to the user

 

iSelfSchooling-SQL> desc ALL_SQLJ_TYPE_METHODS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TYPE_NAME                     NOT NULL VARCHAR2(30)

 METHOD_NAME                   NOT NULL VARCHAR2(30)

 EXTERNAL_VAR_NAME                      VARCHAR2(4000)

 METHOD_NO                     NOT NULL NUMBER

 METHOD_TYPE                            VARCHAR2(6)

 PARAMETERS                    NOT NULL NUMBER

 RESULTS                       NOT NULL NUMBER

 FINAL                                  VARCHAR2(3)

 INSTANTIABLE                           VARCHAR2(3)

 OVERRIDING                             VARCHAR2(3)

 INHERITED                              VARCHAR2(3)

 

ALL_SQLSET

 

iSelfSchooling-SQL> desc ALL_SQLSET;

 Name                          Null?    Type

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

 NAME                          NOT NULL VARCHAR2(30)

 ID                            NOT NULL NUMBER

 OWNER                                  VARCHAR2(30)

 DESCRIPTION                            VARCHAR2(256)

 CREATED                                DATE

 LAST_MODIFIED                          DATE

 STATEMENT_COUNT                        NUMBER

 

ALL_SQLSET_BINDS

 

iSelfSchooling-SQL> desc ALL_SQLSET_BINDS;

 Name                          Null?    Type

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

 SQLSET_NAME                            VARCHAR2(30)

 SQLSET_OWNER                           VARCHAR2(30)

 SQLSET_ID                              NUMBER

 SQL_ID                                 VARCHAR2(13)

 FORCE_MATCHING_SIGNATURE               NUMBER

 PLAN_HASH_VALUE                        NUMBER

 POSITION                               NUMBER

 VALUE                                  ANYDATA

 CAPTURED                               CHAR(1)

 SQL_SEQ                                NUMBER

 

ALL_SQLSET_PLANS

 

iSelfSchooling-SQL> desc ALL_SQLSET_PLANS;

 Name                          Null?    Type

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

 SQLSET_NAME                   NOT NULL VARCHAR2(30)

 SQLSET_OWNER                           VARCHAR2(30)

 SQLSET_ID                     NOT NULL NUMBER

 SQL_ID                        NOT NULL VARCHAR2(13)

 FORCE_MATCHING_SIGNATURE      NOT NULL NUMBER

 PLAN_HASH_VALUE               NOT NULL NUMBER

 SQL_SEQ                       NOT NULL NUMBER

 STATEMENT_ID                           VARCHAR2(30)

 PLAN_ID                                NUMBER

 TIMESTAMP                              DATE

 REMARKS                                VARCHAR2(4000)

 OPERATION                              VARCHAR2(30)

 OPTIONS                                VARCHAR2(255)

 OBJECT_NODE                            VARCHAR2(128)

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 OBJECT_ALIAS                           VARCHAR2(65)

 OBJECT_INSTANCE                        NUMBER(38)

 OBJECT_TYPE                            VARCHAR2(30)

 OPTIMIZER                              VARCHAR2(255)

 SEARCH_COLUMNS                         NUMBER

 ID                            NOT NULL NUMBER(38)

 PARENT_ID                              NUMBER(38)

 DEPTH                                  NUMBER(38)

 POSITION                               NUMBER(38)

 COST                                   NUMBER(38)

 CARDINALITY                            NUMBER(38)

 BYTES                                  NUMBER(38)

 OTHER_TAG                              VARCHAR2(255)

 PARTITION_START                        VARCHAR2(255)

 PARTITION_STOP                         VARCHAR2(255)

 PARTITION_ID                           NUMBER(38)

 OTHER                                  LONG

 DISTRIBUTION                           VARCHAR2(30)

 CPU_COST                               NUMBER(38)

 IO_COST                                NUMBER(38)

 TEMP_SPACE                             NUMBER(38)

 ACCESS_PREDICATES                      VARCHAR2(4000)

 FILTER_PREDICATES                      VARCHAR2(4000)

 PROJECTION                             VARCHAR2(4000)

 TIME                                   NUMBER(38)

 QBLOCK_NAME                            VARCHAR2(30)

 OTHER_XML                              CLOB

 EXECUTIONS                             NUMBER

 STARTS                                 NUMBER

 OUTPUT_ROWS                            NUMBER

 CR_BUFFER_GETS                         NUMBER

 CU_BUFFER_GETS                         NUMBER

 DISK_READS                             NUMBER

 DISK_WRITES                            NUMBER

 ELAPSED_TIME                           NUMBER

 

ALL_SQLSET_REFERENCES

 

iSelfSchooling-SQL> desc ALL_SQLSET_REFERENCES;

 Name                          Null?    Type

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

 SQLSET_NAME                   NOT NULL VARCHAR2(30)

 SQLSET_OWNER                           VARCHAR2(30)

 SQLSET_ID                     NOT NULL NUMBER

 ID                            NOT NULL NUMBER

 OWNER                                  VARCHAR2(30)

 DESCRIPTION                            VARCHAR2(256)

 CREATED                                DATE

 

ALL_SQLSET_STATEMENTS

 

iSelfSchooling-SQL> desc ALL_SQLSET_STATEMENTS;

 Name                          Null?    Type

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

 SQLSET_NAME                   NOT NULL VARCHAR2(30)

 SQLSET_OWNER                           VARCHAR2(30)

 SQLSET_ID                     NOT NULL NUMBER

 SQL_ID                        NOT NULL VARCHAR2(13)

 FORCE_MATCHING_SIGNATURE      NOT NULL NUMBER

 SQL_TEXT                               CLOB

 PARSING_SCHEMA_NAME                    VARCHAR2(30)

 PLAN_HASH_VALUE               NOT NULL NUMBER

 BIND_DATA                              RAW(2000)

 BINDS_CAPTURED                         CHAR(1)

 MODULE                                 VARCHAR2(48)

 ACTION                                 VARCHAR2(32)

 ELAPSED_TIME                           NUMBER

 CPU_TIME                               NUMBER

 BUFFER_GETS                            NUMBER

 DISK_READS                             NUMBER

 DIRECT_WRITES                          NUMBER

 ROWS_PROCESSED                         NUMBER

 FETCHES                                NUMBER

 EXECUTIONS                             NUMBER

 END_OF_FETCH_COUNT                     NUMBER

 OPTIMIZER_COST                         NUMBER

 OPTIMIZER_ENV                          RAW(1000)

 PRIORITY                               NUMBER

 COMMAND_TYPE                           NUMBER

 FIRST_LOAD_TIME                        VARCHAR2(19)

 STAT_PERIOD                            NUMBER

 ACTIVE_STAT_PERIOD                     NUMBER

 OTHER                                  CLOB

 PLAN_TIMESTAMP                         DATE

 SQL_SEQ                       NOT NULL NUMBER

 

ALL_STORED_SETTINGS: Parameter settings for objects accessible to the user

 

iSelfSchooling-SQL> desc ALL_STORED_SETTINGS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 OBJECT_ID                     NOT NULL NUMBER

 OBJECT_TYPE                            VARCHAR2(12)

 PARAM_NAME                    NOT NULL VARCHAR2(30)

 PARAM_VALUE                            VARCHAR2(4000)

 

ALL_STREAMS_GLOBAL_RULES: Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_STREAMS_GLOBAL_RULES;

 Name                          Null?    Type

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

 STREAMS_NAME                           VARCHAR2(30)

 STREAMS_TYPE                           VARCHAR2(11)

 RULE_TYPE                              VARCHAR2(7)

 INCLUDE_TAGGED_LCR                     VARCHAR2(3)

 SOURCE_DATABASE                        VARCHAR2(128)

 RULE_NAME                              VARCHAR2(30)

 RULE_OWNER                             VARCHAR2(30)

 RULE_CONDITION                         VARCHAR2(4000)

 

ALL_STREAMS_MESSAGE_CONSUMERS: Streams messaging consumers visible to the current user

 

iSelfSchooling-SQL> desc ALL_STREAMS_MESSAGE_CONSUMERS;

 Name                          Null?    Type

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

 STREAMS_NAME                  NOT NULL VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_OWNER                   NOT NULL VARCHAR2(30)

 RULE_SET_NAME                          VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 NEGATIVE_RULE_SET_NAME                 VARCHAR2(30)

 NEGATIVE_RULE_SET_OWNER                VARCHAR2(30)

 NOTIFICATION_TYPE                      VARCHAR2(9)

 NOTIFICATION_ACTION                    VARCHAR2(256)

 NOTIFICATION_CONTEXT                   ANYDATA

 

ALL_STREAMS_MESSAGE_RULES: Rules for Streams messaging visible to the current user

 

iSelfSchooling-SQL> desc ALL_STREAMS_MESSAGE_RULES;

 Name                          Null?    Type

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

 STREAMS_NAME                  NOT NULL VARCHAR2(30)

 STREAMS_TYPE                           VARCHAR2(11)

 MESSAGE_TYPE_NAME                      VARCHAR2(30)

 MESSAGE_TYPE_OWNER                     VARCHAR2(30)

 MESSAGE_RULE_VARIABLE                  VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_CONDITION                         VARCHAR2(4000)

 

ALL_STREAMS_NEWLY_SUPPORTED: List of tables that are newly supported by Streams

 

iSelfSchooling-SQL> desc ALL_STREAMS_NEWLY_SUPPORTED;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 REASON                                 VARCHAR2(39)

 COMPATIBLE                             CHAR(4)

 

ALL_STREAMS_RULES: Rules used by streams processes

 

iSelfSchooling-SQL> desc ALL_STREAMS_RULES;

 Name                          Null?    Type

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

 STREAMS_TYPE                           VARCHAR2(11)

 STREAMS_NAME                           VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 RULE_SET_NAME                          VARCHAR2(30)

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 RULE_CONDITION                         CLOB

 RULE_SET_TYPE                          CHAR(8)

 STREAMS_RULE_TYPE                      VARCHAR2(6)

 SCHEMA_NAME                            VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 SUBSETTING_OPERATION                   VARCHAR2(6)

 DML_CONDITION                          VARCHAR2(4000)

 INCLUDE_TAGGED_LCR                     VARCHAR2(3)

 SOURCE_DATABASE                        VARCHAR2(128)

 RULE_TYPE                              VARCHAR2(3)

 MESSAGE_TYPE_OWNER                     VARCHAR2(30)

 MESSAGE_TYPE_NAME                      VARCHAR2(30)

 MESSAGE_RULE_VARIABLE                  VARCHAR2(30)

 ORIGINAL_RULE_CONDITION                VARCHAR2(4000)

 SAME_RULE_CONDITION                    VARCHAR2(3)

 

ALL_STREAMS_SCHEMA_RULES: Rules created by streams administrative APIs on all user schemas

 

iSelfSchooling-SQL> desc ALL_STREAMS_SCHEMA_RULES;

 Name                          Null?    Type

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

 STREAMS_NAME                           VARCHAR2(30)

 STREAMS_TYPE                           VARCHAR2(11)

 SCHEMA_NAME                            VARCHAR2(30)

 RULE_TYPE                              VARCHAR2(7)

 INCLUDE_TAGGED_LCR                     VARCHAR2(3)

 SOURCE_DATABASE                        VARCHAR2(128)

 RULE_NAME                              VARCHAR2(30)

 RULE_OWNER                             VARCHAR2(30)

 RULE_CONDITION                         VARCHAR2(4000)

 

ALL_STREAMS_TABLE_RULES: Rules created by streams administrative APIs on tables visible to the current user

 

iSelfSchooling-SQL> desc ALL_STREAMS_TABLE_RULES;

 Name                          Null?    Type

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

 STREAMS_NAME                           VARCHAR2(30)

 STREAMS_TYPE                           VARCHAR2(11)

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 RULE_TYPE                              VARCHAR2(7)

 DML_CONDITION                          VARCHAR2(4000)

 SUBSETTING_OPERATION                   VARCHAR2(6)

 INCLUDE_TAGGED_LCR                     VARCHAR2(3)

 SOURCE_DATABASE                        VARCHAR2(128)

 RULE_NAME                              VARCHAR2(30)

 RULE_OWNER                             VARCHAR2(30)

 RULE_CONDITION                         VARCHAR2(4000)

 

ALL_STREAMS_TRANSFORM_FUNCTION: Rules-based transform functions used by Streams

 

iSelfSchooling-SQL> desc ALL_STREAMS_TRANSFORM_FUNCTION;

 Name                          Null?    Type

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

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 VALUE_TYPE                             VARCHAR2(4000)

 TRANSFORM_FUNCTION_NAME                VARCHAR2(4000)

 CUSTOM_TYPE                            VARCHAR2(11)

 

ALL_STREAMS_UNSUPPORTED: List of all the tables that are not supported by Streams in this release

 

iSelfSchooling-SQL> desc ALL_STREAMS_UNSUPPORTED;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 REASON                                 VARCHAR2(39)

 AUTO_FILTERED                          VARCHAR2(3)

 

ALL_SUBPARTITION_TEMPLATES

 

iSelfSchooling-SQL> desc ALL_SUBPARTITION_TEMPLATES;

 Name                          Null?    Type

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

 USER_NAME                     NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 SUBPARTITION_NAME             NOT NULL VARCHAR2(34)

 SUBPARTITION_POSITION                  NUMBER

 TABLESPACE_NAME                        VARCHAR2(30)

 HIGH_BOUND                             LONG

 

ALL_SUBPART_COL_STATISTICS

 

iSelfSchooling-SQL> desc ALL_SUBPART_COL_STATISTICS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 SUBPARTITION_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)

 

ALL_SUBPART_HISTOGRAMS

 

iSelfSchooling-SQL> desc ALL_SUBPART_HISTOGRAMS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 SUBPARTITION_NAME                      VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 BUCKET_NUMBER                          NUMBER

 ENDPOINT_VALUE                         NUMBER

 ENDPOINT_ACTUAL_VALUE                  VARCHAR2(1000)

 

ALL_SUBPART_KEY_COLUMNS

 

iSelfSchooling-SQL> desc ALL_SUBPART_KEY_COLUMNS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 NAME                                   VARCHAR2(30)

 OBJECT_TYPE                            CHAR(5)

 COLUMN_NAME                            VARCHAR2(4000)

 COLUMN_POSITION                        NUMBER

 

ALL_SUBSCRIBED_COLUMNS: Change Data Capture subscribed columns

 

iSelfSchooling-SQL> desc ALL_SUBSCRIBED_COLUMNS;

 Name                          Null?    Type

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

 HANDLE                        NOT NULL NUMBER

 SOURCE_SCHEMA_NAME            NOT NULL VARCHAR2(30)

 SOURCE_TABLE_NAME             NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 SUBSCRIPTION_NAME             NOT NULL VARCHAR2(30)

 

ALL_SUBSCRIBED_TABLES: Change Data Capture subscribed tables

 

iSelfSchooling-SQL> desc ALL_SUBSCRIBED_TABLES;

 Name                          Null?    Type

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

 HANDLE                        NOT NULL NUMBER

 SOURCE_SCHEMA_NAME            NOT NULL VARCHAR2(30)

 SOURCE_TABLE_NAME             NOT NULL VARCHAR2(30)

 VIEW_NAME                              VARCHAR2(30)

 CHANGE_SET_NAME               NOT NULL VARCHAR2(30)

 SUBSCRIPTION_NAME             NOT NULL VARCHAR2(30)

 

ALL_SUBSCRIPTIONS: Change Data Capture subscriptions

 

iSelfSchooling-SQL> desc ALL_SUBSCRIPTIONS;

 Name                          Null?    Type

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

 HANDLE                        NOT NULL NUMBER

 SET_NAME                      NOT NULL VARCHAR2(30)

 USERNAME                      NOT NULL VARCHAR2(30)

 CREATED                       NOT NULL DATE

 STATUS                        NOT NULL VARCHAR2(1)

 EARLIEST_SCN                  NOT NULL NUMBER

 LATEST_SCN                    NOT NULL NUMBER

 DESCRIPTION                            VARCHAR2(255)

 LAST_PURGED                            DATE

 LAST_EXTENDED                          DATE

 SUBSCRIPTION_NAME             NOT NULL VARCHAR2(30)

 

ALL_SUMDELTA: Direct path load entries accessible to the user

 

iSelfSchooling-SQL> desc ALL_SUMDELTA;

 Name                          Null?    Type

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

 TABLEOBJ#                     NOT NULL NUMBER

 PARTITIONOBJ#                 NOT NULL NUMBER

 DMLOPERATION                           VARCHAR2(1)

 SCN                           NOT NULL NUMBER

 TIMESTAMP                     NOT NULL DATE

 LOWROWID                      NOT NULL ROWID

 HIGHROWID                     NOT NULL ROWID

 SEQUENCE                               NUMBER

 

ALL_SUMMARIES: Description of the summaries accessible to the user

 

iSelfSchooling-SQL> desc ALL_SUMMARIES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 SUMMARY_NAME                  NOT NULL VARCHAR2(30)

 CONTAINER_OWNER               NOT NULL VARCHAR2(30)

 CONTAINER_NAME                         VARCHAR2(30)

 LAST_REFRESH_SCN                       NUMBER

 LAST_REFRESH_DATE                      DATE

 REFRESH_METHOD                         VARCHAR2(11)

 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)

 QUERY_LEN                              NUMBER

 QUERY                                  LONG

 

ALL_SYNONYMS: All synonyms for base objects accessible to the user and session

 

iSelfSchooling-SQL> desc ALL_SYNONYMS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 SYNONYM_NAME                           VARCHAR2(30)

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 DB_LINK                                VARCHAR2(128)

 

ALL_TABLES: Description of relational tables accessible to the user

 

iSelfSchooling-SQL> desc ALL_TABLES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 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)

 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)

 

 

Google
 
Web web site