Data Dictionary Views


Oracle provides a rich set of data dictionary views. These views are owned by the user "SYS" and can be accessed by suitably privileged users. Views that begin with USER_ do not include an OWNER column, since they describe only the objects owned by the currently logged in user .

To get a list of these views, from the database, and the comments associated with them, log on to SQL*Plus as sysdba (internal) and then execute the following package to install it:

 CREATE OR REPLACE PACKAGE describe IS   PROCEDURE describe_tables( tab_owner VARCHAR2, names_like VARCHAR2 ); END describe; / CREATE OR REPLACE PACKAGE BODY describe IS   PROCEDURE print_preamble   IS   BEGIN     dbms_output.put_line( '<HTML>' );     dbms_output.put_line( '<HEAD>' );     dbms_output.put_line( '<TITLE>' );     dbms_output.put_line( 'Table and Column Descriptions and Comments' );     dbms_output.put_line( '</TITLE>' );     dbms_output.put_line( '</HEAD>' );     dbms_output.put_line( '<BODY>' );     dbms_output.put_line( '<TABLE BORDER=1>' );   END;   PROCEDURE print_postamble   IS   BEGIN     dbms_output.put_line( '</TABLE>' );     dbms_output.put_line( '</BODY>' );   END;   PROCEDURE describe_tables( tab_owner VARCHAR2, names_like VARCHAR2 )   IS     CURSOR tabs( tab_owner VARCHAR2, names_like VARCHAR2 )     IS       SELECT table_name,              comments       FROM dba_tab_comments       WHERE owner = tab_owner         AND table_name LIKE names_like       ORDER BY table_name;     CURSOR cols( tab_owner VARCHAR2, tab_name VARCHAR2 )     IS       SELECT a.column_name,              a.comments,              DECODE(b.data_type,                     'BLOB','BLOB',                     'CHAR','CHAR ('b.data_length')',                     'CLOB','CLOB',                     'DATE','DATE',                     'FLOAT','FLOAT '                         DECODE( NVL( b.data_precision, 0 ), 0, NULL,                         '('b.data_precision','b.data_scale')' ),                     'LONG','LONG',                     'LONG RAW','LONG RAW',                     'MLSLABEL','MLSLABEL',                     'NCHAR','NCHAR ('b.data_length')',                     'NCLOB','NCLOB',                     'NUMBER', 'NUMBER '                         DECODE( NVL( b.data_precision, 0 ), 0, NULL,                         '('b.data_precision','b.data_scale')' ),                     'NVARCHAR2','NVARCHAR2 ('b.data_length')',                     'RAW','RAW ('b.data_length')',                     'ROWID','ROWID',                     'VARCHAR2','VARCHAR2 ('b.data_length')',                     'UNKNOWN' ) col_type,                    decode( b.nullable, 'N',' NOT NULL', NULL ) null_str,                    b.data_default       FROM dba_col_comments a, dba_tab_columns b       WHERE a.owner = tab_owner         AND a.table_name = tab_name         AND a.owner = b.owner         AND a.table_name = b.table_name         AND a.column_name = b.column_name       ORDER by b.column_id;   BEGIN     print_preamble;     FOR tab_rec IN tabs( tab_owner, names_like )     LOOP       dbms_output.put_line( '<TR><TD>'                             tab_rec.table_name                             '</TD><TD>'                             tab_rec.comments                             '</TD></TR>'                           );       dbms_output.put_line( '<TR><TABLE>' );       FOR col_rec IN cols( tab_owner, tab_rec.table_name )       LOOP         dbms_output.put_line( '<TR><TD>'                               col_rec.column_name                               '</TD><TD>'                               col_rec.col_type                               '</TD><TD>'                               col_rec.null_str                               '</TD><TD>'                               col_rec.data_default                               '</TD><TD>'                               col_rec.comments                               '</TD></TR>'                             );       END LOOP;       dbms_output.put_line( '</TR></TABLE>' );     END LOOP;     print_postamble;   END; END describe; / 

