OracleDB‎ > ‎

Move Tables

move table between tablespace of Oracle database

set pagesize 0 set linesize 132 set trimspool on set feedback off spool temp.sql select 'alter table ' || table_name || ' move tablespace your_target_tablespace_name ;' from user_tables; spool off @temp.sql
Comments