change tabl space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: change tabl space

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    change tabl space

    Hi can any one help me in moving a table from tablspace1 to tablespace 2

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    alter table xxx move tablespace tablespace2


    This will invalidate all indexes on this table though

  3. #3
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Use the MOVE command
    alter table MOVE tablespace tbs_new ONLINE;

    Don't forgot to set the storage parameter along with that.

    Restriction With MOVE,
    ---------------------
    a)Doesn't support if u have a column with LONG datatype
    b)Need to Rebuild all indexes as it invalidate the indexes coz of change in rowid.
    c)If table is huge make sure there is a plenty of space in TEMP tablespace

    HTH
    Ravinder

  4. #4
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    thanks a lot both of you guys ..very helpful

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