Then to run the package, from the SQL> prompt:

 set serveroutput on 1000000 exec describe.describe_tables('SYS','DBA_%') 

the output will scroll to the screen unless you set a spool.

Table 3-1. Data Dictionary Views

_ALL_INSTANTIATION_DDL

_ALL_REPCOLUMN

_ALL_REPCOLUMN_GROUP

_ALL_REPCONFLICT

_ALL_REPEXTENSIONS

_ALL_REPFLAVOR_OBJECTS

_ALL_REPGROUPED_COLUMN

_ALL_REPPARAMETER_COLUMN

_ALL_REPRESOLUTION

_ALL_REPSITES_NEW

ALL_ALL_TABLES

ALL_APPLY

ALL_APPLY_CONFLICT_COLUMNS

ALL_APPLY_DML_HANDLERS

ALL_APPLY_ERROR

ALL_APPLY_KEY_COLUMNS

ALL_APPLY_PARAMETERS

ALL_APPLY_PROGRESS

ALL_ARGUMENTS

ALL_ASSOCIATIONS

ALL_AUDIT_POLICIES

ALL_BASE_TABLE_MVIEWS

ALL_CAPTURE

ALL_CAPTURE_PARAMETERS

ALL_CAPTURE_PREPARED_DATABASE

ALL_CAPTURE_PREPARED_SCHEMAS

ALL_CAPTURE_PREPARED_TABLES

ALL_CATALOG

ALL_CLUSTER_HASH_EXPRESSIONS

ALL_CLUSTERS

ALL_COL_COMMENTS

ALL_COL_PRIVS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_COLL_TYPES

ALL_CONS_COLUMNS

ALL_CONS_OBJ_COLUMNS

ALL_CONSTRAINTS

ALL_CONTEXT

ALL_DB_LINKS

ALL_DEF_AUDIT_OPTS

ALL_DEPENDENCIES

ALL_DIM_ATTRIBUTES

ALL_DIM_CHILD_OF

ALL_DIM_HIERARCHIES

ALL_DIM_JOIN_KEY

ALL_DIM_LEVEL_KEY

ALL_DIM_LEVELS

ALL_DIMENSIONS

ALL_DIRECTORIES

ALL_ERRORS

ALL_EVALUATION_CONTEXT_TABLES

ALL_EVALUATION_CONTEXT_VARS

ALL_EVALUATION_CONTEXTS

ALL_EXTERNAL_LOCATIONS

ALL_EXTERNAL_TABLES

ALL_IND_COLUMNS

ALL_IND_EXPRESSIONS

ALL_INDEXES

ALL_INDEXTYPE_COMMENTS

ALL_INDEXTYPE_OPERATORS

ALL_INDEXTYPES

ALL_INTERNAL_TRIGGERS

ALL_JAVA_ARGUMENTS

ALL_JAVA_CLASSES

ALL_JAVA_DERIVATIONS

ALL_JAVA_FIELDS

ALL_JAVA_IMPLEMENTS

ALL_JAVA_INNERS

ALL_JAVA_LAYOUTS

ALL_JAVA_METHODS

ALL_JAVA_NCOMPS

ALL_JAVA_RESOLVERS

ALL_JAVA_THROWS

ALL_JOIN_IND_COLUMNS

ALL_LIBRARIES

ALL_LOBS

ALL_LOG_GROUP_COLUMNS

ALL_LOG_GROUPS

ALL_METHOD_PARAMS

ALL_METHOD_RESULTS

ALL_MVIEW_AGGREGATES

ALL_MVIEW_ANALYSIS

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_JOINS

ALL_MVIEW_KEYS

ALL_MVIEW_LOGS

ALL_MVIEW_REFRESH_TIMES

ALL_MVIEWS

ALL_NESTED_TABLES

ALL_OBJ_COLATTRS

ALL_OBJECT_TABLES

ALL_OBJECTS

ALL_OPANCILLARY

ALL_OPARGUMENTS

ALL_OPBINDINGS

ALL_OPERATOR_COMMENTS

ALL_OPERATORS

ALL_PARTIAL_DROP_TABS

