The data in an Oracle database are stored in tablespaces.
• An Oracle database can be logically grouped into smaller logical areas of space known as tablespaces.
• A tablespace can belong to only one database at a time.
• Each tablespace consists of one or more operating system files, which are called data files.

Tablespaces in the Preconfigured oracle 10g Database
In general we have two types of tablespaces:
  1. System
  2. Non-System
  • SYSTEM tablespace:
  1. Created with the database
  2. Contains the data dictionary
  3. Contains the SYSTEM undo segment
  4. Should not contain user data, although it is allowed
  • Non-SYSTEM Tablespaces:
  1.  Enable more flexibility in database administration.


About kaushalgupta
Software Engineer by profession and Blogger by Passion.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: