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

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

 

DBA_STREAMS_NEWLY_SUPPORTED: List of tables that are newly supported by Streams

 

iSelfSchooling-SQL> desc DBA_STREAMS_NEWLY_SUPPORTED;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 REASON                                 VARCHAR2(39)

 COMPATIBLE                             CHAR(4)

 

DBA_STREAMS_RENAME_COLUMN: Rename column transformations

 

iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_COLUMN;

 Name                          Null?    Type

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

 RULE_OWNER                             VARCHAR2(30)

 RULE_NAME                              VARCHAR2(30)

 SCHEMA_NAME                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 FROM_COLUMN_NAME                       VARCHAR2(4000)

 TO_COLUMN_NAME                         VARCHAR2(4000)

 VALUE_TYPE                             VARCHAR2(3)

 PRECEDENCE                             NUMBER

 STEP_NUMBER                            NUMBER

 

DBA_STREAMS_RENAME_SCHEMA: Rename schema transformations

 

iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_SCHEMA;

 Name                          Null?    Type

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

 RULE_OWNER                             VARCHAR2(30)

 RULE_NAME                              VARCHAR2(30)

 FROM_SCHEMA_NAME                       VARCHAR2(30)

 TO_SCHEMA_NAME                         VARCHAR2(30)

 PRECEDENCE                             NUMBER

 STEP_NUMBER                            NUMBER

 

DBA_STREAMS_RENAME_TABLE: Rename table transformations

 

iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_TABLE;

 Name                          Null?    Type

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

 RULE_OWNER                             VARCHAR2(30)

 RULE_NAME                              VARCHAR2(30)

 FROM_SCHEMA_NAME                       VARCHAR2(30)

 TO_SCHEMA_NAME                         VARCHAR2(30)

 FROM_TABLE_NAME                        VARCHAR2(30)

 TO_TABLE_NAME                          VARCHAR2(30)

 PRECEDENCE                             NUMBER

 STEP_NUMBER                            NUMBER

 

DBA_STREAMS_RULES: Rules used by Streams processes

 

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

 

DBA_STREAMS_SCHEMA_RULES: Schema rules created by streams administrative APIs

 

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

 

DBA_STREAMS_TABLE_RULES: Table rules created by streams administrative APIs

 

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

 

DBA_STREAMS_TRANSFORMATIONS: Transformations defined on rules

 

iSelfSchooling-SQL> desc DBA_STREAMS_TRANSFORMATIONS;

 Name                          Null?    Type

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

 RULE_OWNER                             VARCHAR2(30)

 RULE_NAME                              VARCHAR2(30)

 TRANSFORM_TYPE                         VARCHAR2(26)

 FROM_SCHEMA_NAME                       VARCHAR2(30)

 TO_SCHEMA_NAME                         VARCHAR2(30)

 FROM_TABLE_NAME                        VARCHAR2(30)

 TO_TABLE_NAME                          VARCHAR2(30)

 SCHEMA_NAME                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 FROM_COLUMN_NAME                       VARCHAR2(4000)

 TO_COLUMN_NAME                         VARCHAR2(4000)

 COLUMN_NAME                            VARCHAR2(4000)

 COLUMN_VALUE                           ANYDATA

 COLUMN_TYPE                            VARCHAR2(4000)

 COLUMN_FUNCTION                        VARCHAR2(30)

 VALUE_TYPE                             VARCHAR2(3)

 USER_FUNCTION_NAME                     VARCHAR2(4000)

 SUBSETTING_OPERATION                   VARCHAR2(6)

 DML_CONDITION                          VARCHAR2(4000)

 DECLARATIVE_TYPE                       VARCHAR2(13)

 PRECEDENCE                             NUMBER

 STEP_NUMBER                            NUMBER

 

DBA_STREAMS_TRANSFORM_FUNCTION: Rules-based transform functions used by Streams

 

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

 

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

 

iSelfSchooling-SQL> desc DBA_STREAMS_UNSUPPORTED;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 REASON                                 VARCHAR2(39)

 AUTO_FILTERED                          VARCHAR2(3)

 

DBA_SUBPARTITION_TEMPLATES

 

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

 

DBA_SUBPART_COL_STATISTICS

 

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

 

DBA_SUBPART_HISTOGRAMS

 

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

 

DBA_SUBPART_KEY_COLUMNS

 

iSelfSchooling-SQL> desc DBA_SUBPART_KEY_COLUMNS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 NAME                                   VARCHAR2(30)

 OBJECT_TYPE                            CHAR(5)

 COLUMN_NAME                            VARCHAR2(4000)

 COLUMN_POSITION                        NUMBER

 

DBA_SUBSCRIBED_COLUMNS: Change Data Capture subscribed columns

 

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

 

DBA_SUBSCRIBED_TABLES: Change Data Capture subscribed tables

 

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

 

DBA_SUBSCRIPTIONS: Change Data Capture subscriptions

 

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

 

DBA_SUMMARIES: Description of the summaries accessible to dba

 

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

 

DBA_SYNONYMS: All synonyms in the database

 

iSelfSchooling-SQL> desc DBA_SYNONYMS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 SYNONYM_NAME                  NOT NULL VARCHAR2(30)

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 DB_LINK                                VARCHAR2(128)

 

DBA_SYS_PRIVS: System privileges granted to users and roles

 

iSelfSchooling-SQL> desc DBA_SYS_PRIVS;

 Name                          Null?    Type

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

 GRANTEE                       NOT NULL VARCHAR2(30)

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 ADMIN_OPTION                           VARCHAR2(3)

 

