DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Move Tables to new tablespace

  1. #1
    Join Date
    Feb 2000
    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.


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width