ALL_PENDING_CONV_TABLES

ALL_POLICIES

ALL_POLICY_CONTEXTS

ALL_POLICY_GROUPS

ALL_PROCEDURES

ALL_PROPAGATION

ALL_QUEUE_TABLES

ALL_QUEUES

ALL_REFRESH

ALL_REFRESH_CHILDREN

ALL_REFRESH_DEPENDENCIES

ALL_REFS

ALL_REGISTERED_MVIEWS

ALL_REGISTERED_SNAPSHOTS

ALL_REPAUDIT_ATTRIBUTE

ALL_REPAUDIT_COLUMN

ALL_REPCATLOG

ALL_REPCOLUMN

ALL_REPCOLUMN_GROUP

ALL_REPCONFLICT

ALL_REPDDL

ALL_REPFLAVOR_COLUMNS

ALL_REPFLAVOR_OBJECTS

ALL_REPFLAVORS

ALL_REPGENERATED

ALL_REPGENOBJECTS

ALL_REPGROUP

ALL_REPGROUP_PRIVILEGES

ALL_REPGROUPED_COLUMN

ALL_REPKEY_COLUMNS

ALL_REPOBJECT

ALL_REPPARAMETER_COLUMN

ALL_REPPRIORITY

ALL_REPPRIORITY_GROUP

ALL_REPPROP

ALL_REPRESOL_STATS_CONTROL

ALL_REPRESOLUTION

ALL_REPRESOLUTION_METHOD

ALL_REPRESOLUTION_STATISTICS

ALL_REPSCHEMA

ALL_REPSITES

ALL_RULE_SET_RULES

ALL_RULE_SETS

ALL_RULES

ALL_RULESETS

ALL_SECONDARY_OBJECTS

ALL_SEQUENCES

ALL_SNAPSHOT_LOGS

ALL_SNAPSHOTS

ALL_SOURCE

ALL_SQLJ_TYPE_ATTRS

ALL_SQLJ_TYPE_METHODS

ALL_SQLJ_TYPES

ALL_STORED_SETTINGS

ALL_STREAMS_GLOBAL_RULES

ALL_STREAMS_SCHEMA_RULES

ALL_STREAMS_TABLE_RULES

ALL_SUMDELTA

ALL_SUMMARIES

ALL_SYNONYMS

ALL_TAB_COL_STATISTICS

ALL_TAB_COLS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TAB_HISTOGRAMS

ALL_TAB_MODIFICATIONS

ALL_TAB_PRIVS

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_RECD

ALL_TABLES

ALL_TRIGGER_COLS

ALL_TRIGGERS

ALL_TYPE_ATTRS

ALL_TYPE_METHODS

ALL_TYPE_VERSIONS

ALL_TYPES

ALL_UNUSED_COL_TABS

ALL_UPDATABLE_COLUMNS

ALL_USERS

ALL_USTATS

ALL_VARRAYS

ALL_VIEWS

ALL_XML_SCHEMAS

ALL_XML_TAB_COLS

ALL_XML_TABLES

ALL_XML_VIEW_COLS

ALL_XML_VIEWS

ATEMPTAB$

AUDIT_ACTIONS

COLUMN_PRIVILEGES

DATABASE_COMPATIBLE_LEVEL

DATABASE_PROPERTIES

DBA_2PC_NEIGHBORS

DBA_2PC_PENDING

DBA_ALL_TABLES

DBA_APPLY

DBA_APPLY_CONFLICT_COLUMNS

DBA_APPLY_DML_HANDLERS

DBA_APPLY_ERROR

DBA_APPLY_INSTANTIATED_OBJECTS

DBA_APPLY_KEY_COLUMNS

DBA_APPLY_PARAMETERS

DBA_APPLY_PROGRESS

DBA_ASSOCIATIONS

DBA_AUDIT_EXISTS

DBA_AUDIT_OBJECT

DBA_AUDIT_POLICIES

DBA_AUDIT_SESSION

DBA_AUDIT_STATEMENT

DBA_AUDIT_TRAIL

