{"id":3773,"date":"2012-02-13T11:15:32","date_gmt":"2012-02-13T05:45:32","guid":{"rendered":"http:\/\/windowsvj.com\/wpblog\/?p=3773"},"modified":"2012-02-17T19:39:35","modified_gmt":"2012-02-17T14:09:35","slug":"oracleplsql-oracle-system-tables","status":"publish","type":"post","link":"http:\/\/windowsvj.com\/wpblog\/2012\/02\/oracleplsql-oracle-system-tables\/","title":{"rendered":"Oracle\/PLSQL: Oracle System Tables & default Oracle schemas"},"content":{"rendered":"

After you install Oracle 10g on your Windows Machine, and if you have chosen by default create a database set, you may require privileges to access that database. The credentials for accessing the database are generally SYSTEM\/<password><\/em><\/strong> you entered while installation.<\/p>\n

[Edit: On a tip by Sathya Bhatt<\/a>]<\/p>\n

Though SYSTEM schema is meant more as an administrative schema & not recommended to be used by most people.<\/em><\/strong><\/p>\n

Oracle used the schema SCOTT for many years which are inadequate to show even the most basic features of Oracle Database and
other Oracle products with advances in Oracle Database technology. As a result, many other schemas have been created over the years. Other default Oracle database schemas included are:<\/p>\n

1. A simple schema (Human Resources, HR) is useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.
2. A second schema (Order Entry, OE) is useful for dealing with matters of intermediate complexity. Many datatypes are available in this schema, including nonscalar datatypes.
3. The Online Catalog (OC) subschema is a collection of object-relational database objects built inside the OE schema.
4. The Product Media schema (PM) is dedicated to multimedia datatypes.
5. A set of schemas gathered under the main schema name IX (Information Exchange) can demonstrate Oracle Advanced Queuing capabilities.
6. The Sales History schema (SH) is designed to allow for demos with large amounts of data. An extension to this schema provides support for advanced analytic processing.<\/p>\n

You may use SYSTEM schema has few tables already defined and described which may be used by a novice as well as an expert user for testing and development purposes. Below is a listing of the Oracle system tables that are commonly used.<\/p>\n

SYSTEM schema has few tables already defined and described which may be used by a novice as well as an expert user for testing and development purposes. Below is a listing of the Oracle system tables that are commonly used.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
System Table<\/th>\nDescription<\/b><\/th>\n<\/tr>\n
ALL_ARGUMENTS<\/td>\nArguments in object accessible to the user<\/td>\n<\/tr>\n

<\/strike> <\/p>\n

ALL_CATALOG<\/td>\nAll tables, views, synonyms, sequences accessible to the user<\/td>\n<\/tr>\n
ALL_COL_COMMENTS<\/td>\nComments on columns of accessible tables and views<\/td>\n<\/tr>\n
ALL_CONSTRAINTS<\/td>\nConstraint definitions on accessible tables<\/td>\n<\/tr>\n
ALL_CONS_COLUMNS<\/td>\nInformation about accessible columns in constraint definitions<\/td>\n<\/tr>\n
ALL_DB_LINKS<\/td>\nDatabase links accessible to the user<\/td>\n<\/tr>\n
ALL_ERRORS<\/td>\nCurrent errors on stored objects that user is allowed to create<\/td>\n<\/tr>\n
ALL_INDEXES<\/td>\nDescriptions of indexes on tables accessible to the user<\/td>\n<\/tr>\n
ALL_IND_COLUMNS<\/td>\nCOLUMNs comprising INDEXes on accessible TABLES<\/td>\n<\/tr>\n
ALL_LOBS<\/td>\nDescription of LOBs contained in tables accessible to the user<\/td>\n<\/tr>\n
ALL_OBJECTS<\/td>\nObjects accessible to the user<\/td>\n<\/tr>\n
ALL_OBJECT_TABLES<\/td>\nDescription of all object tables accessible to the user<\/td>\n<\/tr>\n
ALL_SEQUENCES<\/td>\nDescription of SEQUENCEs accessible to the user<\/td>\n<\/tr>\n
ALL_SNAPSHOTS<\/td>\nSnapshots the user can access<\/td>\n<\/tr>\n
ALL_SOURCE<\/td>\nCurrent source on stored objects that user is allowed to create<\/td>\n<\/tr>\n
ALL_SYNONYMS<\/td>\nAll synonyms accessible to the user<\/td>\n<\/tr>\n
ALL_TABLES<\/td>\nDescription of relational tables accessible to the user<\/td>\n<\/tr>\n
ALL_TAB_COLUMNS<\/td>\nColumns of user’s tables, views and clusters<\/td>\n<\/tr>\n
ALL_TAB_COL_STATISTICS<\/td>\nColumns of user’s tables, views and clusters<\/td>\n<\/tr>\n
ALL_TAB_COMMENTS<\/td>\nComments on tables and views accessible to the user<\/td>\n<\/tr>\n
ALL_TRIGGERS<\/td>\nTriggers accessible to the current user<\/td>\n<\/tr>\n
ALL_TRIGGER_COLS<\/td>\nColumn usage in user’s triggers or in triggers on user’s tables<\/td>\n<\/tr>\n
ALL_TYPES<\/td>\nDescription of types accessible to the user<\/td>\n<\/tr>\n
ALL_UPDATABLE_COLUMNS<\/td>\nDescription of all updatable columns<\/td>\n<\/tr>\n
ALL_USERS<\/td>\nInformation about all users of the database<\/td>\n<\/tr>\n
ALL_VIEWS<\/td>\nDescription of views accessible to the user<\/td>\n<\/tr>\n
DATABASE_COMPATIBLE_LEVEL<\/td>\nDatabase compatible parameter set via init.ora<\/td>\n<\/tr>\n
DBA_DB_LINKS<\/td>\nAll database links in the database<\/td>\n<\/tr>\n
DBA_ERRORS<\/td>\nCurrent errors on all stored objects in the database<\/td>\n<\/tr>\n
DBA_OBJECTS<\/td>\nAll objects in the database<\/td>\n<\/tr>\n
DBA_ROLES<\/td>\nAll Roles which exist in the database<\/td>\n<\/tr>\n
DBA_ROLE_PRIVS<\/td>\nRoles granted to users and roles<\/td>\n<\/tr>\n
DBA_SOURCE<\/td>\nSource of all stored objects in the database<\/td>\n<\/tr>\n
DBA_TABLESPACES<\/td>\nDescription of all tablespaces<\/td>\n<\/tr>\n
DBA_TAB_PRIVS<\/td>\nAll grants on objects in the database<\/td>\n<\/tr>\n
DBA_TRIGGERS<\/td>\nAll triggers in the database<\/td>\n<\/tr>\n
DBA_TS_QUOTAS<\/td>\nTablespace quotas for all users<\/td>\n<\/tr>\n
DBA_USERS<\/td>\nInformation about all users of the database<\/td>\n<\/tr>\n
DBA_VIEWS<\/td>\nDescription of all views in the database<\/td>\n<\/tr>\n
DICTIONARY<\/td>\nDescription of data dictionary tables and views<\/td>\n<\/tr>\n
DICT_COLUMNS<\/td>\nDescription of columns in data dictionary tables and views<\/td>\n<\/tr>\n
GLOBAL_NAME<\/td>\nglobal database name<\/td>\n<\/tr>\n
NLS_DATABASE_PARAMETERS<\/td>\nPermanent NLS parameters of the database<\/td>\n<\/tr>\n
NLS_INSTANCE_PARAMETERS<\/td>\nNLS parameters of the instance<\/td>\n<\/tr>\n
NLS_SESSION_PARAMETERS<\/td>\nNLS parameters of the user session<\/td>\n<\/tr>\n
PRODUCT_COMPONENT_VERSION<\/td>\nversion and status information for component products<\/td>\n<\/tr>\n
ROLE_TAB_PRIVS<\/td>\nTable privileges granted to roles<\/td>\n<\/tr>\n
SESSION_PRIVS<\/td>\nPrivileges which the user currently has set<\/td>\n<\/tr>\n
SESSION_ROLES<\/td>\nRoles which the user currently has enabled.<\/td>\n<\/tr>\n
SYSTEM_PRIVILEGE_MAP<\/td>\nDescription table for privilege type codes. Maps privilege type numbers to type names<\/td>\n<\/tr>\n
TABLE_PRIVILEGES<\/td>\nGrants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee<\/td>\n<\/tr>\n
TABLE_PRIVILEGE_MAP<\/td>\nDescription table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Download the list here: ORACLE_SYS_TABLES<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

After you install Oracle 10g on your Windows Machine, and if you have chosen by default create a database set, you may require privileges to access that database. The credentials for accessing the database are generally SYSTEM\/<password> you entered while installation. [Edit: On a tip by Sathya Bhatt] Though SYSTEM […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[259],"tags":[],"class_list":["post-3773","post","type-post","status-publish","format-standard","hentry","category-oracleplsql"],"_links":{"self":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/3773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/comments?post=3773"}],"version-history":[{"count":6,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/3773\/revisions"}],"predecessor-version":[{"id":3786,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/3773\/revisions\/3786"}],"wp:attachment":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/media?parent=3773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/categories?post=3773"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/tags?post=3773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}