OraFAQ Forum: Server Administration » How to move TS of table having column with long datatype

Home » RDBMS Server » Server Administration » How to move TS of table having column with long datatype (oracle 9.2.0.8, HP-UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to move TS of table having column with long datatype [message #376644]

Thu, 18 December 2008 02:57

omprakash
Messages: 11
Registered: January 2005

Junior Member

Hi,

In our database we have found that some tables are in system tablespace. I am not able to move these tables to different tablespace as these table contains the column with LONG datatype.
After giving the command ALTER TABLE TNAME MOVE TABLESPACE NEW_TS, it is showing the following command
ORA-00997: illegal use of LONG datatype

Pl suggest.

Thanks & Regards,
Omprakash

Report message to a moderator