Oracle DICTIONARY

DICTIONARY

No	TABLE_NAME	COMMENTS
1	ALL_ALL_TABLES	Description of all object and relational tables accessible to the user
2	ALL_ARGUMENTS	Arguments in object accessible to the user
3	ALL_ASSOCIATIONS	All associations available to the user
4	ALL_CATALOG	All tables, views, synonyms, sequences accessible to the user
5	ALL_CLUSTERS	Description of clusters accessible to the user
6	ALL_CLUSTER_HASH_EXPRESSIONS	Hash functions for all accessible clusters
7	ALL_COLL_TYPES	Description of named collection types accessible to the user
8	ALL_COL_COMMENTS	Comments on columns of accessible tables and views
9	ALL_COL_PRIVS	Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
10	ALL_COL_PRIVS_MADE	Grants on columns for which the user is owner or grantor
11	ALL_COL_PRIVS_RECD	Grants on columns for which the user, PUBLIC or enabled role is the grantee
12	ALL_CONSTRAINTS	Constraint definitions on accessible tables
13	ALL_CONS_COLUMNS	Information about accessible columns in constraint definitions
14	ALL_CONTEXT	Description of all active context namespaces under the current session
15	ALL_DB_LINKS	Database links accessible to the user
16	ALL_DEF_AUDIT_OPTS	Auditing options for newly created objects
17	ALL_DEPENDENCIES	Dependencies to and from objects accessible to the user
18	ALL_DIMENSIONS	Description of the dimension objects accessible to the DBA
19	ALL_DIM_ATTRIBUTES	Representation of the relationship between a dimension level and a functionally dependent column
20	ALL_DIM_CHILD_OF	Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
21	ALL_DIM_HIERARCHIES	Representation of a dimension hierarchy
22	ALL_DIM_JOIN_KEY	Representation of a join between two dimension tables.
23	ALL_DIM_LEVELS	Description of dimension levels visible to DBA
24	ALL_DIM_LEVEL_KEY	Representations of columns of a dimension level
25	ALL_DIRECTORIES	Description of all directories accessible to the user
26	ALL_ERRORS	Current errors on stored objects that user is allowed to create
27	ALL_HISTOGRAMS	Synonym for ALL_TAB_HISTOGRAMS
28	ALL_INDEXES	Descriptions of indexes on tables accessible to the user
29	ALL_INDEXTYPES	All indextypes available to the user
30	ALL_INDEXTYPE_OPERATORS	All operators available to the user
31	ALL_IND_COLUMNS	COLUMNs comprising INDEXes on accessible TABLES
32	ALL_IND_EXPRESSIONS	FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
33	ALL_IND_PARTITIONS
34	ALL_IND_SUBPARTITIONS
35	ALL_INTERNAL_TRIGGERS	Description of the internal triggers on the tables accessible to the user
36	ALL_JOBS	Synonym for USER_JOBS
37	ALL_LIBRARIES	Description of libraries accessible to the user
38	ALL_LOBS	Description of LOBs contained in tables accessible to the user
39	ALL_LOB_PARTITIONS
40	ALL_LOB_SUBPARTITIONS
41	ALL_METHOD_PARAMS	Description of method parameters of types accessible to the user
42	ALL_METHOD_RESULTS	Description of method results of types accessible to the user
43	ALL_MVIEWS	All materialized views in the database
44	ALL_MVIEW_AGGREGATES	Description of the materialized view aggregates accessible to the user
45	ALL_MVIEW_ANALYSIS	Description of the materialized views accessible to the user
46	ALL_MVIEW_DETAIL_RELATIONS	Description of the materialized view detail tables accessible to the user
47	ALL_MVIEW_JOINS	Description of a join between two columns in the WHERE clause of a materialized view accessible to the user
48	ALL_MVIEW_KEYS	Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user
49	ALL_NESTED_TABLES	Description of nested tables in tables accessible to the user
50	ALL_OBJECTS	Objects accessible to the user
51	ALL_OBJECT_TABLES	Description of all object tables accessible to the user
52	ALL_OPANCILLARY	All ancillary operators available to the user
53	ALL_OPARGUMENTS	All arguments of the operators available to the user
54	ALL_OPBINDINGS	All binding functions for operators available to the user
55	ALL_OPERATORS	All operators available to the user
56	ALL_OUTLINES	Synonym for USER_OUTLINES
57	ALL_OUTLINE_HINTS	Synonym for USER_OUTLINE_HINTS
58	ALL_PARTIAL_DROP_TABS	All tables with patially dropped columns accessible to the user
59	ALL_PART_COL_STATISTICS
60	ALL_PART_HISTOGRAMS
61	ALL_PART_INDEXES
62	ALL_PART_KEY_COLUMNS
63	ALL_PART_LOBS
64	ALL_PART_TABLES
65	ALL_POLICIES	All policies for objects if the user has system privileges or owns the objects
66	ALL_PROBE_OBJECTS
67	ALL_QUEUES	All queues accessible to the user
68	ALL_QUEUE_TABLES	All queue tables accessible to the user
69	ALL_REFRESH	All the refresh groups that the user can touch
70	ALL_REFRESH_CHILDREN	All the objects in refresh groups, where the user can touch the group
71	ALL_REFRESH_DEPENDENCIES	Description of the detail tables that materialized views depend on for refresh
72	ALL_REFS	Description of REF columns contained in tables accessible to the user
73	ALL_REGISTERED_SNAPSHOTS	Remote snapshots of local tables that the user can see
74	ALL_SEQUENCES	Description of SEQUENCEs accessible to the user
75	ALL_SNAPSHOTS	Snapshots the user can access
76	ALL_SNAPSHOT_LOGS	All snapshot logs in the database that the user can see
77	ALL_SNAPSHOT_REFRESH_TIMES	Snapshots and their last refresh times for each master table that the user can look at
78	ALL_SOURCE	Current source on stored objects that user is allowed to create
79	ALL_SUBPART_COL_STATISTICS
80	ALL_SUBPART_HISTOGRAMS
81	ALL_SUBPART_KEY_COLUMNS
82	ALL_SUMDELTA	Direct path load entries accessible to the user
83	ALL_SUMMARIES	Description of the summaries accessible to the user
84	ALL_SYNONYMS	All synonyms accessible to the user
85	ALL_TABLES	Description of relational tables accessible to the user
86	ALL_TAB_COLUMNS	Columns of user's tables, views and clusters
87	ALL_TAB_COL_STATISTICS	Columns of user's tables, views and clusters
88	ALL_TAB_COMMENTS	Comments on tables and views accessible to the user
89	ALL_TAB_HISTOGRAMS	Histograms on columns of all tables visible to user
90	ALL_TAB_MODIFICATIONS	Information regarding modifications to tables
91	ALL_TAB_PARTITIONS
92	ALL_TAB_PRIVS	Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
93	ALL_TAB_PRIVS_MADE	User's grants and grants on user's objects
94	ALL_TAB_PRIVS_RECD	Grants on objects for which the user, PUBLIC or enabled role is the grantee
95	ALL_TAB_SUBPARTITIONS
96	ALL_TRIGGERS	Triggers accessible to the current user
97	ALL_TRIGGER_COLS	Column usage in user's triggers or in triggers on user's tables
98	ALL_TYPES	Description of types accessible to the user
99	ALL_TYPE_ATTRS	Description of attributes of types accessible to the user
100	ALL_TYPE_METHODS	Description of methods of types accessible to the user
101	ALL_UNUSED_COL_TABS	All tables with unused columns accessible to the user
102	ALL_UPDATABLE_COLUMNS	Description of all updatable columns
103	ALL_USERS	Information about all users of the database
104	ALL_USTATS	All statistics
105	ALL_VARRAYS	Description of varrays in tables accessible to the user
106	ALL_VIEWS	Description of views accessible to the user
107	AUDIT_ACTIONS	Description table for audit trail action type codes. Maps action type numbers to action type names
108	CAT	Synonym for USER_CATALOG
109	CLU	Synonym for USER_CLUSTERS
110	COLS	Synonym for USER_TAB_COLUMNS
111	COLUMN_PRIVILEGES	Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
112	DATABASE_COMPATIBLE_LEVEL	Database compatible parameter set via init.ora
113	DBMS_ALERT_INFO
114	DBMS_LOCK_ALLOCATED
115	DICT	Synonym for DICTIONARY
116	DICTIONARY	Description of data dictionary tables and views
117	DICT_COLUMNS	Description of columns in data dictionary tables and views
118	DUAL
119	GLOBAL_NAME	global database name
120	GV$ACTIVE_INSTANCES	Synonym for GV_$ACTIVE_INSTANCES
121	GV$BH	Synonym for GV_$BH
122	GV$LOADCSTAT	Synonym for GV_$LOADCSTAT
123	GV$LOADISTAT	Synonym for GV_$LOADISTAT
124	GV$LOADPSTAT	Synonym for GV_$LOADPSTAT
125	GV$LOADTSTAT	Synonym for GV_$LOADTSTAT
126	GV$LOCK_ACTIVITY	Synonym for GV_$LOCK_ACTIVITY
127	GV$MAX_ACTIVE_SESS_TARGET_MTH	Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH
128	GV$MLS_PARAMETERS	Synonym for GV_$MLS_PARAMETERS
129	GV$NLS_PARAMETERS	Synonym for GV_$NLS_PARAMETERS
130	GV$NLS_VALID_VALUES	Synonym for GV_$NLS_VALID_VALUES
131	GV$OPTION	Synonym for GV_$OPTION
132	GV$PARALLEL_DEGREE_LIMIT_MTH	Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH
133	GV$PQ_SESSTAT	Synonym for GV_$PQ_SESSTAT
134	GV$PQ_TQSTAT	Synonym for GV_$PQ_TQSTAT
135	GV$RSRC_CONSUMER_GROUP	Synonym for GV_$RSRC_CONSUMER_GROUP
136	GV$RSRC_CONSUMER_GROUP_CPU_MTH	Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH
137	GV$RSRC_PLAN	Synonym for GV_$RSRC_PLAN
138	GV$RSRC_PLAN_CPU_MTH	Synonym for GV_$RSRC_PLAN_CPU_MTH
139	GV$SESSION_LONGOPS	Synonym for GV_$SESSION_LONGOPS
140	GV$TEMPORARY_LOBS	Synonym for GV_$TEMPORARY_LOBS
141	GV$VERSION	Synonym for GV_$VERSION
142	IND	Synonym for USER_INDEXES
143	INDEX_HISTOGRAM	statistics on keys with repeat count
144	INDEX_STATS	statistics on the b-tree
145	NLS_DATABASE_PARAMETERS	Permanent NLS parameters of the database
146	NLS_INSTANCE_PARAMETERS	NLS parameters of the instance
147	NLS_SESSION_PARAMETERS	NLS parameters of the user session
148	OBJ	Synonym for USER_OBJECTS
149	RESOURCE_COST	Cost for each resource
150	ROLE_ROLE_PRIVS	Roles which are granted to roles
151	ROLE_SYS_PRIVS	System privileges granted to roles
152	ROLE_TAB_PRIVS	Table privileges granted to roles
153	SEQ	Synonym for USER_SEQUENCES
154	SESSION_PRIVS	Privileges which the user currently has set
155	SESSION_ROLES	Roles which the user currently has enabled.
156	SM$VERSION	Synonym for SM_$VERSION
157	SYN	Synonym for USER_SYNONYMS
158	TABLE_PRIVILEGES	Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
159	TABS	Synonym for USER_TABLES
160	USER_ALL_TABLES	Description of all object and relational tables owned by the user's
161	USER_ARGUMENTS	Arguments in object accessible to the user
162	USER_ASSOCIATIONS	All assocations defined by the user
163	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
164	USER_AUDIT_SESSION	All audit trail records concerning CONNECT and DISCONNECT
165	USER_AUDIT_STATEMENT	Audit trail records concerning grant, revoke, audit, noaudit and alter system
166	USER_AUDIT_TRAIL	Audit trail entries relevant to the user
167	USER_CATALOG	Tables, Views, Synonyms and Sequences owned by the user
168	USER_CLUSTERS	Descriptions of user's own clusters
169	USER_CLUSTER_HASH_EXPRESSIONS	Hash functions for the user's hash clusters
170	USER_CLU_COLUMNS	Mapping of table columns to cluster columns
171	USER_COLL_TYPES	Description of the user's own named collection types
172	USER_COL_COMMENTS	Comments on columns of user's tables and views
173	USER_COL_PRIVS	Grants on columns for which the user is the owner, grantor or grantee
174	USER_COL_PRIVS_MADE	All grants on columns of objects owned by the user
175	USER_COL_PRIVS_RECD	Grants on columns for which the user is the grantee
176	USER_CONSTRAINTS	Constraint definitions on user's own tables
177	USER_CONS_COLUMNS	Information about accessible columns in constraint definitions
178	USER_DB_LINKS	Database links owned by the user
179	USER_DEPENDENCIES	Dependencies to and from a users objects
180	USER_DIMENSIONS	Description of the dimension objects accessible to the DBA
181	USER_DIM_ATTRIBUTES	Representation of the relationship between a dimension level and a functionally dependent column
182	USER_DIM_CHILD_OF	Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
183	USER_DIM_HIERARCHIES	Representation of a dimension hierarchy
184	USER_DIM_JOIN_KEY	Representation of a join between two dimension tables.
185	USER_DIM_LEVELS	Description of dimension levels visible to DBA
186	USER_DIM_LEVEL_KEY	Representations of columns of a dimension level
187	USER_ERRORS	Current errors on stored objects owned by the user
188	USER_EXTENTS	Extents comprising segments owned by the user
189	USER_FREE_SPACE	Free extents in tablespaces accessible to the user
190	USER_HISTOGRAMS	Synonym for USER_TAB_HISTOGRAMS
191	USER_INDEXES	Description of the user's own indexes
192	USER_INDEXTYPES	All user indextypes
193	USER_INDEXTYPE_OPERATORS	All user indextype operators
194	USER_IND_COLUMNS	COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
195	USER_IND_EXPRESSIONS	Functional index expressions in user's indexes and indexes on user's tables
196	USER_IND_PARTITIONS
197	USER_IND_SUBPARTITIONS
198	USER_INTERNAL_TRIGGERS	Description of the internal triggers on the user's own tables
199	USER_JAVA_POLICY	java security Permissions for current user
200	USER_JOBS	All jobs owned by this user
201	USER_LIBRARIES	Description of the user's own libraries
202	USER_LOBS	Description of the user's own LOBs contained in the user's own tables
203	USER_LOB_PARTITIONS
204	USER_LOB_SUBPARTITIONS
205	USER_METHOD_PARAMS	Description of method parameters of the user's own types
206	USER_METHOD_RESULTS	Description of method results of the user's own types
207	USER_MVIEWS	All materialized views in the database
208	USER_MVIEW_AGGREGATES	Description of the materialized view aggregates created by the user
209	USER_MVIEW_ANALYSIS	Description of the materialized views created by the user
210	USER_MVIEW_DETAIL_RELATIONS	Description of the materialized view detail tables of the materialized views created by the user
211	USER_MVIEW_JOINS	Description of a join between two columns in the WHERE clause of a materialized view created by the user
212	USER_MVIEW_KEYS	Description of the columns that appear in the GROUP BY list of a materialized view created by the user
213	USER_NESTED_TABLES	Description of nested tables contained in the user's own tables
214	USER_OBJECTS	Objects owned by the user
215	USER_OBJECT_SIZE	Sizes, in bytes, of various pl/sql objects
216	USER_OBJECT_TABLES	Description of the user's own object tables
217	USER_OBJ_AUDIT_OPTS	Auditing options for user's own tables and views
218	USER_OPANCILLARY	All ancillary opertors defined by user
219	USER_OPARGUMENTS	All operator arguments of operators defined by user
220	USER_OPBINDINGS	All binding functions or methods on operators defined by the user
221	USER_OPERATORS	All user operators
222	USER_OUTLINES	Stored outlines owned by the user
223	USER_OUTLINE_HINTS	Hints stored in outlines owned by the user
224	USER_PARTIAL_DROP_TABS	User tables with unused columns
225	USER_PART_COL_STATISTICS
226	USER_PART_HISTOGRAMS
227	USER_PART_INDEXES
228	USER_PART_KEY_COLUMNS
229	USER_PART_LOBS
230	USER_PART_TABLES
231	USER_PASSWORD_LIMITS	Display password limits of the user
232	USER_POLICIES	All row level security policies for tables or views owned by the user
233	USER_QUEUES	All queues owned by the user
234	USER_QUEUE_SCHEDULES
235	USER_QUEUE_TABLES	All queue tables created by the user
236	USER_REFRESH	All the refresh groups
237	USER_REFRESH_CHILDREN	All the objects in refresh groups, where the user owns the refresh group
238	USER_REFS	Description of the user's own REF columns contained in the user's own tables
239	USER_REGISTERED_SNAPSHOTS	Remote snapshots of local tables currently using logs owned by the user
240	USER_RESOURCE_LIMITS	Display resource limit of the user
241	USER_ROLE_PRIVS	Roles granted to current user
242	USER_RSRC_CONSUMER_GROUP_PRIVS	Switch privileges for consumer groups for the user
243	USER_RSRC_MANAGER_SYSTEM_PRIVS	system privileges for the resource manager for the user
244	USER_RULESETS	Rulesets owned by the user
245	USER_SEGMENTS	Storage allocated for all database segments
246	USER_SEQUENCES	Description of the user's own SEQUENCEs
247	USER_SNAPSHOTS	Snapshots the user can look at
248	USER_SNAPSHOT_LOGS	All snapshot logs owned by the user
249	USER_SNAPSHOT_REFRESH_TIMES	Snapshots and their last refresh times for each master table that the user can look at
250	USER_SOURCE	Source of stored objects accessible to the user
251	USER_SUBPART_COL_STATISTICS
252	USER_SUBPART_HISTOGRAMS
253	USER_SUBPART_KEY_COLUMNS
254	USER_SUMMARIES	Description of the summaries created by the user
255	USER_SYNONYMS	The user's private synonyms
256	USER_SYS_PRIVS	System privileges granted to current user
257	USER_TABLES	Description of the user's own relational tables
258	USER_TABLESPACES	Description of accessible tablespaces
259	USER_TAB_COLUMNS	Columns of user's tables, views and clusters
260	USER_TAB_COL_STATISTICS	Columns of user's tables, views and clusters
261	USER_TAB_COMMENTS	Comments on the tables and views owned by the user
262	USER_TAB_HISTOGRAMS	Histograms on columns of user's tables
263	USER_TAB_MODIFICATIONS	Information regarding modifications to tables
264	USER_TAB_PARTITIONS
265	USER_TAB_PRIVS	Grants on objects for which the user is the owner, grantor or grantee
266	USER_TAB_PRIVS_MADE	All grants on objects owned by the user
267	USER_TAB_PRIVS_RECD	Grants on objects for which the user is the grantee
268	USER_TAB_SUBPARTITIONS
269	USER_TRIGGERS	Triggers owned by the user
270	USER_TRIGGER_COLS	Column usage in user's triggers
271	USER_TS_QUOTAS	Tablespace quotas for the user
272	USER_TYPES	Description of the user's own types
273	USER_TYPE_ATTRS	Description of attributes of the user's own types
274	USER_TYPE_METHODS	Description of methods of the user's own types
275	USER_UNUSED_COL_TABS	User tables with unused columns
276	USER_UPDATABLE_COLUMNS	Description of updatable columns
277	USER_USERS	Information about the current user
278	USER_USTATS	All statistics on tables or indexes owned by the user
279	USER_VARRAYS	Description of varrays contained in the user's own tables
280	USER_VIEWS	Description of the user's own views
281	V$ACTIVE_INSTANCES	Synonym for V_$ACTIVE_INSTANCES
282	V$BH	Synonym for V_$BH
283	V$LOADCSTAT	Synonym for V_$LOADCSTAT
284	V$LOADISTAT	Synonym for V_$LOADISTAT
285	V$LOADPSTAT	Synonym for V_$LOADPSTAT
286	V$LOADTSTAT	Synonym for V_$LOADTSTAT
287	V$LOCK_ACTIVITY	Synonym for V_$LOCK_ACTIVITY
288	V$MAX_ACTIVE_SESS_TARGET_MTH	Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH
289	V$MLS_PARAMETERS	Synonym for V_$MLS_PARAMETERS
290	V$NLS_PARAMETERS	Synonym for V_$NLS_PARAMETERS
291	V$NLS_VALID_VALUES	Synonym for V_$NLS_VALID_VALUES
292	V$OPTION	Synonym for V_$OPTION
293	V$PARALLEL_DEGREE_LIMIT_MTH	Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH
294	V$PQ_SESSTAT	Synonym for V_$PQ_SESSTAT
295	V$PQ_TQSTAT	Synonym for V_$PQ_TQSTAT
296	V$RSRC_CONSUMER_GROUP	Synonym for V_$RSRC_CONSUMER_GROUP
297	V$RSRC_CONSUMER_GROUP_CPU_MTH	Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH
298	V$RSRC_PLAN	Synonym for V_$RSRC_PLAN
299	V$RSRC_PLAN_CPU_MTH	Synonym for V_$RSRC_PLAN_CPU_MTH
300	V$SESSION_CONNECT_INFO	Synonym for V_$SESSION_CONNECT_INFO
301	V$SESSION_LONGOPS	Synonym for V_$SESSION_LONGOPS
302	V$TEMPORARY_LOBS	Synonym for V_$TEMPORARY_LOBS
303	V$VERSION	Synonym for V_$VERSION