moving tables or indexes from one tablespace to another
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: moving tables or indexes from one tablespace to another

  1. #1
    Join Date
    Oct 2000
    Posts
    250
    Hi,
    Is anybody know how to move the tables or indexes from one tablespace to another tablespace ?

    Thanks

  2. #2
    Join Date
    Jan 2001
    Posts
    71
    export, drop TB and IDX. Create in you desired TBS with the same name. import

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    do a simple create table table_name as select * from table
    tablespace desired_tablespace;

    hope this helps

  4. #4
    Join Date
    Mar 2001
    Posts
    22

    Thumbs up alter table move

    Make use of the ALTER TABLE MOVE command.

    Make sure you rebuild the indexes on the table.

    It makes the table's indexes UNUSABLE
    hptse

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