Move Tables to new tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Move Tables to new tablespace

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

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