Oracle Database/Storage Structures

From Wikibooks, open books for an open world
Jump to: navigation, search

The purpose of tablespaces and datafiles[edit]

Creating tablespaces[edit]

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

Obtaining tablespace information from EM and the data dictionary views[edit]

Dropping tablespaces[edit]

The default tablespaces[edit]