Oracle Index: Bitmap index and B-tree index

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

 

  • No match
  • No match
Avatar_small
Sutherland said:
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.

Avatar_small
Artis said:
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.

Avatar_small
Gareth said:
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.

Avatar_small
لی ویوسوہ ہو یار said:
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

Avatar_small
AAA said:
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

Avatar_small
AAA said:
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. 토토사이트

Avatar_small
AAA said:
Sun, 05 Jun 2022 05:47:52 +0800

I surely did not realize that. Learnt some thing new these days! Thanks for that. Smallrig

Avatar_small
AAA said:
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回收

Avatar_small
qqhow said:
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

Avatar_small
meidir said:
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

Avatar_small
meidir said:
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


Login *


loading captcha image...
(type the code from the image)
or Ctrl+Enter