DBA_TABLES: Description of all relational tables in the database

 

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

 

DBA_TABLESPACES: Description of all tablespaces

 

iSelfSchooling-SQL> desc DBA_TABLESPACES;

 Name                          Null?    Type

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

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 BLOCK_SIZE                    NOT NULL NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                   NOT NULL NUMBER

 MAX_EXTENTS                            NUMBER

 PCT_INCREASE                           NUMBER

 MIN_EXTLEN                             NUMBER

 STATUS                                 VARCHAR2(9)

 CONTENTS                               VARCHAR2(9)

 LOGGING                                VARCHAR2(9)

 FORCE_LOGGING                          VARCHAR2(3)

 EXTENT_MANAGEMENT                      VARCHAR2(10)

 ALLOCATION_TYPE                        VARCHAR2(9)

 PLUGGED_IN                             VARCHAR2(3)

 SEGMENT_SPACE_MANAGEMENT               VARCHAR2(6)

 DEF_TAB_COMPRESSION                    VARCHAR2(8)

 RETENTION                              VARCHAR2(11)

 BIGFILE                                VARCHAR2(3)

 

DBA_TABLESPACE_GROUPS: Description of all tablespace groups

 

iSelfSchooling-SQL> desc DBA_TABLESPACE_GROUPS;

 Name                          Null?    Type

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

 GROUP_NAME                    NOT NULL VARCHAR2(30)

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 

DBA_TABLESPACE_USAGE_METRICS: Description of all tablespace space usage metrics

 

iSelfSchooling-SQL> desc DBA_TABLESPACE_USAGE_METRICS;

 Name                          Null?    Type

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

 TABLESPACE_NAME                        VARCHAR2(30)

 USED_SPACE                             NUMBER

 TABLESPACE_SIZE                        NUMBER

 USED_PERCENT                           NUMBER

 

DBA_TAB_COLS: Columns of user's tables, views and clusters

 

iSelfSchooling-SQL> desc DBA_TAB_COLS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 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)

 

DBA_TAB_COLUMNS: Columns of user's tables, views and clusters

 

iSelfSchooling-SQL> desc DBA_TAB_COLUMNS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 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)

 HISTOGRAM                              VARCHAR2(15)

 

DBA_TAB_COL_STATISTICS: Columns of user's tables, views and clusters

 

iSelfSchooling-SQL> desc DBA_TAB_COL_STATISTICS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(30)

 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

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 AVG_COL_LEN                            NUMBER

 HISTOGRAM                              VARCHAR2(15)

 

DBA_TAB_COMMENTS: Comments on all tables and views in the database

 

iSelfSchooling-SQL> desc DBA_TAB_COMMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TABLE_TYPE                             VARCHAR2(11)

 COMMENTS                               VARCHAR2(4000)

 

DBA_TAB_HISTOGRAMS: Histograms on columns of all tables

 

iSelfSchooling-SQL> desc DBA_TAB_HISTOGRAMS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 ENDPOINT_NUMBER                        NUMBER

 ENDPOINT_VALUE                         NUMBER

 ENDPOINT_ACTUAL_VALUE                  VARCHAR2(1000)

 

DBA_TAB_MODIFICATIONS: Information regarding modifications to tables

 

iSelfSchooling-SQL> desc DBA_TAB_MODIFICATIONS;

 Name                          Null?    Type

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

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 PARTITION_NAME                         VARCHAR2(30)

 SUBPARTITION_NAME                      VARCHAR2(30)

 INSERTS                                NUMBER

 UPDATES                                NUMBER

 DELETES                                NUMBER

 TIMESTAMP                              DATE

 TRUNCATED                              VARCHAR2(3)

 DROP_SEGMENTS                          NUMBER

 

DBA_TAB_PARTITIONS

 

iSelfSchooling-SQL> desc DBA_TAB_PARTITIONS;

 Name                          Null?    Type

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

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 COMPOSITE                              VARCHAR2(3)

 PARTITION_NAME                         VARCHAR2(30)

 SUBPARTITION_COUNT                     NUMBER

 HIGH_VALUE                             LONG

 HIGH_VALUE_LENGTH                      NUMBER

 PARTITION_POSITION                     NUMBER

 TABLESPACE_NAME                        VARCHAR2(30)

 PCT_FREE                               NUMBER

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

 NUM_ROWS                               NUMBER

 BLOCKS                                 NUMBER

 EMPTY_BLOCKS                           NUMBER

 AVG_SPACE                              NUMBER

 CHAIN_CNT                              NUMBER

 AVG_ROW_LEN                            NUMBER

 SAMPLE_SIZE                            NUMBER

 LAST_ANALYZED                          DATE

 BUFFER_POOL                            VARCHAR2(7)

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 

DBA_TAB_PRIVS: All grants on objects in the database

 

iSelfSchooling-SQL> desc DBA_TAB_PRIVS;

 Name                          Null?    Type

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

 GRANTEE                       NOT NULL VARCHAR2(30)

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 GRANTOR                       NOT NULL VARCHAR2(30)

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 GRANTABLE                              VARCHAR2(3)

 HIERARCHY                              VARCHAR2(3)

 

DBA_TAB_STATISTICS: Optimizer statistics for all tables in the database

 

iSelfSchooling-SQL> desc DBA_TAB_STATISTICS;

 Name                          Null?    Type

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

 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)

 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

 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)

 

 

 

 

Google
 
Web web site