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