On 01/27/2004 10:55:53 AM, Tanel Poder wrote:
> Note that if you have LONG or LONG RAW datatypes you can't use alter
> table
> move for reorganizing tables.
>
> Tanel.
But, you can still use
'DROP TABLESPACE <tbs> INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS;'
It will give you an excellent opportunity to reorganize the tablespace.
Of course, prior to that, it would be very wise to export the objects
from the tablespace.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
Received on Tue Jan 27 2004 - 10:22:04 CST
