Question: How do I use the purge tablespace
command and what does it do?
Answer: The purge tablespace
command will permanently remove a tablespace that has been moved to
the recycle bin.
The syntax for using the purge tablespace command is:
purge tablespace 'tablespace_name'
To be able to use the purge tablespace command, the
tablespace you wish to purge must be part of your own schema, or you
must have the drop any system privilege for tablespaces.
For more information on the ability to purge tablespaces or any
other object, please check out this
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.