SQL>spool tables.out
SQL> SELECT 'ALTER TABLE ' || TABLE_NAME || ' MOVE TABLESPACE NEWTABLESPACE; ' FROM USER_TABLES;
SQL>spool off
SQL>@tables.out
Friday, May 9, 2008
Change Tablespace of All Tables
Subscribe to:
Post Comments (Atom)
SQL>spool tables.out
SQL> SELECT 'ALTER TABLE ' || TABLE_NAME || ' MOVE TABLESPACE NEWTABLESPACE; ' FROM USER_TABLES;
SQL>spool off
SQL>@tables.out
No comments:
Post a Comment