Thursday, August 15, 2013

How to Move tables from one tablespace to another in oracle



select 'alter table ' || table_name || ' move tablespace your_target_tablespace_name ;' from user_tables;