I did an export and then import to a new database. Some of the tables went into the wrong tablespace - USERS - about 105 tables. Is there a way to move these to the correct tablespace en masse? I'm using Oracle 8.1.6.
Thanks.
Printable View
I did an export and then import to a new database. Some of the tables went into the wrong tablespace - USERS - about 105 tables. Is there a way to move these to the correct tablespace en masse? I'm using Oracle 8.1.6.
Thanks.
do this if the tables are owned by same user and the user has quota in the tablespace where you want to move to:
spool move_tables.sql
select 'alter table '|| table_name || 'move tablespace_name_where_you_want_yo_move_to;'
from user tables
/
spool off
then run move_tables.sql
[Edited by pando on 02-24-2001 at 08:25 AM]