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

Thread: ALTER TABLE MOVE OPTION IN 8.1.7

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    I am running on 8.1.7.3


    If I want to change the tablespace already exist in the database: How do I do it???

    Is there a command

    ALTER TABLE TABLE_NAME MOVE TABLESPACE TABLESPACE_NAME


    Please advise


  2. #2
    Join Date
    Jan 2002
    Posts
    474
    Jeff or Julian,

    Do you have any advises on ALTER table command, I am sorry to rush you but I need to do this in two hours

    please adivse


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what is change tablespace....???

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The command is:

    ALTER TABLE tablename MOVE
    TABLESPACE tablespacename
    STORAGE (INITIAL 10m NEXT 10m PCTINCREASE 0);

    After the move, rebuild the indexes.

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