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]
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]
No comments:
Post a Comment