Move a schema from one tablespace to another

[julian]

Originally posted by davey23uk

that script wont work

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

Well, add the index rebuild stuff too. But such a script should be run when there is no heavy access to the database. Locking might cause you several problems. Experience :-))