Saturday 16 November 2013

ORA-00997: illegal use of LONG datatype

While moving one table to another tablespace I encountered ORA-00997 error.After searching on Metalink I got the below solution:

Error:
alter table VIVEK.IMAGES move tablespace APPS_TS_TX_DATA;

Solution:
CREATE OR REPLACE DIRECTORY dmpdir AS '/d01/vivek/migration/exp';

GRANT READ, WRITE ON DIRECTORY dmpdir TO vivek;

expdp system/manager directory=dmpdir dumpfile=image_tab.dmp logfile=image_tab.log TABLES=VIVEK.IMAGES

DROP TABLE VIVEK.IMAGES CASCADE CONSTRAINTS;

impdp  system/manager directory=dmpdir dumpfile=image_tab.dmp logfile=IMP_image_tab.log REMAP_SCHEMA=VIVEK:VIVEK REMAP_TABLESPACE=SYSTEM:APPS_TS_TX_DATA


Moving Table to Another Tablespace Fails with ORA-00997 [ID 165901.1]