Jump to content

Oracle Database/Storage Structures

From Wikibooks, open books for an open world

The purpose of tablespaces and datafiles

[edit | edit source]

Creating tablespaces

[edit | edit source]

Managing tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make read-only/read-write)

[edit | edit source]

Obtaining tablespace information from EM and the data dictionary views

[edit | edit source]

Dropping tablespaces

[edit | edit source]

The default tablespaces

[edit | edit source]