(Oracle) dictionary 조회

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