DBA_AW_PS

DBA_AWS

DBA_BASE_TABLE_MVIEWS

DBA_CAPTURE

DBA_CAPTURE_PARAMETERS

DBA_CAPTURE_PREPARED_DATABASE

DBA_CAPTURE_PREPARED_SCHEMAS

DBA_CAPTURE_PREPARED_TABLES

DBA_CATALOG

DBA_CLU_COLUMNS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_CLUSTERS

DBA_COL_COMMENTS

DBA_COL_PRIVS

DBA_COLL_TYPES

DBA_CONS_COLUMNS

DBA_CONS_OBJ_COLUMNS

DBA_CONSTRAINTS

DBA_CONTEXT

DBA_DATA_FILES

DBA_DB_LINKS

DBA_DEPENDENCIES

DBA_DIM_ATTRIBUTES

DBA_DIM_CHILD_OF

DBA_DIM_HIERARCHIES

DBA_DIM_JOIN_KEY

DBA_DIM_LEVEL_KEY

DBA_DIM_LEVELS

DBA_DIMENSIONS

DBA_DIRECTORIES

DBA_DMT_FREE_SPACE

DBA_DMT_USED_EXTENTS

DBA_ERRORS

DBA_EVALUATION_CONTEXT_TABLES

DBA_EVALUATION_CONTEXT_VARS

DBA_EVALUATION_CONTEXTS

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

DBA_EXTENTS

DBA_EXTERNAL_LOCATIONS

DBA_EXTERNAL_TABLES

DBA_FGA_AUDIT_TRAIL

DBA_FREE_SPACE

DBA_FREE_SPACE_COALESCED

DBA_GLOBAL_CONTEXT

DBA_IND_COLUMNS

DBA_IND_EXPRESSIONS

DBA_INDEXES

DBA_INDEXTYPE_COMMENTS

DBA_INDEXTYPE_OPERATORS

DBA_INDEXTYPES

DBA_INTERNAL_TRIGGERS

DBA_JAVA_ARGUMENTS

DBA_JAVA_CLASSES

DBA_JAVA_DERIVATIONS

DBA_JAVA_FIELDS

DBA_JAVA_IMPLEMENTS

DBA_JAVA_INNERS

DBA_JAVA_LAYOUTS

DBA_JAVA_METHODS

DBA_JAVA_POLICY

DBA_JAVA_RESOLVERS

DBA_JAVA_THROWS

DBA_JOBS

DBA_JOBS_RUNNING

DBA_JOIN_IND_COLUMNS

DBA_LIBRARIES

DBA_LMT_FREE_SPACE

DBA_LMT_USED_EXTENTS

DBA_LOBS

DBA_LOG_GROUP_COLUMNS

DBA_LOG_GROUPS

DBA_LOGSTDBY_EVENTS

DBA_LOGSTDBY_NOT_UNIQUE

DBA_LOGSTDBY_PARAMETERS

DBA_LOGSTDBY_PROGRESS

DBA_LOGSTDBY_SKIP

DBA_LOGSTDBY_SKIP_TRANSACTION

DBA_LOGSTDBY_UNSUPPORTED

DBA_METHOD_PARAMS

DBA_METHOD_RESULTS

DBA_MVIEW_AGGREGATES

DBA_MVIEW_ANALYSIS

DBA_MVIEW_DETAIL_RELATIONS

DBA_MVIEW_JOINS

DBA_MVIEW_KEYS

DBA_MVIEW_LOG_FILTER_COLS

DBA_MVIEW_LOGS

DBA_MVIEW_REFRESH_TIMES

DBA_MVIEWS

DBA_NESTED_TABLES

DBA_OBJ_AUDIT_OPTS

DBA_OBJ_COLATTRS

DBA_OBJECT_SIZE

DBA_OBJECT_TABLES

DBA_OBJECTS

DBA_OPANCILLARY

DBA_OPARGUMENTS

DBA_OPBINDINGS

DBA_OPERATOR_COMMENTS

DBA_OPERATORS

DBA_OUTLINE_HINTS

