Database

(Oracle) dictionary 조회

steloflute 2013. 9. 13. 23:30

Oracle dictionary 테이블 이름이 나온다.

 

select * from dictionary;

 

Oracle 10g:

 

TABLE_NAME COMMENTS
DBA_USERS Information about all users of the database
ALL_USERS Information about all users of the database
USER_ADVISOR_ACTIONS  
USER_ADVISOR_DIRECTIVES  
USER_ADVISOR_FINDINGS  
USER_ADVISOR_JOURNAL  
USER_ADVISOR_LOG  
USER_ADVISOR_OBJECTS  
USER_ADVISOR_PARAMETERS  
USER_ADVISOR_RATIONALE  
USER_ADVISOR_RECOMMENDATIONS  
USER_ADVISOR_SQLA_REC_SUM  
USER_ADVISOR_SQLA_WK_MAP  
USER_ADVISOR_SQLA_WK_STMTS  
USER_ADVISOR_SQLW_COLVOL  
USER_ADVISOR_SQLW_JOURNAL  
USER_ADVISOR_SQLW_PARAMETERS  
USER_ADVISOR_SQLW_STMTS  
USER_ADVISOR_SQLW_SUM  
USER_ADVISOR_SQLW_TABLES  
USER_ADVISOR_SQLW_TABVOL  
USER_ADVISOR_SQLW_TEMPLATES  
USER_ADVISOR_TASKS  
USER_ADVISOR_TEMPLATES  
USER_ALL_TABLES Description of all object and relational tables owned by the user's
USER_AQ_AGENT_PRIVS  
USER_ARGUMENTS Arguments in object accessible to the user
USER_ASSOCIATIONS All assocations defined by the user
USER_ATTRIBUTE_TRANSFORMATIONS  
USER_AUDIT_OBJECT Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
USER_AUDIT_POLICIES All fine grained auditing policies for objects in user schema
USER_AUDIT_POLICY_COLUMNS Users fine grained auditing policy columns in the database
USER_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system
USER_AUDIT_TRAIL Audit trail entries relevant to the user
USER_AWS Analytic Workspaces owned by the user
USER_AW_PS Pagespaces in Analytic Workspaces owned by the user
USER_BASE_TABLE_MVIEWS All materialized views with log(s) owned by the user in the database
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user
USER_CHANGE_NOTIFICATION_REGS change notification registrations for current user
USER_CLUSTERS Descriptions of user's own clusters
USER_CLUSTER_HASH_EXPRESSIONS Hash functions for the user's hash clusters
USER_CLU_COLUMNS Mapping of table columns to cluster columns
USER_COLL_TYPES Description of the user's own named collection types
USER_COL_COMMENTS Comments on columns of user's tables and views
USER_COL_PRIVS Grants on columns for which the user is the owner, grantor or grantee
USER_COL_PRIVS_MADE All grants on columns of objects owned by the user
USER_COL_PRIVS_RECD Grants on columns for which the user is the grantee
USER_CONSTRAINTS Constraint definitions on user's own tables
USER_CONS_COLUMNS Information about accessible columns in constraint definitions
USER_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables owned by the user
USER_DATAPUMP_JOBS Datapump jobs for current user
USER_DB_LINKS Database links owned by the user
USER_DEPENDENCIES Dependencies to and from a users objects
USER_DIMENSIONS Description of the dimension objects accessible to the DBA
USER_DIM_ATTRIBUTES Representation of the relationship between a dimension level and a functionally dependent column
USER_DIM_CHILD_OF Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
USER_DIM_HIERARCHIES Representation of a dimension hierarchy
USER_DIM_JOIN_KEY Representation of a join between two dimension tables.
USER_DIM_LEVELS Description of dimension levels visible to DBA
USER_DIM_LEVEL_KEY Representations of columns of a dimension level
USER_ENCRYPTED_COLUMNS Encryption information on columns of tables owned by the user
USER_ERRORS Current errors on stored objects owned by the user
USER_EVALUATION_CONTEXTS rule evaluation contexts owned by user
USER_EVALUATION_CONTEXT_TABLES tables in user rule evaluation contexts
USER_EVALUATION_CONTEXT_VARS variables in user rule evaluation contexts
USER_EXTENTS Extents comprising segments owned by the user
USER_EXTERNAL_LOCATIONS Description of the user's external tables locations
USER_EXTERNAL_TABLES Description of the user's own external tables
USER_FILE_GROUPS Details about file groups
USER_FILE_GROUP_EXPORT_INFO Details about export information of file group versions
USER_FILE_GROUP_FILES Details about file group files
USER_FILE_GROUP_TABLES Details about the tables in the file group repository
USER_FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
USER_FILE_GROUP_VERSIONS Details about file group versions
USER_FREE_SPACE Free extents in tablespaces accessible to the user
USER_INDEXES Description of the user's own indexes
USER_INDEXTYPES All user indextypes
USER_INDEXTYPE_ARRAYTYPES All array types specified by the indextype
USER_INDEXTYPE_COMMENTS Comments for user-defined indextypes
USER_INDEXTYPE_OPERATORS All user indextype operators
USER_IND_COLUMNS COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
USER_IND_EXPRESSIONS Functional index expressions in user's indexes and indexes on user's tables
USER_IND_PARTITIONS  
USER_IND_STATISTICS Optimizer statistics for user's own indexes
USER_IND_SUBPARTITIONS  
USER_INTERNAL_TRIGGERS Description of the internal triggers on the user's own tables
USER_JAVA_ARGUMENTS argument information of stored java class owned by the user
USER_JAVA_CLASSES class level information of stored java class owned by the user
USER_JAVA_DERIVATIONS this view maps java source objects and their derived java class objects and java resource objects for the java class owned by user
USER_JAVA_FIELDS field information of stored java class owned by the user
USER_JAVA_IMPLEMENTS interfaces implemented by the stored java class owned by user
USER_JAVA_INNERS list of inner classes refered by the stored java class owned by user
USER_JAVA_LAYOUTS class layout information about stored java class owned by the user
USER_JAVA_METHODS method information of stored java class owned by the user
USER_JAVA_NCOMPS ncomp related information of java classes owned by user
USER_JAVA_POLICY java security Permissions for current user
USER_JAVA_RESOLVERS resolver of java class owned by user
USER_JAVA_THROWS list of exceptions thrown from a method of a class owned by user
USER_JOBS All jobs owned by this user
USER_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
USER_LIBRARIES Description of the user's own libraries
USER_LOBS Description of the user's own LOBs contained in the user's own tables
USER_LOB_PARTITIONS  
USER_LOB_SUBPARTITIONS  
USER_LOB_TEMPLATES  
USER_LOG_GROUPS Log group definitions on user's own tables
USER_LOG_GROUP_COLUMNS Information about columns in log group definitions
USER_METHOD_PARAMS Description of method parameters of the user's own types
USER_METHOD_RESULTS Description of method results of the user's own types
USER_MVIEWS All materialized views in the database
USER_MVIEW_AGGREGATES Description of the materialized view aggregates created by the user
USER_MVIEW_ANALYSIS Description of the materialized views created by the user
USER_MVIEW_COMMENTS Comments on materialized views owned by the user
USER_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables of the materialized views created by the user
USER_MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view created by the user
USER_MVIEW_KEYS Description of the columns that appear in the GROUP BY list of a materialized view created by the user
USER_MVIEW_LOGS All materialized view logs owned by the user
USER_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
USER_NESTED_TABLES Description of nested tables contained in the user's own tables
USER_NESTED_TABLE_COLS Columns of nested tables
USER_OBJECTS Objects owned by the user
USER_OBJECT_SIZE Sizes, in bytes, of various pl/sql objects
USER_OBJECT_TABLES Description of the user's own object tables
USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views with atleast one option set
USER_OBJ_COLATTRS Description of object columns and attributes contained in tables owned by the user
USER_OLDIMAGE_COLUMNS Gives all object tables and columns in old (8.0) image format
USER_OPANCILLARY All ancillary opertors defined by user
USER_OPARGUMENTS All operator arguments of operators defined by user
USER_OPBINDINGS All binding functions or methods on operators defined by the user
USER_OPERATORS All user operators
USER_OPERATOR_COMMENTS Comments for user-defined operators
USER_OUTLINES Stored outlines owned by the user
USER_OUTLINE_HINTS Hints stored in outlines owned by the user
USER_PARTIAL_DROP_TABS User tables with unused columns
USER_PART_COL_STATISTICS  
USER_PART_HISTOGRAMS  
USER_PART_INDEXES  
USER_PART_KEY_COLUMNS  
USER_PART_LOBS  
USER_PART_TABLES  
USER_PASSWORD_LIMITS Display password limits of the user
USER_PENDING_CONV_TABLES All user's tables which are not upgraded to the latest type version
USER_PLSQL_OBJECT_SETTINGS Compiler settings of stored objects owned by the user
USER_POLICIES All row level security policies for synonyms, tables, or views owned by the user
USER_POLICY_CONTEXTS All policy driving context defined for synonyms, tables, or views in current schema
USER_POLICY_GROUPS All policy groups defined for any synonym, table, or view
USER_PROCEDURES Description of the user functions/procedures/packages/types/triggers
USER_PROXIES Description of connections the user is allowed to proxy
USER_PUBLISHED_COLUMNS Source columns available for Change Data Capture
USER_QUEUES All queues owned by the user
USER_QUEUE_PUBLISHERS  
USER_QUEUE_SCHEDULES  
USER_QUEUE_SUBSCRIBERS queue subscribers under a user'schema
USER_QUEUE_TABLES All queue tables created by the user
USER_RECYCLEBIN User view of his recyclebin
USER_REFRESH All the refresh groups
USER_REFRESH_CHILDREN All the objects in refresh groups, where the user owns the refresh group
USER_REFS Description of the user's own REF columns contained in the user's own tables
USER_REGISTERED_MVIEWS Remote materialized views of local tables currently using logs owned by the user
USER_REGISTERED_SNAPSHOTS Remote snapshots of local tables currently using logs owned by the user
USER_REGISTRY  
USER_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
USER_REPAUDIT_COLUMN Information about columns in all shadow tables for user's replicated tables
USER_REPCAT  
USER_REPCATLOG Information about the current user's asynchronous administration requests
USER_REPCOLUMN Replicated columns for the current user's table in ascending order
USER_REPCOLUMN_GROUP All column groups of user's replicated tables
USER_REPCONFLICT  
USER_REPDDL Arguments that do not fit in a single repcat log record
USER_REPFLAVORS Flavors current user created for replicated object groups
USER_REPFLAVOR_COLUMNS Replicated columns from current user's tables in flavors
USER_REPFLAVOR_OBJECTS Replicated user objects in flavors
USER_REPGENERATED Objects generated for the current user to support replication
USER_REPGENOBJECTS Objects generated for the current user to support replication
USER_REPGROUP Replication information about the current user
USER_REPGROUPED_COLUMN Columns in the all column groups of user's replicated tables
USER_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
USER_REPKEY_COLUMNS Primary columns for a table using column-level replication
USER_REPOBJECT Replication information about the current user's objects
USER_REPPARAMETER_COLUMN All columns used for resolving conflicts in user's replicated tables
USER_REPPRIORITY Values and their corresponding priorities in user's priority groups
USER_REPPRIORITY_GROUP Information about user's priority groups
USER_REPPROP Propagation information about the current user's objects
USER_REPRESOLUTION Description of all conflict resolutions for user's replicated tables
USER_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
USER_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for user's replicated tables
USER_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for user's replicated tables
USER_REPSCHEMA N-way replication information about the current user
USER_REPSITES N-way replication information about the current user
USER_RESOURCE_LIMITS Display resource limit of the user
USER_RESUMABLE Resumable session information for current user
USER_REWRITE_EQUIVALENCES Description of all rewrite equivalence owned by the user
USER_ROLE_PRIVS Roles granted to current user
USER_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups for the user
USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
USER_RULES Rules owned by the user
USER_RULESETS Rulesets owned by the user: maintained for backward compatibility
USER_RULE_SETS Rule sets owned by the user
USER_RULE_SET_RULES Rules in user rule sets
USER_SCHEDULER_CHAINS All scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_RULES All rules from scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_STEPS All steps of scheduler chains owned by the current user
USER_SCHEDULER_JOBS All scheduler jobs in the database
USER_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
USER_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
USER_SCHEDULER_JOB_RUN_DETAILS The details of a job run
USER_SCHEDULER_PROGRAMS Scheduler programs owned by the current user
USER_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs in the database
USER_SCHEDULER_RUNNING_CHAINS All steps of chains being run by jobs owned by the current user
USER_SCHEDULER_SCHEDULES Schedules belonging to the current user
USER_SECONDARY_OBJECTS All secondary objects for domain indexes
USER_SEC_RELEVANT_COLS Security Relevant columns of VPD policies for tables or views owned by the user
USER_SEGMENTS Storage allocated for all database segments
USER_SEQUENCES Description of the user's own SEQUENCEs
USER_SNAPSHOTS Snapshots the user can look at
USER_SNAPSHOT_LOGS All snapshot logs owned by the user
USER_SOURCE Source of stored objects accessible to the user
USER_SOURCE_TABLES Source tables available for Change Data Capture
USER_SQLJ_TYPES Description of the user's own types
USER_SQLJ_TYPE_ATTRS Description of attributes of the user's own types
USER_SQLJ_TYPE_METHODS Description of methods of the user's own types
USER_SQLSET  
USER_SQLSET_BINDS  
USER_SQLSET_PLANS  
USER_SQLSET_REFERENCES  
USER_SQLSET_STATEMENTS  
USER_SQLTUNE_BINDS  
USER_SQLTUNE_PLANS  
USER_SQLTUNE_RATIONALE_PLAN  
USER_SQLTUNE_STATISTICS  
USER_STORED_SETTINGS Parameter settings for objects owned by the user
USER_SUBPARTITION_TEMPLATES  
USER_SUBPART_COL_STATISTICS  
USER_SUBPART_HISTOGRAMS  
USER_SUBPART_KEY_COLUMNS  
USER_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
USER_SUBSCRIBED_TABLES Change Data Capture subscribed tables
USER_SUBSCRIPTIONS Change Data Capture subscriptions
USER_SUMMARIES Description of the summaries created by the user
USER_SYNONYMS The user's private synonyms
USER_SYS_PRIVS System privileges granted to current user
USER_TABLES Description of the user's own relational tables
USER_TABLESPACES Description of accessible tablespaces
USER_TAB_COLS Columns of user's tables, views and clusters
USER_TAB_COLUMNS Columns of user's tables, views and clusters
USER_TAB_COL_STATISTICS Columns of user's tables, views and clusters
USER_TAB_COMMENTS Comments on the tables and views owned by the user
USER_TAB_HISTOGRAMS Histograms on columns of user's tables
USER_TAB_MODIFICATIONS Information regarding modifications to tables
USER_TAB_PARTITIONS  
USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE All grants on objects owned by the user
USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee
USER_TAB_STATISTICS Optimizer statistics of the user's own tables
USER_TAB_STATS_HISTORY History of table statistics modifications
USER_TAB_SUBPARTITIONS  
USER_TRANSFORMATIONS  
USER_TRIGGERS Triggers owned by the user
USER_TRIGGER_COLS Column usage in user's triggers
USER_TS  
USER_TS_QUOTAS Tablespace quotas for the user
USER_TUNE_MVIEW tune_mview catalog view owned by the user
USER_TYPES Description of the user's own types
USER_TYPE_ATTRS Description of attributes of the user's own types
USER_TYPE_METHODS Description of methods of the user's own types
USER_TYPE_VERSIONS Description of each version of the user's types
USER_UNUSED_COL_TABS User tables with unused columns
USER_UPDATABLE_COLUMNS Description of updatable columns
USER_USERS Information about the current user
USER_USTATS All statistics on tables or indexes owned by the user
USER_VARRAYS Description of varrays contained in the user's own tables
USER_VIEWS Description of the user's own views
USER_WARNING_SETTINGS Warning Parameter settings for objects owned by the user
GV$PWFILE_USERS Synonym for GV_$PWFILE_USERS
USER_HISTOGRAMS Synonym for USER_TAB_HISTOGRAMS
USER_SNAPSHOT_REFRESH_TIMES Synonym for USER_MVIEW_REFRESH_TIMES
USER_SQLSET_DEFINITIONS Synonym for USER_SQLSET
V$PWFILE_USERS Synonym for V_$PWFILE_USERS