Table Reorganization in Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Table Reorganization in Oracle 8i

  1. #1
    Join Date
    Jul 2002
    Posts
    205
    Hi,

    As far I know there are two ways for table reorganization.

    1)Export with Compress, recreate the table with new parameters and import.

    2)Create the table T2 with new parameters. Select from table T1 and put in T2. Rebuild the index, foreign key etc. then rename table T2 to T1.


    Is there any other way or without down time or easier way than this..?

    SKD



  2. #2
    Join Date
    Mar 2002
    Posts
    534
    alter table move...
    which is more or less the same as your second suggestion

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    1)Create Locally Managed tablespace

    2)alter table X move tablespace Y;

    but you have to rebuild indexes afterwards because after moving the table the rowid are different
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  4. #4
    Join Date
    Jul 2002
    Posts
    205
    In the move caluse, can we move to the existing table space. For example table emp is in tablespace T1. Through alter table move command, can we reorganize it, so that it will be reorganized in the same tablespace T1 or we need to write to table space different than T1.

  5. #5
    Join Date
    Mar 2002
    Posts
    534
    have a look at:
    http://download-east.oracle.com/docs...2a.htm#2054899
    and you will see what you can or cant do with this command


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