Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    10

    Unanswered: Moving tables to a different tablespace

    what is the syntax to accomplish this? thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    ALTER TABLE tablename MOVE STORAGE (INITIAL 2M NEXT 1M) TABLESPACE newtablespacename ;

    You don't have to put in the storage parameters, but remember that you
    invalidate all indexes on this table and the indexes must be rebuilt. Also
    check for invalid objects afterwards ... you may or may not have to recompile some objects referencing the table...

    HTH
    Gregg

Posting Permissions

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