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_ADDM_FDG_BREAKDOWN: Syntax |
USER_ADDM_FINDINGS: Syntax |
USER_ADDM_INSTANCES: Syntax |
USER_ADDM_TASKS: Syntax |
USER_ADVISOR_ACTIONS: Syntax |
USER_ADVISOR_DIR_TASK_INST: Syntax |
USER_ADVISOR_EXECUTIONS: Syntax |
USER_ADVISOR_EXEC_PARAMETERS: Syntax |
USER_ADVISOR_FDG_BREAKDOWN: Syntax |
USER_ADVISOR_FINDINGS: Syntax |
USER_ADVISOR_JOURNAL: Syntax |
USER_ADVISOR_LOG: Syntax |
USER_ADVISOR_OBJECTS: Syntax |
USER_ADVISOR_PARAMETERS: Syntax |
USER_ADVISOR_RATIONALE: Syntax |
USER_ADVISOR_RECOMMENDATIONS: Syntax |
USER_ADVISOR_SQLA_REC_SUM: Syntax |
USER_ADVISOR_SQLA_TABLES: Syntax |
USER_ADVISOR_SQLA_WK_MAP: Syntax |
USER_ADVISOR_SQLA_WK_STMTS: Syntax |
USER_ADVISOR_SQLPLANS: Syntax |
USER_ADVISOR_SQLSTATS: Syntax |
USER_ADVISOR_SQLW_JOURNAL: Syntax |
USER_ADVISOR_SQLW_PARAMETERS: Syntax |
USER_ADVISOR_SQLW_STMTS: Syntax |
USER_ADVISOR_SQLW_SUM: Syntax |
USER_ADVISOR_SQLW_TABLES: Syntax |
USER_ADVISOR_SQLW_TEMPLATES: Syntax |
USER_ADVISOR_TASKS: Syntax |
USER_ADVISOR_TEMPLATES: Syntax |
USER_ALL_TABLES: Syntax |
USER_AQ_AGENT_PRIVS: Syntax |
USER_ARGUMENTS: Syntax |
USER_ASSEMBLIES: Syntax |
USER_ASSOCIATIONS: Syntax |
USER_ATTRIBUTE_TRANSFORMATIONS: Syntax |
USER_AUDIT_OBJECT: Syntax |
USER_AUDIT_POLICIES: Syntax |
USER_AUDIT_POLICY_COLUMNS: Syntax |
USER_AUDIT_SESSION: Syntax |
USER_AUDIT_STATEMENT: Syntax |
USER_AUDIT_TRAIL: Syntax |
USER_AWS: Syntax |
USER_AW_PS: Syntax |
USER_BASE_TABLE_MVIEWS: Syntax |
USER_CATALOG: Syntax |
USER_CHANGE_NOTIFICATION_REGS: Syntax |
USER_CLUSTERS: Syntax |
USER_CLUSTER_HASH_EXPRESSIONS: Syntax |
USER_CLU_COLUMNS: Syntax |
USER_COLL_TYPES: Syntax |
USER_COL_COMMENTS: Syntax |
USER_COL_PENDING_STATS: Syntax |
USER_COL_PRIVS: Syntax |
USER_COL_PRIVS_MADE: Syntax |
USER_COL_PRIVS_RECD: Syntax |
USER_COMPARISON: Syntax |
USER_COMPARISON_COLUMNS: Syntax |
USER_COMPARISON_ROW_DIF: Syntax |
USER_COMPARISON_SCAN: Syntax |
USER_COMPARISON_SCAN_VALUES: Syntax |
USER_CONSTRAINTS: Syntax |
USER_CONS_COLUMNS: Syntax |
USER_CONS_OBJ_COLUMNS: Syntax |
USER_CQ_NOTIFICATION_QUERIES: Syntax |
USER_CUBES: Syntax |
USER_CUBE_ATTRIBUTES: Syntax |
USER_CUBE_ATTR_VISIBILITY: Syntax |
USER_CUBE_BUILD_PROCESSES: Syntax |
USER_CUBE_CALCULATED_MEMBERS: Syntax |
USER_CUBE_DIMENSIONALITY: Syntax |
USER_CUBE_DIMENSIONS: Syntax |
USER_CUBE_DIM_LEVELS: Syntax |
USER_CUBE_DIM_MODELS: Syntax |
USER_CUBE_DIM_VIEWS: Syntax |
USER_CUBE_DIM_VIEW_COLUMNS: Syntax |
USER_CUBE_HIERARCHIES: Syntax |
USER_CUBE_HIER_LEVELS: Syntax |
USER_CUBE_HIER_VIEWS: Syntax |
USER_CUBE_HIER_VIEW_COLUMNS: Syntax |
USER_CUBE_MEASURES: Syntax |
USER_CUBE_VIEWS: Syntax |
USER_CUBE_VIEW_COLUMNS: Syntax |
USER_DATAPUMP_JOBS: Syntax |
USER_DBFS_HS_FILES: Syntax |
USER_DB_LINKS: Syntax |
USER_DEPENDENCIES: Syntax |
USER_DIMENSIONS: Syntax |
USER_DIM_ATTRIBUTES: Syntax |
USER_DIM_CHILD_OF: Syntax |
USER_DIM_HIERARCHIES: Syntax |
USER_DIM_JOIN_KEY: Syntax |
USER_DIM_LEVELS: Syntax |
USER_DIM_LEVEL_KEY: Syntax |
USER_EDITIONING_VIEWS: Syntax |
USER_EDITIONING_VIEWS_AE: Syntax |
USER_EDITIONING_VIEW_COLS: Syntax |
USER_EDITIONING_VIEW_COLS_AE: Syntax |
USER_ENCRYPTED_COLUMNS: Syntax |
USER_EPG_DAD_AUTHORIZATION: Syntax |
USER_ERRORS: Syntax |
USER_ERRORS_AE: Syntax |
USER_EVALUATION_CONTEXTS: Syntax |
USER_EVALUATION_CONTEXT_TABLES: Syntax |
USER_EVALUATION_CONTEXT_VARS: Syntax |
USER_EXTENTS: Syntax |
USER_EXTERNAL_LOCATIONS: Syntax |
USER_EXTERNAL_TABLES: Syntax |
USER_FILE_GROUPS: Syntax |
USER_FILE_GROUP_EXPORT_INFO: Syntax |
USER_FILE_GROUP_FILES: Syntax |
USER_FILE_GROUP_TABLES: Syntax |
USER_FILE_GROUP_TABLESPACES: Syntax |
USER_FILE_GROUP_VERSIONS: Syntax |
USER_FLASHBACK_ARCHIVE: Syntax |
USER_FLASHBACK_ARCHIVE_TABLES: Syntax |
USER_FLASHBACK_TXN_REPORT: Syntax |
USER_FLASHBACK_TXN_STATE: Syntax |
USER_FREE_SPACE: Syntax |
USER_HISTOGRAMS: Syntax |
USER_IDENTIFIERS: Syntax |
USER_INDEXES: Syntax |
USER_INDEXTYPES: Syntax |
USER_INDEXTYPE_ARRAYTYPES: Syntax |
USER_INDEXTYPE_COMMENTS: Syntax |
USER_INDEXTYPE_OPERATORS: Syntax |
USER_IND_COLUMNS: Syntax |
USER_IND_EXPRESSIONS: Syntax |
USER_IND_PARTITIONS: Syntax |
USER_IND_PENDING_STATS: Syntax |
USER_IND_STATISTICS: Syntax |
USER_IND_SUBPARTITIONS: Syntax |
USER_INTERNAL_TRIGGERS: Syntax |
USER_JAVA_ARGUMENTS: Syntax |
USER_JAVA_CLASSES: Syntax |
USER_JAVA_COMPILER_OPTIONS: Syntax |
USER_JAVA_DERIVATIONS: Syntax |
USER_JAVA_FIELDS: Syntax |
USER_JAVA_IMPLEMENTS: Syntax |
USER_JAVA_INNERS: Syntax |
USER_JAVA_LAYOUTS: Syntax |
USER_JAVA_METHODS: Syntax |
USER_JAVA_NCOMPS: Syntax |
USER_JAVA_POLICY: Syntax |
USER_JAVA_RESOLVERS: Syntax |
USER_JAVA_THROWS: Syntax |
USER_JOBS: Syntax |
USER_JOIN_IND_COLUMNS: Syntax |
USER_LIBRARIES: Syntax |
USER_LOBS: Syntax |
USER_LOB_PARTITIONS: Syntax |
USER_LOB_SUBPARTITIONS: Syntax |
USER_LOB_TEMPLATES: Syntax |
USER_LOG_GROUPS: Syntax |
USER_LOG_GROUP_COLUMNS: Syntax |
USER_MEASURE_FOLDERS: Syntax |
USER_MEASURE_FOLDER_CONTENTS: Syntax |
USER_METHOD_PARAMS: Syntax |
USER_METHOD_RESULTS: Syntax |
USER_MINING_MODELS: Syntax |
USER_MINING_MODEL_ATTRIBUTES: Syntax |
USER_MINING_MODEL_SETTINGS: Syntax |
USER_MVIEWS: Syntax |
USER_MVIEW_AGGREGATES: Syntax |
USER_MVIEW_ANALYSIS: Syntax |
USER_MVIEW_COMMENTS: Syntax |
USER_MVIEW_DETAIL_PARTITION: Syntax |
USER_MVIEW_DETAIL_RELATIONS: Syntax |
USER_MVIEW_DETAIL_SUBPARTITION: Syntax |
USER_MVIEW_JOINS: Syntax |
USER_MVIEW_KEYS: Syntax |
USER_MVIEW_LOGS: Syntax |
USER_MVIEW_REFRESH_TIMES: Syntax |
USER_NESTED_TABLES: Syntax |
USER_NESTED_TABLE_COLS: Syntax |
USER_NETWORK_ACL_PRIVILEGES: Syntax |
USER_OBJECTS: Syntax |
USER_OBJECTS_AE: Syntax |
USER_OBJECT_SIZE: Syntax |
USER_OBJECT_TABLES: Syntax |
USER_OBJ_AUDIT_OPTS: Syntax |
USER_OBJ_COLATTRS: Syntax |
USER_OPANCILLARY: Syntax |
USER_OPARGUMENTS: Syntax |
USER_OPBINDINGS: Syntax |
USER_OPERATORS: Syntax |
USER_OPERATOR_COMMENTS: Syntax |
USER_OUTLINES: Syntax |
USER_OUTLINE_HINTS: Syntax |
USER_PARALLEL_EXECUTE_CHUNKS: Syntax |
USER_PARALLEL_EXECUTE_TASKS: Syntax |
USER_PARTIAL_DROP_TABS: Syntax |
USER_PART_COL_STATISTICS: Syntax |
USER_PART_HISTOGRAMS: Syntax |
USER_PART_INDEXES: Syntax |
USER_PART_KEY_COLUMNS: Syntax |
USER_PART_LOBS: Syntax |
USER_PART_TABLES: Syntax |
USER_PASSWORD_LIMITS: Syntax |
USER_PENDING_CONV_TABLES: Syntax |
USER_PLSQL_OBJECT_SETTINGS: Syntax |
USER_POLICIES: Syntax |
USER_POLICY_CONTEXTS: Syntax |
USER_POLICY_GROUPS: Syntax |
USER_PROCEDURES: Syntax |
USER_PROXIES: Syntax |
USER_PUBLISHED_COLUMNS: Syntax |
USER_QUEUES: Syntax |
USER_QUEUE_SCHEDULES: Syntax |
USER_QUEUE_SUBSCRIBERS: Syntax |
USER_QUEUE_TABLES: Syntax |
USER_RECYCLEBIN: Syntax |
USER_REFRESH: Syntax |
USER_REFRESH_CHILDREN: Syntax |
USER_REFS: Syntax |
USER_REGISTERED_MVIEWS: Syntax |
USER_REGISTRY: Syntax |
USER_RESOURCE_LIMITS: Syntax |
USER_RESUMABLE: Syntax |
USER_REWRITE_EQUIVALENCES: Syntax |
USER_ROLE_PRIVS: Syntax |
USER_RSRC_CONSUMER_GROUP_PRIVS: Syntax |
USER_RSRC_MANAGER_SYSTEM_PRIVS: Syntax |
USER_RULES: Syntax |
USER_RULE_SETS: Syntax |
USER_RULE_SET_RULES: Syntax |
USER_SCHEDULER_CHAINS: Syntax |
USER_SCHEDULER_CHAIN_RULES: Syntax |
USER_SCHEDULER_CHAIN_STEPS: Syntax |
USER_SCHEDULER_CREDENTIALS: Syntax |
USER_SCHEDULER_DB_DESTS: Syntax |
USER_SCHEDULER_DESTS: Syntax |
USER_SCHEDULER_FILE_WATCHERS: Syntax |
USER_SCHEDULER_GROUPS: Syntax |
USER_SCHEDULER_GROUP_MEMBERS: Syntax |
USER_SCHEDULER_JOBS: Syntax |
USER_SCHEDULER_JOB_ARGS: Syntax |
USER_SCHEDULER_JOB_DESTS: Syntax |
USER_SCHEDULER_JOB_LOG: Syntax |
USER_SCHEDULER_JOB_RUN_DETAILS: Syntax |
USER_SCHEDULER_NOTIFICATIONS: Syntax |
USER_SCHEDULER_PROGRAMS: Syntax |
USER_SCHEDULER_PROGRAM_ARGS: Syntax |
USER_SCHEDULER_REMOTE_JOBSTATE: Syntax |
USER_SCHEDULER_RUNNING_CHAINS: Syntax |
USER_SCHEDULER_RUNNING_JOBS: Syntax |
USER_SCHEDULER_SCHEDULES: Syntax |
USER_SECONDARY_OBJECTS: Syntax |
USER_SEC_RELEVANT_COLS: Syntax |
USER_SEGMENTS: Syntax |
USER_SEQUENCES: Syntax |
USER_SOURCE: Syntax |
USER_SOURCE_AE: Syntax |
USER_SOURCE_TABLES: Syntax |
USER_SQLJ_TYPES: Syntax |
USER_SQLJ_TYPE_ATTRS: Syntax |
USER_SQLJ_TYPE_METHODS: Syntax |
USER_SQLSET: Syntax |
USER_SQLSET_BINDS: Syntax |
USER_SQLSET_PLANS: Syntax |
USER_SQLSET_REFERENCES: Syntax |
USER_SQLSET_STATEMENTS: Syntax |
USER_SQLTUNE_BINDS: Syntax |
USER_SQLTUNE_PLANS: Syntax |
USER_SQLTUNE_RATIONALE_PLAN: Syntax |
USER_SQLTUNE_STATISTICS: Syntax |
USER_STAT_EXTENSIONS: Syntax |
USER_STORED_SETTINGS: Syntax |
USER_SUBPARTITION_TEMPLATES: Syntax |
USER_SUBPART_COL_STATISTICS: Syntax |
USER_SUBPART_HISTOGRAMS: Syntax |
USER_SUBPART_KEY_COLUMNS: Syntax |
USER_SUBSCRIBED_COLUMNS: Syntax |
USER_SUBSCRIBED_TABLES: Syntax |
USER_SUBSCRIPTIONS: Syntax |
USER_SUBSCR_REGISTRATIONS: Syntax |
USER_SYNONYMS: Syntax |
USER_SYS_PRIVS: Syntax |
USER_TABLES: Syntax |
USER_TABLESPACES: Syntax |
USER_TAB_COLS: Syntax |
USER_TAB_COLUMNS: Syntax |
USER_TAB_COL_STATISTICS: Syntax |
USER_TAB_COMMENTS: Syntax |
USER_TAB_HISTGRM_PENDING_STATS: Syntax |
USER_TAB_HISTOGRAMS: Syntax |
USER_TAB_MODIFICATIONS: Syntax |
USER_TAB_PARTITIONS: Syntax |
USER_TAB_PENDING_STATS: Syntax |
USER_TAB_PRIVS: Syntax |
USER_TAB_PRIVS_MADE: Syntax |
USER_TAB_PRIVS_RECD: Syntax |
USER_TAB_STATISTICS: Syntax |
USER_TAB_STATS_HISTORY: Syntax |
USER_TAB_STAT_PREFS: Syntax |
USER_TAB_SUBPARTITIONS: Syntax |
USER_TRANSFORMATIONS: Syntax |
USER_TRIGGERS: Syntax |
USER_TRIGGER_COLS: Syntax |
USER_TRIGGER_ORDERING: Syntax |
USER_TSTZ_TABLES: Syntax |
USER_TSTZ_TAB_COLS: Syntax |
USER_TS_QUOTAS: Syntax |
USER_TUNE_MVIEW: Syntax |
USER_TYPES: Syntax |
USER_TYPE_ATTRS: Syntax |
USER_TYPE_METHODS: Syntax |
USER_TYPE_VERSIONS: Syntax |
USER_UNUSED_COL_TABS: Syntax |
USER_UPDATABLE_COLUMNS: Syntax |
USER_USERS: Syntax |
USER_USTATS: Syntax |
USER_VARRAYS: Syntax |
USER_VIEWS: Syntax |
USER_VIEWS_AE: Syntax |
USER_WARNING_SETTINGS: Syntax |
USER_XML_INDEXES: Syntax |
USER_XML_SCHEMAS: Syntax |
USER_XML_TABLES: Syntax |
USER_XML_TAB_COLS: Syntax |
USER_XML_VIEWS: Syntax |
USER_XML_VIEW_COLS: Syntax |