DBA_OUTLINES

DBA_PARTIAL_DROP_TABS

DBA_PENDING_CONV_TABLES

DBA_PENDING_TRANSACTIONS

DBA_POLICIES

DBA_POLICY_CONTEXTS

DBA_POLICY_GROUPS

DBA_PRIV_AUDIT_OPTS

DBA_PROCEDURES

DBA_PROFILES

DBA_PROPAGATION

DBA_PROXIES

DBA_QUEUE_TABLES

DBA_QUEUES

DBA_RCHILD

DBA_REFRESH

DBA_REFRESH_CHILDREN

DBA_REFS

DBA_REGISTERED_MVIEW_GROUPS

DBA_REGISTERED_MVIEWS

DBA_REGISTERED_SNAPSHOT_GROUPS

DBA_REGISTERED_SNAPSHOTS

DBA_REPAUDIT_ATTRIBUTE

DBA_REPAUDIT_COLUMN

DBA_REPCAT_EXCEPTIONS

DBA_REPCATLOG

DBA_REPCOLUMN

DBA_REPCOLUMN_GROUP

DBA_REPCONFLICT

DBA_REPDDL

DBA_REPEXTENSIONS

DBA_REPFLAVOR_COLUMNS

DBA_REPFLAVOR_OBJECTS

DBA_REPFLAVORS

DBA_REPGENERATED

DBA_REPGENOBJECTS

DBA_REPGROUP

DBA_REPGROUP_PRIVILEGES

DBA_REPGROUPED_COLUMN

DBA_REPKEY_COLUMNS

DBA_REPOBJECT

DBA_REPPARAMETER_COLUMN

DBA_REPPRIORITY

DBA_REPPRIORITY_GROUP

DBA_REPPROP

DBA_REPRESOL_STATS_CONTROL

DBA_REPRESOLUTION

DBA_REPRESOLUTION_METHOD

DBA_REPRESOLUTION_STATISTICS

DBA_REPSCHEMA

DBA_REPSITES

DBA_REPSITES_NEW

DBA_RESUMABLE

DBA_RGROUP

DBA_ROLE_PRIVS

DBA_ROLES

DBA_ROLLBACK_SEGS

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_PLAN_DIRECTIVES

DBA_RSRC_PLANS

DBA_RULE_SET_RULES

DBA_RULE_SETS

DBA_RULES

DBA_RULESETS

DBA_SECONDARY_OBJECTS

DBA_SEGMENTS

DBA_SEQUENCES

DBA_SNAPSHOT_LOGS

DBA_SNAPSHOTS

DBA_SOURCE

DBA_SQLJ_TYPE_ATTRS

DBA_SQLJ_TYPE_METHODS

DBA_SQLJ_TYPES

DBA_STMT_AUDIT_OPTS

DBA_STORED_SETTINGS

DBA_STREAMS_GLOBAL_RULES

DBA_STREAMS_SCHEMA_RULES

DBA_STREAMS_TABLE_RULES

DBA_SUMMARIES

DBA_SYNONYMS

DBA_SYS_PRIVS

DBA_TAB_COL_STATISTICS

DBA_TAB_COLS

DBA_TAB_COLUMNS

DBA_TAB_COMMENTS

DBA_TAB_HISTOGRAMS

DBA_TAB_MODIFICATIONS

DBA_TAB_PRIVS

DBA_TABLES

DBA_TABLESPACES

DBA_TEMP_FILES

DBA_TEMPLATE_REFGROUPS

DBA_TEMPLATE_TARGETS

DBA_TRIGGER_COLS

DBA_TRIGGERS

DBA_TS_QUOTAS

DBA_TYPE_ATTRS

DBA_TYPE_METHODS

DBA_TYPE_VERSIONS

DBA_TYPES

DBA_UNDO_EXTENTS

DBA_UNUSED_COL_TABS

DBA_UPDATABLE_COLUMNS

DBA_USERS

DBA_USTATS

DBA_VARRAYS

DBA_VIEWS

DBA_XML_SCHEMAS

