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

ALL... | CLU... | IND... | MVI... | PRO... | REP... | SNA... | TAB...

 

ALL_ALL_TABLES: Description of all object and relational tables accessible to the user

 

iSelfSchooling-SQL> desc ALL_ALL_TABLES;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

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

  

ALL_APPLY: Details about each apply process that dequeues from the queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY;

 Name                          Null?    Type

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

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_OWNER                   NOT NULL VARCHAR2(30)

 APPLY_CAPTURED                         VARCHAR2(3)

 RULE_SET_NAME                          VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 APPLY_USER                             VARCHAR2(30)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 APPLY_TAG                              RAW(2000)

 DDL_HANDLER                            VARCHAR2(98)

 PRECOMMIT_HANDLER                      VARCHAR2(98)

 MESSAGE_HANDLER                        VARCHAR2(98)

 STATUS                                 VARCHAR2(8)

 MAX_APPLIED_MESSAGE_NUMBER             NUMBER

 NEGATIVE_RULE_SET_NAME                 VARCHAR2(30)

 NEGATIVE_RULE_SET_OWNER                VARCHAR2(30)

 STATUS_CHANGE_TIME                     DATE

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 

ALL_APPLY_CONFLICT_COLUMNS: Details about conflict resolution on tables visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY_CONFLICT_COLUMNS;

 Name                          Null?    Type

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

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 METHOD_NAME                            VARCHAR2(92)

 RESOLUTION_COLUMN                      VARCHAR2(4000)

 COLUMN_NAME                            VARCHAR2(30)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

ALL_APPLY_DML_HANDLERS: Details about the dml handler on tables visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY_DML_HANDLERS;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 OPERATION_NAME                         VARCHAR2(13)

 USER_PROCEDURE                         VARCHAR2(98)

 ERROR_HANDLER                          VARCHAR2(1)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 APPLY_NAME                             VARCHAR2(30)

 ASSEMBLE_LOBS                          VARCHAR2(1)

 

ALL_APPLY_ENQUEUE: Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user

 

iSelfSchooling-SQL> desc ALL_APPLY_ENQUEUE;

 Name                          Null?    Type

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

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 DESTINATION_QUEUE_NAME                 VARCHAR2(4000)

  

ALL_APPLY_ERROR: Error transactions that were generated after dequeuing from the queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY_ERROR;

 Name                          Null?    Type

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

 APPLY_NAME                             VARCHAR2(30)

 QUEUE_NAME                             VARCHAR2(30)

 QUEUE_OWNER                            VARCHAR2(30)

 LOCAL_TRANSACTION_ID                   VARCHAR2(22)

 SOURCE_DATABASE                        VARCHAR2(128)

 SOURCE_TRANSACTION_ID                  VARCHAR2(22)

 SOURCE_COMMIT_SCN                      NUMBER

 MESSAGE_NUMBER                         NUMBER

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 RECIPIENT_ID                           NUMBER

 RECIPIENT_NAME                         VARCHAR2(30)

 MESSAGE_COUNT                          NUMBER

 ERROR_CREATION_TIME                    DATE

 

ALL_APPLY_EXECUTE: Details about the apply execute action for all rules visible to the user

 

iSelfSchooling-SQL> desc ALL_APPLY_EXECUTE;

 Name                          Null?    Type

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

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 EXECUTE_EVENT                          VARCHAR2(2)

 

ALL_APPLY_KEY_COLUMNS: Alternative key columns for a STREAMS table visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY_KEY_COLUMNS;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

ALL_APPLY_PARAMETERS: Details about parameters of each apply process that dequeues from the queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY_PARAMETERS;

 Name                          Null?    Type

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

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 PARAMETER                     NOT NULL VARCHAR2(128)

 VALUE                                  VARCHAR2(4000)

 SET_BY_USER                            VARCHAR2(3)

 

