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?

you can try with COPY command of sqlplus

connect to sqlplus and create a new table in the tablespace you want to use, then

set long the_max_len_of_long_raw

copy to your_username/your_password_at_alias_of_the_db_you_are_connected append new_table_name using select * from the_name_of_the_table_in_system_tablespace

the copy command has to be issued in a single line (you can use the - if you want to break in several lines)

Anyway you can obstain the syntax of copy command typing just 'copy' + enter in sqlplus Received on Thu Mar 06 2003 - 18:44:25 CET