Oracle7 Server Utilities

Contents Index Home Previous Next

Dropping a Tablespace

You can drop a tablespace by doing a full database export, then creating a zero-block tablespace with the same name (before logging off) as the tablespace you want to drop. During import, the relevant CREATE TABLESPACE command will fail and prevent the creation of the unwanted tablespace. All objects from that tablespace will be imported into their owner's default tablespace.


Contents Index Home Previous Next