Oracle-Tablespaces

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
• SYSTEM
• SYSAUX
• TEMP
• UNDOTBS1
• USERS
• EXAMPLE
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.

		
Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: