Home » RDBMS Server » Server Administration » How to move TS of table having column with long datatype (oracle 9.2.0.8, HP-UX)
How to move TS of table having column with long datatype [message #376644] Thu, 18 December 2008 02:57 Go to next message
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
Re: How to move TS of table having column with long datatype [message #376651 is a reply to message #376644] Thu, 18 December 2008 03:15 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export/import.

This is one of the many reasons to NOT use LONG.

Regards
Michel
Previous Topic: ORA-00059: maximum number of DB_FILES exceeded
Next Topic: Queries on Number of users in a SID (merged)
Goto Forum:
  


Current Time: Fri Dec 02 18:26:07 CST 2016

Total time taken to generate the page: 0.11785 seconds