Re: How to move tables to different tablespaces, URGENT!!!!

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0303052050.1defdf33_at_posting.google.com>...
> Hi All,
>
> I have a table with LONG RAW column and that table resides in SYSTEM
> tablespace.
> Now when i tried to move this table to newly created tablespace, then
> it is saying "illegal use of LONG type". Is there any way to move
> tables with LONG RAW column to different tablespace?
>
> Thanks in Advance,
> Praveen

Sure

- export the table
- drop the table
- precreate the table in a different tablespace
- import the table

-ask the user why he is still using LONGs and/or LONG RAWs

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Mar 06 2003 - 18:34:22 CET