|
-
Just login using SQL*Plus and with your schema user id. Run the following script:
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 ;'
spool off
@temp.sql
You should be aware that storage clause. I suggested you to consider carefully if you move all tables at the same time because each table may have different storage requirement.
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|