DBA_XML_TAB_COLS

DBA_XML_TABLES

DBA_XML_VIEW_COLS

DBA_XML_VIEWS

DEFCALL

DEFCALLDEST

DEFDEFAULTDEST

DEFERRCOUNT

DEFERROR

DEFLOB

DEFPROPAGATOR

DEFSCHEDULE

DEFTRAN

DICT_COLUMNS

DICTIONARY

FILEXT$

GLOBAL_CONTEXT

GLOBAL_NAME

INDEX_HISTOGRAM

INDEX_STATS

NLS_DATABASE_PARAMETERS

NLS_INSTANCE_PARAMETERS

NLS_SESSION_PARAMETERS

PRODUCT_COMPONENT_VERSION

PROXY_ROLES

PROXY_USERS

PROXY_USERS_AND_ROLES

PUBLIC_DEPENDENCY

QUEUE_PRIVILEGES

REPCAT_GENERATED

REPCAT_REPCAT

REPCAT_REPCATLOG

REPCAT_REPCOLUMN_BASE

REPCAT_REPFLAVOR_COLUMNS

REPCAT_REPOBJECT

REPCAT_REPOBJECT_BASE

REPCAT_REPPROP

REPCAT_REPSCHEMA

RESOURCE_COST

RESOURCE_MAP

ROLE_ROLE_PRIVS

ROLE_SYS_PRIVS

ROLE_TAB_PRIVS

SESSION_CONTEXT

SESSION_PRIVS

SESSION_ROLES

STMT_AUDIT_OPTION_MAP

SYSTEM_PRIVILEGE_MAP

TABLE_PRIVILEGE_MAP

TABLE_PRIVILEGES

TRUSTED_SERVERS

USER_ALL_TABLES

USER_ARGUMENTS

USER_ASSOCIATIONS

USER_AUDIT_OBJECT

USER_AUDIT_POLICIES

USER_AUDIT_SESSION

USER_AUDIT_STATEMENT

USER_AUDIT_TRAIL

USER_AW_PS

USER_AWS

USER_BASE_TABLE_MVIEWS

USER_CATALOG

USER_CLU_COLUMNS

USER_CLUSTER_HASH_EXPRESSIONS

USER_CLUSTERS

USER_COL_COMMENTS

USER_COL_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS_RECD

USER_COLL_TYPES

USER_CONS_COLUMNS

USER_CONS_OBJ_COLUMNS

USER_CONSTRAINTS

USER_DB_LINKS

USER_DEPENDENCIES

USER_DIM_ATTRIBUTES

USER_DIM_CHILD_OF

USER_DIM_HIERARCHIES

USER_DIM_JOIN_KEY

USER_DIM_LEVEL_KEY

USER_DIM_LEVELS

USER_DIMENSIONS

USER_ERRORS

USER_EVALUATION_CONTEXT_TABLES

USER_EVALUATION_CONTEXT_VARS

USER_EVALUATION_CONTEXTS

USER_EXTENTS

USER_EXTERNAL_LOCATIONS

USER_EXTERNAL_TABLES

USER_FREE_SPACE

USER_IND_COLUMNS

USER_IND_EXPRESSIONS

USER_INDEXES

USER_INDEXTYPE_COMMENTS

USER_INDEXTYPE_OPERATORS

USER_INDEXTYPES

USER_INTERNAL_TRIGGERS

USER_JAVA_ARGUMENTS

USER_JAVA_CLASSES

USER_JAVA_DERIVATIONS

USER_JAVA_FIELDS

USER_JAVA_IMPLEMENTS

USER_JAVA_INNERS

USER_JAVA_LAYOUTS

USER_JAVA_METHODS

USER_JAVA_NCOMPS

USER_JAVA_POLICY

USER_JAVA_RESOLVERS

USER_JAVA_THROWS

USER_JOBS

USER_JOIN_IND_COLUMNS

USER_LIBRARIES

USER_LOBS

USER_LOG_GROUP_COLUMNS

USER_LOG_GROUPS

USER_METHOD_PARAMS

