DROP TABLESPACE
Removes
a tablespace from the database.
SYNTAX
| tablespace_name |
Name
of the tablespace you want to drop from the database. |
DESCRIPTION
The DROP
TABLESPACE command removes an existing tablespace from the database. To
execute the DROP TABLESPACE command you must have DBA or SYSADM security
privileges.
When you
drop a tablespace, DBMaker will automatically drop all logical files in
the tablespace. You must use operating system commands to manually remove
the physical files that correspond to those logical files if you want
to free the disk space the physical files occupy. If a tablespace contains
tables, you must drop all tables in the tablespace before you can drop
the tablespace. You cannot drop the system tablespace or the default user
tablespace.
EXAMPLE
The following
example drops the emp_ts tablespace. You must drop all tables in this
tablespace before you can drop the tablespace.
RELATED COMMANDS
<
DROP TABLE | Contents
| DROP TEXT INDEX >
|
