Oracle Database/Storage Structures

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

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]