USER_METHOD_RESULTS

USER_MVIEW_AGGREGATES

USER_MVIEW_ANALYSIS

USER_MVIEW_DETAIL_RELATIONS

USER_MVIEW_JOINS

USER_MVIEW_KEYS

USER_MVIEW_LOGS

USER_MVIEW_REFRESH_TIMES

USER_MVIEWS

USER_NESTED_TABLES

USER_OBJ_AUDIT_OPTS

USER_OBJ_COLATTRS

USER_OBJECT_SIZE

USER_OBJECT_TABLES

USER_OBJECTS

USER_OPANCILLARY

USER_OPARGUMENTS

USER_OPBINDINGS

USER_OPERATOR_COMMENTS

USER_OPERATORS

USER_OUTLINE_HINTS

USER_OUTLINES

USER_PARTIAL_DROP_TABS

USER_PASSWORD_LIMITS

USER_PENDING_CONV_TABLES

USER_POLICIES

USER_POLICY_CONTEXTS

USER_POLICY_GROUPS

USER_PROCEDURES

USER_PROXIES

USER_QUEUE_TABLES

USER_QUEUES

USER_REFRESH

USER_REFRESH_CHILDREN

USER_REFS

USER_REGISTERED_MVIEWS

USER_REGISTERED_SNAPSHOTS

USER_REPAUDIT_ATTRIBUTE

USER_REPAUDIT_COLUMN

USER_REPCATLOG

USER_REPCOLUMN

USER_REPCOLUMN_GROUP

USER_REPDDL

USER_REPFLAVOR_COLUMNS

USER_REPFLAVOR_OBJECTS

USER_REPFLAVORS

USER_REPGENERATED

USER_REPGENOBJECTS

USER_REPGROUP

USER_REPGROUP_PRIVILEGES

USER_REPGROUPED_COLUMN

USER_REPKEY_COLUMNS

USER_REPOBJECT

USER_REPPARAMETER_COLUMN

USER_REPPRIORITY

USER_REPPRIORITY_GROUP

USER_REPPROP

USER_REPRESOL_STATS_CONTROL

USER_REPRESOLUTION

USER_REPRESOLUTION_METHOD

USER_REPRESOLUTION_STATISTICS

USER_REPSCHEMA

USER_REPSITES

USER_RESOURCE_LIMITS

USER_RESUMABLE

USER_ROLE_PRIVS

USER_RSRC_CONSUMER_GROUP_PRIVS

USER_RSRC_MANAGER_SYSTEM_PRIVS

USER_RULE_SET_RULES

USER_RULE_SETS

USER_RULES

USER_RULESETS

USER_SECONDARY_OBJECTS

USER_SEGMENTS

USER_SEQUENCES

USER_SNAPSHOT_LOGS

USER_SNAPSHOTS

USER_SOURCE

USER_SQLJ_TYPE_ATTRS

USER_SQLJ_TYPE_METHODS

USER_SQLJ_TYPES

USER_STORED_SETTINGS

USER_SUMMARIES

USER_SYNONYMS

USER_SYS_PRIVS

USER_TAB_COL_STATISTICS

USER_TAB_COLS

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TAB_HISTOGRAMS

USER_TAB_MODIFICATIONS

USER_TAB_PRIVS

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS_RECD

USER_TABLES

USER_TABLESPACES

USER_TRIGGER_COLS

USER_TRIGGERS

USER_TS_QUOTAS

USER_TYPE_ATTRS

USER_TYPE_METHODS

USER_TYPE_VERSIONS

USER_TYPES

USER_UNUSED_COL_TABS

USER_UPDATABLE_COLUMNS

USER_USERS

USER_USTATS

USER_VARRAYS

USER_VIEWS

USER_XML_SCHEMAS

USER_XML_TAB_COLS

USER_XML_TABLES

USER_XML_VIEW_COLS

USER_XML_VIEWS

 


Oracle DBA SQL Quick Reference
Oracle DBA SQL Quick Reference
ISBN: 131403036
EAN: N/A
Year: 2003
Pages: 49

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net