Tuesday, 17 March 2015

move table to other table space including LOB.

###move table to other table space including LOB..######

1) move table to other tablespace

ALTER TABLE table_name MOVE TABLESPACE tablespace_name;

2) move LOB to other tablespace

ALTER TABLE table_name move LOB (column_name) STORE AS (TABLESPACE new_tablespace);

3) move index to other tablespace.

ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;

No comments:

Post a Comment

make: perl: Command not found make: *** [ins_rdbms.mk:573: javavm_refresh] Error 127 '

 Error:  Patching component oracle.javavm.client, 19.0.0.0.0... Make failed to invoke "/usr/bin/make -f ins_rdbms.mk javavm_refresh ORA...