tablespaces2 - Managing Tablespaces and Data Files...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Managing Tablespaces and Data Files Tablespace Features: A tablespace can only belong to one database Each tablespace consists of one or more operating system files Tablespaces can be brought online when the database is running All tablespaces, except for the SYSTEM tablespace or a tablespace with an active rollback segment, can be taken offline. This leaves the database running. Uses: Helps in managing space, availability of data, improve I/O performance, perform backups, store data on read-only devices, Tablespace consist of one more data file. Features of Data File: A data file can belong to only one tablespace A data file is created by the Oracle server Size of a data file can change Non-system tablespace: Not mandatory, contains data segments, index segments, temp. segments, contains rollback segments and application indexes, System tablespace: Mandatory, contains data dictionary information CREATE TABLESPACE Tablespacename DATAFILE ‘e:\-----\accts01.dbf’ SIZE 10K; Storage Parameters:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at University of Arizona- Tucson.

Page1 / 3

tablespaces2 - Managing Tablespaces and Data Files...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online