ALL_APPLY_PROGRESS: Information about the progress made by the apply process that dequeues from the queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_APPLY_PROGRESS;

 Name                          Null?    Type

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

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 SOURCE_DATABASE               NOT NULL VARCHAR2(128)

 APPLIED_MESSAGE_NUMBER        NOT NULL NUMBER

 OLDEST_MESSAGE_NUMBER         NOT NULL NUMBER

 APPLY_TIME                             DATE

 APPLIED_MESSAGE_CREATE_TIME            DATE

 OLDEST_TRANSACTION_ID                  VARCHAR2(22)

 

ALL_APPLY_TABLE_COLUMNS: Details about the columns of destination table object visible to the user

 

iSelfSchooling-SQL> desc ALL_APPLY_TABLE_COLUMNS;

 Name                          Null?    Type

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

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 COMPARE_OLD_ON_DELETE                  VARCHAR2(3)

 COMPARE_OLD_ON_UPDATE                  VARCHAR2(3)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

ALL_ARGUMENTS: Arguments in object accessible to the user

 

iSelfSchooling-SQL> desc ALL_ARGUMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 PACKAGE_NAME                           VARCHAR2(30)

 OBJECT_ID                     NOT NULL NUMBER

 OVERLOAD                               VARCHAR2(40)

 ARGUMENT_NAME                          VARCHAR2(30)

 POSITION                      NOT NULL NUMBER

 SEQUENCE                      NOT NULL NUMBER

 DATA_LEVEL                    NOT NULL NUMBER

 DATA_TYPE                              VARCHAR2(30)

 DEFAULT_VALUE                          LONG

 DEFAULT_LENGTH                         NUMBER

 IN_OUT                                 VARCHAR2(9)

 DATA_LENGTH                            NUMBER

 DATA_PRECISION                         NUMBER

 DATA_SCALE                             NUMBER

 RADIX                                  NUMBER

 CHARACTER_SET_NAME                     VARCHAR2(44)

 TYPE_OWNER                             VARCHAR2(30)

 TYPE_NAME                              VARCHAR2(30)

 TYPE_SUBNAME                           VARCHAR2(30)

 TYPE_LINK                              VARCHAR2(128)

 PLS_TYPE                               VARCHAR2(30)

 CHAR_LENGTH                            NUMBER

 CHAR_USED                              VARCHAR2(1)

 

ALL_ASSOCIATIONS: All associations available to the user

 

iSelfSchooling-SQL> desc ALL_ASSOCIATIONS;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(9)

 STATSTYPE_SCHEMA                       VARCHAR2(30)

 STATSTYPE_NAME                         VARCHAR2(30)

 DEF_SELECTIVITY                        NUMBER

 DEF_CPU_COST                           NUMBER

 DEF_IO_COST                            NUMBER

 DEF_NET_COST                           NUMBER

 INTERFACE_VERSION                      NUMBER

 

ALL_AUDIT_POLICIES: All fine grained auditing policies in the database

 

iSelfSchooling-SQL> desc ALL_AUDIT_POLICIES;

 Name                          Null?    Type

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

 OBJECT_SCHEMA                          VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 POLICY_NAME                            VARCHAR2(30)

 POLICY_TEXT                            VARCHAR2(4000)

 POLICY_COLUMN                          VARCHAR2(30)

 PF_SCHEMA                              VARCHAR2(30)

 PF_PACKAGE                             VARCHAR2(30)

 PF_FUNCTION                            VARCHAR2(30)

 ENABLED                                VARCHAR2(3)

 SEL                                    VARCHAR2(3)

 INS                                    VARCHAR2(3)

 UPD                                    VARCHAR2(3)

 DEL                                    VARCHAR2(3)

 AUDIT_TRAIL                            VARCHAR2(12)

 POLICY_COLUMN_OPTIONS                  VARCHAR2(11)

 

ALL_AUDIT_POLICY_COLUMNS: All fine grained auditing policy columns in the database

 

iSelfSchooling-SQL> desc ALL_AUDIT_POLICY_COLUMNS;

 Name                          Null?    Type

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

 OBJECT_SCHEMA                          VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 POLICY_NAME                            VARCHAR2(30)

 POLICY_COLUMN                          VARCHAR2(30)

 

ALL_AWS: Analytic Workspaces accessible to the user

 

iSelfSchooling-SQL> desc ALL_AWS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 AW_VERSION                             VARCHAR2(4)

 PAGESPACES                             NUMBER

 GENERATIONS                            NUMBER

 

ALL_AW_AC: Active Catalog Analytic Workspaces accessible to the user

 

iSelfSchooling-SQL> desc ALL_AW_AC;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 

ALL_AW_AC_10G

 

iSelfSchooling-SQL> desc ALL_AW_AC_10G;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 

ALL_AW_OBJ: Objects in Analytic Workspaces accessible to the user

 

iSelfSchooling-SQL> desc ALL_AW_OBJ;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 OBJ_ID                                 NUMBER(20)

 OBJ_NAME                               VARCHAR2(256)

 OBJ_TYPE                               NUMBER(4)

 PART_NAME                              VARCHAR2(256)

 

ALL_AW_PROP: Object properties in Analytic Workspaces accessible to the user

 

iSelfSchooling-SQL> desc ALL_AW_PROP;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 OBJ_ID                                 NUMBER(20)

 OBJ_NAME                               VARCHAR2(256)

 PROPERTY_NAME                          VARCHAR2(256)

 PROPERTY_TYPE                          VARCHAR2(4000)

 PROPERTY_VALUE                         VARCHAR2(4000)

 FULL_PROPERTY_VALUE                    CLOB

 PROPERTY_VALUE_LENGTH                  NUMBER

 

ALL_AW_PROP_NAME: Analytic Workspace property names accessible to the user

 

iSelfSchooling-SQL> desc ALL_AW_PROP_NAME;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 OBJ_ID                                 NUMBER(20)

 OBJ_NAME                               VARCHAR2(256)

 PROPERTY_NAME                          VARCHAR2(256)

 

ALL_AW_PS: Pagespaces in Analytic Workspaces accessible to the user

 

iSelfSchooling-SQL> desc ALL_AW_PS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 PSNUMBER                               NUMBER(10)

 GENERATIONS                            NUMBER

 MAXPAGES                               NUMBER

 

ALL_BASE_TABLE_MVIEWS: All materialized views with log(s) in the database that the user can see

 

iSelfSchooling-SQL> desc ALL_BASE_TABLE_MVIEWS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MASTER                        NOT NULL VARCHAR2(30)

 MVIEW_LAST_REFRESH_TIME       NOT NULL DATE

 MVIEW_ID                               NUMBER(38)

 

ALL_CAPTURE: Details about each capture process that stores the captured changes in a queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_CAPTURE;

 Name                          Null?    Type

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

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

 CAPTURE_USER                           VARCHAR2(30)

 START_SCN                              NUMBER

 STATUS                                 VARCHAR2(8)

 CAPTURED_SCN                           NUMBER

 APPLIED_SCN                            NUMBER

 USE_DATABASE_LINK                      VARCHAR2(3)

 FIRST_SCN                              NUMBER

 SOURCE_DATABASE                        VARCHAR2(128)

 SOURCE_DBID                            NUMBER

 SOURCE_RESETLOGS_SCN                   NUMBER

 SOURCE_RESETLOGS_TIME                  NUMBER

 LOGMINER_ID                            NUMBER

 NEGATIVE_RULE_SET_NAME                 VARCHAR2(30)

 NEGATIVE_RULE_SET_OWNER                VARCHAR2(30)

 MAX_CHECKPOINT_SCN                     NUMBER

 REQUIRED_CHECKPOINT_SCN                NUMBER

 LOGFILE_ASSIGNMENT                     VARCHAR2(8)

 STATUS_CHANGE_TIME                     DATE

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 VERSION                                VARCHAR2(64)

 CAPTURE_TYPE                           VARCHAR2(10)

 LAST_ENQUEUED_SCN                      NUMBER

 CHECKPOINT_RETENTION_TIME              NUMBER

 

ALL_CAPTURE_EXTRA_ATTRIBUTES: Extra attributes for a capture process that is visible to the current user

 

iSelfSchooling-SQL> desc ALL_CAPTURE_EXTRA_ATTRIBUTES;

 Name                          Null?    Type

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

 CAPTURE_NAME                  NOT NULL VARCHAR2(30)

 ATTRIBUTE_NAME                NOT NULL VARCHAR2(30)

 INCLUDE                                VARCHAR2(3)

 ROW_ATTRIBUTE                          VARCHAR2(3)

 DDL_ATTRIBUTE                          VARCHAR2(3)

 

ALL_CAPTURE_PARAMETERS: Details about parameters for each capture process that stores the captured changes in a queue visible to the current user

 

iSelfSchooling-SQL> desc ALL_CAPTURE_PARAMETERS;

 Name                          Null?    Type

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

 CAPTURE_NAME                  NOT NULL VARCHAR2(30)

 PARAMETER                     NOT NULL VARCHAR2(128)

 VALUE                                  VARCHAR2(4000)

 SET_BY_USER                            VARCHAR2(3)

 

ALL_CAPTURE_PREPARED_DATABASE: Is the local database prepared for instantiation?

 

iSelfSchooling-SQL> desc ALL_CAPTURE_PREPARED_DATABASE;

 Name                          Null?    Type

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

 TIMESTAMP                              DATE

 SUPPLEMENTAL_LOG_DATA_PK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_UI               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_FK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_ALL              VARCHAR2(8)

 

ALL_CAPTURE_PREPARED_SCHEMAS: All user schemas at the local database that are prepared for instantiation

 

iSelfSchooling-SQL> desc ALL_CAPTURE_PREPARED_SCHEMAS;

 Name                          Null?    Type

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

 SCHEMA_NAME                   NOT NULL VARCHAR2(30)

 TIMESTAMP                              DATE

 SUPPLEMENTAL_LOG_DATA_PK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_UI               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_FK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_ALL              VARCHAR2(8)

 

ALL_CAPTURE_PREPARED_TABLES: All tables visible to the current user that are prepared for instantiation

 

iSelfSchooling-SQL> desc ALL_CAPTURE_PREPARED_TABLES;

 Name                          Null?    Type

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

 TABLE_OWNER                   NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 SCN                           NOT NULL NUMBER

 TIMESTAMP                              DATE

 SUPPLEMENTAL_LOG_DATA_PK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_UI               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_FK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_ALL              VARCHAR2(8)

 

ALL_CATALOG: All tables, views, synonyms, sequences accessible to the user

 

iSelfSchooling-SQL> desc ALL_CATALOG;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TABLE_TYPE                             VARCHAR2(11)

 

ALL_CLUSTERS: Description of clusters accessible to the user

 

iSelfSchooling-SQL> desc ALL_CLUSTERS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 CLUSTER_NAME                  NOT NULL VARCHAR2(30)

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 PCT_FREE                               NUMBER

 PCT_USED                               NUMBER

 KEY_SIZE                               NUMBER

 INI_TRANS                     NOT NULL NUMBER

 MAX_TRANS                     NOT NULL NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                   NOT NULL NUMBER

 MAX_EXTENTS                   NOT NULL NUMBER

 PCT_INCREASE                           NUMBER

 FREELISTS                              NUMBER

 FREELIST_GROUPS                        NUMBER

 AVG_BLOCKS_PER_KEY                     NUMBER

 CLUSTER_TYPE                           VARCHAR2(5)

 FUNCTION                               VARCHAR2(15)

 HASHKEYS                               NUMBER

 DEGREE                                 VARCHAR2(10)

 INSTANCES                              VARCHAR2(10)

 CACHE                                  VARCHAR2(5)

 BUFFER_POOL                            VARCHAR2(7)

 SINGLE_TABLE                           VARCHAR2(5)

 DEPENDENCIES                           VARCHAR2(8)

 

Google
 
Web web site