Move a schema from one tablespace to another

[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