Oracle Fever - Schemas
 
Home
INTRODUCTION TO ORACLE
=> Structure
=> Schemas
=> Memory structure
=> History
=> Versions
=> Suites
=> Competition
DATABASE
Oracle Certification
ERP
HOT JOBS IN ORACLE
   


mba-online-programs.com
Earn an online mba degree here.
 

Schemas

Oracle database conventions refer to defined groups of ownership (generally associated with a "username") as schemas.
Most Oracle database installations traditionally come with a default schema called SCOTT. After the installation process has set up the sample tables, the user can log into the database with the username scott and the password tiger

. (The name of the SCOTT schema originated with Bruce Scott, one of the first employees at Oracle (then Software Development Laboratories), who had a cat named Tiger.)
The scott schema has fallen out of favor as it uses so few of the features of a modern release of oracle. Most recent examples reference the default hr or oe schema.

Other default schemas include: 

  • SYS (essential core database structures and utilities)

  • SYSTEM (additional core database structures and utilities, and privileged account)

  • OUTLN (utilized to store metadata for stored outlines for query optimizer plan stability.

  • BI, IX, HR, OE, PM, and SH (expanded sample schemasSCOTT

 
 
Today, there have been 8 visitors (12 hits) on this page!
This website was created for free with Own-Free-Website.com. Would you also like to have your own website?
Sign up for free