On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Tuesday, September 16, 2008

Schemas

SYS
contains the data dictionary

SYSTEM
contains additional tables and views that store administrative information


Sample Schemas
The names are in alphabetical order, and specifies the order of creation.

HR - Human Resources
  • basic topics
  • an extension supports Oracle Internet Directory

OE - Order Entry
  • HR must be installed and you have the password to it
  • intermediate topics
  • multitude of datatypes
  • Oracle Spatial be installed
OC - Online Catalog (sub-schema)
  • object-relational examples

PM - Product Media
  • for multimedia datatypes
  • foreign keys to OE
  • database must be enabled for JVM and interMedia

IX - Information Exchange
  • shows advanced queuing
  • based on order entry data in OE

SH - Sales History
  • large amount of data
  • analytic processing
  • logically depends on the OE schema
  • requires the partitioning option


EXAMPLE Tablespace:
First create the tablespace that will hold all of the schema's segments.
Create Tablespace "EXAMPLE"
Logging Datafile '___________/example01.dbf' Size 50m Reuse
Autoextend On Next 50m Maxsize 1000m
Extent Management Local
Segment Space Management Auto;

No comments:

Post a Comment