Oracle System Tables
Simple life
posted @ Mon, 24 Aug 2009 22:43:53 +0800
in Oracle Database
with tags
Oracle Database Oracle System Tables
, 2586 readers
Below is an alphabetical listing of the Oracle system tables that are commonly used.
System Table | Description |
---|---|
ALL_ARGUMENTS | Arguments in object accessible to the user |
ALL_CATALOG | All tables, views, synonyms, sequences accessible to the user |
ALL_COL_COMMENTS | Comments on columns of accessible tables and views |
ALL_CONSTRAINTS | Constraint definitions on accessible tables |
ALL_CONS_COLUMNS | Information about accessible columns in constraint definitions |
ALL_DB_LINKS | Database links accessible to the user |
ALL_ERRORS | Current errors on stored objects that user is allowed to create |
ALL_INDEXES | Descriptions of indexes on tables accessible to the user |
ALL_IND_COLUMNS | COLUMNs comprising INDEXes on accessible TABLES |
ALL_LOBS | Description of LOBs contained in tables accessible to the user |
ALL_OBJECTS | Objects accessible to the user |
ALL_OBJECT_TABLES | Description of all object tables accessible to the user |
ALL_SEQUENCES | Description of SEQUENCEs accessible to the user |
ALL_SNAPSHOTS | Snapshots the user can access |
ALL_SOURCE | Current source on stored objects that user is allowed to create |
ALL_SYNONYMS | All synonyms accessible to the user |
ALL_TABLES | Description of relational tables accessible to the user |
ALL_TAB_COLUMNS | Columns of user's tables, views and clusters |
ALL_TAB_COL_STATISTICS | Columns of user's tables, views and clusters |
ALL_TAB_COMMENTS | Comments on tables and views accessible to the user |
ALL_TRIGGERS | Triggers accessible to the current user |
ALL_TRIGGER_COLS | Column usage in user's triggers or in triggers on user's tables |
ALL_TYPES | Description of types accessible to the user |
ALL_UPDATABLE_COLUMNS | Description of all updatable columns |
ALL_USERS | Information about all users of the database |
ALL_VIEWS | Description of views accessible to the user |
DATABASE_COMPATIBLE_LEVEL | Database compatible parameter set via init.ora |
DBA_DB_LINKS | All database links in the database |
DBA_ERRORS | Current errors on all stored objects in the database |
DBA_OBJECTS | All objects in the database |
DBA_ROLES | All Roles which exist in the database |
DBA_ROLE_PRIVS | Roles granted to users and roles |
DBA_SOURCE | Source of all stored objects in the database |
DBA_TABLESPACES | Description of all tablespaces |
DBA_TAB_PRIVS | All grants on objects in the database |
DBA_TRIGGERS | All triggers in the database |
DBA_TS_QUOTAS | Tablespace quotas for all users |
DBA_USERS | Information about all users of the database |
DBA_VIEWS | Description of all views in the database |
DICTIONARY | Description of data dictionary tables and views |
DICT_COLUMNS | Description of columns in data dictionary tables and views |
GLOBAL_NAME | global database name |
NLS_DATABASE_PARAMETERS | Permanent NLS parameters of the database |
NLS_INSTANCE_PARAMETERS | NLS parameters of the instance |
NLS_SESSION_PARAMETERS | NLS parameters of the user session |
PRODUCT_COMPONENT_VERSION | version and status information for component products |
ROLE_TAB_PRIVS | Table privileges granted to roles |
SESSION_PRIVS | Privileges which the user currently has set |
SESSION_ROLES | Roles which the user currently has enabled. |
SYSTEM_PRIVILEGE_MAP | Description table for privilege type codes. Maps privilege type numbers to type names |
TABLE_PRIVILEGES | Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
TABLE_PRIVILEGE_MAP | Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names |
Wed, 14 Oct 2009 17:03:29 +0800
Badly need your help. In America, they want you to accomplish these great feats, to pull off these David Copperfield-type stunts. You want me to be great, but you don't ever want me to say I'm great? Help me! There is an urgent need for sites: Remi human hair clip in extensions. I found only this - <a href="http://www.ppgern.ufscar.br/Members/Extensions/shampoo-for-human-hair-extensions">shampoo for human hair extensions</a>. already a therapy to root, eyes lack their behavior in raising also in family. About the piety and movements requires from image to beware. With love :eek:, Sutherland from Grenada.
Mon, 15 Feb 2010 02:05:56 +0800
Hi everyone. When the gods wish to punish us, they answer our prayers. Help me! Need information about: Online scholarships no essays. I found only this - <a href="http://www.cabyregion.org/Members/ScholarshipsOnline">scholarships for online schools</a>. Most admissions in singapore program city or all of their attacks' microforms's group woods, scholarships online. At 13, after keeping awards of uniform, winfrey began all from time, scholarships online. With best wishes ;-), Artis from Arabia.
Fri, 19 Feb 2010 05:05:04 +0800
Hi guys. All great truths begin as blasphemies. Help me! Could you help me find sites on the: Invest in aig april 2009. I found only this - <a href="http://www.vidennetvarket.dk/Members/Invest">investment company</a>. Invest, transactional year packaging can become to be comprehensive told you are overwhelmed about the assurance. Invest, you can maintain the total or partly more money of profits or people per virtue of start that you could have forfeited plans increasingly. Thank you very much :o. Gareth from Burkina.
Mon, 24 May 2021 18:09:40 +0800
Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. movies123
Sun, 22 May 2022 15:49:14 +0800
Nice post. I find out some thing very complicated on diverse blogs everyday. Most commonly it is stimulating to see content from other writers and employ a little something at their store. I’d choose to use some while using the content in my small blog no matter whether you don’t mind. Natually I’ll supply you with a link on your web blog. Many thanks for sharing. how to be a merchant account provider
Sat, 28 May 2022 05:59:19 +0800
Merely wanna input that you have a very nice web site , I love the pattern it actually stands out. 토토사이트
Sun, 05 Jun 2022 05:47:52 +0800
I surely did not realize that. Learnt some thing new these days! Thanks for that. Smallrig
Tue, 14 Jun 2022 19:05:45 +0800
I saw a lot of website but I believe this one contains something extra in it in it iphone回收
Fri, 24 Jun 2022 01:09:58 +0800
Personally, I have found that to remain probably the most fascinating topics when it draws a parallel to. different types of massages
Fri, 29 Jul 2022 17:49:22 +0800
of course data entry services are very expensive that is why always make a backup of your files“ numero voyance gratuite
Mon, 03 Oct 2022 23:43:19 +0800
There are some intriguing points at some point in this post but I do not determine if they all center to heart. There is some validity but I will take hold opinion until I look into it further. Good article , thanks and then we want more! Added to FeedBurner also adobe