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

Thread: TABLE REORG

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    I am doing a table and index reorg using this procedure

    1. Export the table data
    2. Drop the indexes
    3. Truncate the tables
    4. Import the data
    5. rebuild/re-create the indexes

    Is truncating the table enough or do I need to drop and re-create the table.

    Can anyone suggest me of a more efficient way of doing this.

    Thx

    Ed

  2. #2
    Join Date
    Nov 2001
    Location
    Central U.S.
    Posts
    35
    Truncating the table should be sufficient. And, after dropping the indexes the import should recreate them for you.
    David D. Fitzjarrell
    Oracle Certified DBA

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    Truncate shall push the HWM of table to the initial extent.
    If the idea is to change the initial extent size and other storage parameters, then u need to
    drop the table.
    Also truncate is an nologgin operation.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What version? If you are on 8.1.x, you don't have to do this procedure to rebuild tables; use MOVE and REBUILD.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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