 Home |
 Help |
 Contact Us |
|
Home |
Help |
Contact Us |
The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:
If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.
| USE |
| USER_ADVISOR_ACTIONS: Syntax, Search for it |
| USER_ADVISOR_FINDINGS: Syntax, Search for it |
| USER_ADVISOR_JOURNAL: Syntax, Search for it |
| USER_ADVISOR_LOG: Syntax, Search for it |
| USER_ADVISOR_OBJECTS: Syntax, Search for it |
| USER_ADVISOR_PARAMETERS: Syntax, Search for it |
| USER_ADVISOR_RATIONALE: Syntax, Search for it |
| USER_ADVISOR_RECOMMENDATIONS: Syntax, Search for it |
| USER_ADVISOR_SQLA_REC_SUM: Syntax, Search for it |
| USER_ADVISOR_SQLA_WK_MAP: Syntax, Search for it |
| USER_ADVISOR_SQLA_WK_STMTS: Syntax, Search for it |
| USER_ADVISOR_SQLW_JOURNAL: Syntax, Search for it |
| USER_ADVISOR_SQLW_PARAMETERS: Syntax, Search for it |
| USER_ADVISOR_SQLW_STMTS: Syntax, Search for it |
| USER_ADVISOR_SQLW_SUM: Syntax, Search for it |
| USER_ADVISOR_SQLW_TABLES: Syntax, Search for it |
| USER_ADVISOR_SQLW_TEMPLATES: Syntax, Search for it |
| USER_ADVISOR_TASKS: Syntax, Search for it |
| USER_ADVISOR_TEMPLATES: Syntax, Search for it |
| USER_ALL_TABLES: Syntax, Search for it |
| USER_AQ_AGENT_PRIVS: Syntax, Search for it |
| USER_ARGUMENTS: Syntax, Search for it |
| USER_ASSOCIATIONS: Syntax, Search for it |
| USER_ATTRIBUTE_TRANSFORMATIONS: Syntax, Search for it |
| USER_AUDIT_OBJECT: Syntax, Search for it |
| USER_AUDIT_POLICIES: Syntax, Search for it |
| USER_AUDIT_POLICY_COLUMNS: Syntax, Search for it |
| USER_AUDIT_SESSION: Syntax, Search for it |
| USER_AUDIT_STATEMENT: Syntax, Search for it |
| USER_AUDIT_TRAIL: Syntax, Search for it |
| USER_AW_PS: Syntax, Search for it |
| USER_AWS: Syntax, Search for it |
| USER_BASE_TABLE_MVIEWS: Syntax, Search for it |
| USER_CATALOG: Syntax, Search for it |
| USER_CHANGE_NOTIFICATION_REGS: Syntax, Search for it |
| USER_CLU_COLUMNS: Syntax, Search for it |
| USER_CLUSTER_HASH_EXPRESSIONS: Syntax, Search for it |
| USER_CLUSTERS: Syntax, Search for it |
| USER_COL_COMMENTS: Syntax, Search for it |
| USER_COL_PRIVS: Syntax, Search for it |
| USER_COL_PRIVS_MADE: Syntax, Search for it |
| USER_COL_PRIVS_RECD: Syntax, Search for it |
| USER_COLL_TYPES: Syntax, Search for it |
| USER_CONS_COLUMNS: Syntax, Search for it |
| USER_CONS_OBJ_COLUMNS: Syntax, Search for it |
| USER_CONSTRAINTS: Syntax, Search for it |
| USER_DATAPUMP_JOBS: Syntax, Search for it |
| USER_DB_LINKS: Syntax, Search for it |
| USER_DEPENDENCIES: Syntax, Search for it |
| USER_DIM_ATTRIBUTES: Syntax, Search for it |
| USER_DIM_CHILD_OF: Syntax, Search for it |
| USER_DIM_HIERARCHIES: Syntax, Search for it |
| USER_DIM_JOIN_KEY: Syntax, Search for it |
| USER_DIM_LEVEL_KEY: Syntax, Search for it |
| USER_DIM_LEVELS: Syntax, Search for it |
| USER_DIMENSIONS: Syntax, Search for it |
| USER_DUMP_DEST: Syntax, Search for it |
| USER_ENCRYPTED_COLUMNS: Syntax, Search for it |
| USER_EPG_DAD_AUTHORIZATION: Syntax, Search for it |
| USER_ERRORS: Syntax, Search for it |
| USER_EVALUATION_CONTEXT_TABLES: Syntax, Search for it |
| USER_EVALUATION_CONTEXT_VARS: Syntax, Search for it |
| USER_EVALUATION_CONTEXTS: Syntax, Search for it |
| USER_EXTENTS: Syntax, Search for it |
| USER_EXTERNAL_LOCATIONS: Syntax, Search for it |
| USER_EXTERNAL_TABLES: Syntax, Search for it |
| USER_FILE_GROUP_EXPORT_INFO: Syntax, Search for it |
| USER_FILE_GROUP_FILES: Syntax, Search for it |
| USER_FILE_GROUP_TABLES: Syntax, Search for it |
| USER_FILE_GROUP_TABLESPACES: Syntax, Search for it |
| USER_FILE_GROUP_VERSIONS: Syntax, Search for it |
| USER_FILE_GROUPS: Syntax, Search for it |
| USER_FREE_SPACE: Syntax, Search for it |
| USER_IND_COLUMNS: Syntax, Search for it |
| USER_IND_EXPRESSIONS: Syntax, Search for it |
| USER_IND_PARTITIONS: Syntax, Search for it |
| USER_IND_STATISTICS: Syntax, Search for it |
| USER_IND_SUBPARTITIONS: Syntax, Search for it |
| USER_INDEXES: Syntax, Search for it |
| USER_INDEXTYPE_ARRAYTYPES: Syntax, Search for it |
| USER_INDEXTYPE_COMMENTS: Syntax, Search for it |
| USER_INDEXTYPE_OPERATORS: Syntax, Search for it |
| USER_INDEXTYPES: Syntax, Search for it |
| USER_INTERNAL_TRIGGERS: Syntax, Search for it |
| USER_JAVA_ARGUMENTS: Syntax, Search for it |
| USER_JAVA_CLASSES: Syntax, Search for it |
| USER_JAVA_DERIVATIONS: Syntax, Search for it |
| USER_JAVA_FIELDS: Syntax, Search for it |
| USER_JAVA_IMPLEMENTS: Syntax, Search for it |
| USER_JAVA_INNERS: Syntax, Search for it |
| USER_JAVA_LAYOUTS: Syntax, Search for it |
| USER_JAVA_METHODS: Syntax, Search for it |
| USER_JAVA_NCOMPS: Syntax, Search for it |
| USER_JAVA_POLICY: Syntax, Search for it |
| USER_JAVA_RESOLVERS: Syntax, Search for it |
| USER_JAVA_THROWS: Syntax, Search for it |
| USER_JOBS: Syntax, Search for it |
| USER_JOIN_IND_COLUMNS: Syntax, Search for it |
| USER_LIBRARIES: Syntax, Search for it |
| USER_LOB_PARTITIONS: Syntax, Search for it |
| USER_LOB_SUBPARTITIONS: Syntax, Search for it |
| USER_LOB_TEMPLATES: Syntax, Search for it |
| USER_LOBS: Syntax, Search for it |
| USER_LOG_GROUP_COLUMNS: Syntax, Search for it |
| USER_LOG_GROUPS: Syntax, Search for it |
| USER_METHOD_PARAMS: Syntax, Search for it |
| USER_METHOD_RESULTS: Syntax, Search for it |
| USER_MVIEW_AGGREGATES: Syntax, Search for it |
| USER_MVIEW_ANALYSIS: Syntax, Search for it |
| USER_MVIEW_COMMENTS: Syntax, Search for it |
| USER_MVIEW_DETAIL_RELATIONS: Syntax, Search for it |
| USER_MVIEW_JOINS: Syntax, Search for it |
| USER_MVIEW_KEYS: Syntax, Search for it |
| USER_MVIEW_LOGS: Syntax, Search for it |
| USER_MVIEW_REFRESH_TIMES: Syntax, Search for it |
| USER_MVIEWS: Syntax, Search for it |
| USER_NESTED_TABLE_COLS: Syntax, Search for it |
| USER_NESTED_TABLES: Syntax, Search for it |
| USER_OBJ_AUDIT_OPTS: Syntax, Search for it |
| USER_OBJ_COLATTRS: Syntax, Search for it |
| USER_OBJECT_SIZE: Syntax, Search for it |
| USER_OBJECT_TABLES: Syntax, Search for it |
| USER_OBJECTS: Syntax, Search for it |
| USER_OPANCILLARY: Syntax, Search for it |
| USER_OPARGUMENTS: Syntax, Search for it |
| USER_OPBINDINGS: Syntax, Search for it |
| USER_OPERATOR_COMMENTS: Syntax, Search for it |
| USER_OPERATORS: Syntax, Search for it |
| USER_OUTLINE_HINTS: Syntax, Search for it |
| USER_OUTLINES: Syntax, Search for it |
| USER_PART_COL_STATISTICS: Syntax, Search for it |
| USER_PART_HISTOGRAMS: Syntax, Search for it |
| USER_PART_INDEXES: Syntax, Search for it |
| USER_PART_KEY_COLUMNS: Syntax, Search for it |
| USER_PART_LOBS: Syntax, Search for it |
| USER_PART_TABLES: Syntax, Search for it |
| USER_PARTIAL_DROP_TABS: Syntax, Search for it |
| USER_PASSWORD_LIMITS: Syntax, Search for it |
| USER_PENDING_CONV_TABLES: Syntax, Search for it |
| USER_PLSQL_OBJECT_SETTINGS: Syntax, Search for it |
| USER_POLICIES: Syntax, Search for it |
| USER_POLICY_CONTEXTS: Syntax, Search for it |
| USER_POLICY_GROUPS: Syntax, Search for it |
| USER_PROCEDURES: Syntax, Search for it |
| USER_PROXIES: Syntax, Search for it |
| USER_PUBLISHED_COLUMNS: Syntax, Search for it |
| USER_QUEUE_SCHEDULES: Syntax, Search for it |
| USER_QUEUE_SUBSCRIBERS: Syntax, Search for it |
| USER_QUEUE_TABLES: Syntax, Search for it |
| USER_QUEUES: Syntax, Search for it |
| USER_RECYCLEBIN: Syntax, Search for it |
| USER_REFRESH: Syntax, Search for it |
| USER_REFRESH_CHILDREN: Syntax, Search for it |
| USER_REFS: Syntax, Search for it |
| USER_REGISTERED_MVIEWS: Syntax, Search for it |
| USER_REGISTRY: Syntax, Search for it |
| USER_RESOURCE_LIMITS: Syntax, Search for it |
| USER_RESUMABLE: Syntax, Search for it |
| USER_REWRITE_EQUIVALENCES: Syntax, Search for it |
| USER_ROLE_PRIVS: Syntax, Search for it |
| USER_RSRC_CONSUMER_GROUP_PRIVS: Syntax, Search for it |
| USER_RSRC_MANAGER_SYSTEM_PRIVS: Syntax, Search for it |
| USER_RULE_SET_RULES: Syntax, Search for it |
| USER_RULE_SETS: Syntax, Search for it |
| USER_RULES: Syntax, Search for it |
| USER_SCHEDULER_CHAIN_RULES: Syntax, Search for it |
| USER_SCHEDULER_CHAIN_STEPS: Syntax, Search for it |
| USER_SCHEDULER_CHAINS: Syntax, Search for it |
| USER_SCHEDULER_JOB_ARGS: Syntax, Search for it |
| USER_SCHEDULER_JOB_LOG: Syntax, Search for it |
| USER_SCHEDULER_JOB_RUN_DETAILS: Syntax, Search for it |
| USER_SCHEDULER_JOBS: Syntax, Search for it |
| USER_SCHEDULER_PROGRAM_ARGS: Syntax, Search for it |
| USER_SCHEDULER_PROGRAMS: Syntax, Search for it |
| USER_SCHEDULER_RUNNING_CHAINS: Syntax, Search for it |
| USER_SCHEDULER_RUNNING_JOBS: Syntax, Search for it |
| USER_SCHEDULER_SCHEDULES: Syntax, Search for it |
| USER_SEC_RELEVANT_COLS: Syntax, Search for it |
| USER_SEGMENTS: Syntax, Search for it |
| USER_SEQUENCES: Syntax, Search for it |
| USER_SOURCE: Syntax, Search for it |
| USER_SOURCE_TABLES: Syntax, Search for it |
| USER_SQLJ_TYPE_ATTRS: Syntax, Search for it |
| USER_SQLJ_TYPE_METHODS: Syntax, Search for it |
| USER_SQLJ_TYPES: Syntax, Search for it |
| USER_SQLSET: Syntax, Search for it |
| USER_SQLSET_BINDS: Syntax, Search for it |
| USER_SQLSET_PLANS: Syntax, Search for it |
| USER_SQLSET_REFERENCES: Syntax, Search for it |
| USER_SQLSET_STATEMENTS: Syntax, Search for it |
| USER_SQLTUNE_BINDS: Syntax, Search for it |
| USER_SQLTUNE_PLANS: Syntax, Search for it |
| USER_SQLTUNE_RATIONALE_PLAN: Syntax, Search for it |
| USER_SQLTUNE_STATISTICS: Syntax, Search for it |
| USER_STORED_SETTINGS: Syntax, Search for it |
| USER_SUBPART_COL_STATISTICS: Syntax, Search for it |
| USER_SUBPART_HISTOGRAMS: Syntax, Search for it |
| USER_SUBPART_KEY_COLUMNS: Syntax, Search for it |
| USER_SUBPARTITION_TEMPLATES: Syntax, Search for it |
| USER_SUBSCRIBED_COLUMNS: Syntax, Search for it |
| USER_SUBSCRIBED_TABLES: Syntax, Search for it |
| USER_SUBSCRIPTIONS: Syntax, Search for it |
| USER_SYNONYMS: Syntax, Search for it |
| USER_SYS_PRIVS: Syntax, Search for it |
| USER_TAB_COL_STATISTICS: Syntax, Search for it |
| USER_TAB_COLS: Syntax, Search for it |
| USER_TAB_COLUMNS: Syntax, Search for it |
| USER_TAB_COMMENTS: Syntax, Search for it |
| USER_TAB_HISTOGRAMS: Syntax, Search for it |
| USER_TAB_MODIFICATIONS: Syntax, Search for it |
| USER_TAB_PARTITIONS: Syntax, Search for it |
| USER_TAB_PRIVS: Syntax, Search for it |
| USER_TAB_PRIVS_MADE: Syntax, Search for it |
| USER_TAB_PRIVS_RECD: Syntax, Search for it |
| USER_TAB_STATISTICS: Syntax, Search for it |
| USER_TAB_STATS_HISTORY: Syntax, Search for it |
| USER_TAB_SUBPARTITIONS: Syntax, Search for it |
| USER_TABLES: Syntax, Search for it |
| USER_TABLESPACES: Syntax, Search for it |
| USER_TRANSFORMATIONS: Syntax, Search for it |
| USER_TRIGGER_COLS: Syntax, Search for it |
| USER_TRIGGERS: Syntax, Search for it |
| USER_TS_QUOTAS: Syntax, Search for it |
| USER_TUNE_MVIEW: Syntax, Search for it |
| USER_TYPE_ATTRS: Syntax, Search for it |
| USER_TYPE_METHODS: Syntax, Search for it |
| USER_TYPE_VERSIONS: Syntax, Search for it |
| USER_TYPES: Syntax, Search for it |
| USER_UNUSED_COL_TABS: Syntax, Search for it |
| USER_UPDATABLE_COLUMNS: Syntax, Search for it |
| USER_USERS: Syntax, Search for it |
| USER_USTATS: Syntax, Search for it |
| USER_VARRAYS: Syntax, Search for it |
| USER_VIEWS: Syntax, Search for it |
| USER_WARNING_SETTINGS: Syntax, Search for it |
| USER_XML_SCHEMAS: Syntax, Search for it |
| USER_XML_TAB_COLS: Syntax, Search for it |
| USER_XML_TABLES: Syntax, Search for it |
| USER_XML_VIEW_COLS: Syntax, Search for it |
| USER_XML_VIEWS: Syntax, Search for it |
