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

Thread: alter table move online option

  1. #1
    Join Date
    May 2003
    Posts
    3

    alter table move online option

    Has anyone used the alter table move online option to change a table's tablespace and storage on an active system with users?

    Any bugs, pitfalls, or issues??
    I am using Oracle 8.1.6.1 on Windows 2000.
    - Matt

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    Just make sure the table is not locked. You need exclusive lock on table, in order to move it.

    use:
    ALTER TABLE &table_name MOVE TABLESPACE &tbs_name;

    Cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Mar 2002
    Posts
    303
    ALTER TABLE MOVE.... work only with enterprise edition.
    Care of indexes, they must be rebuild.

    bensmail

  4. #4
    Join Date
    Dec 2001
    Posts
    141
    I think that the "ALTER TABLE ... MOVE ONLINE" statement only works with the Indexed Organized Table (for the "ONLINE" option).

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