1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Rebuild Index with Truncate table

Discussion in 'SQL PL/SQL' started by ora_student, Nov 8, 2008.

  1. ora_student

    ora_student Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hi all, i have another question, In Oracle 10.2.0.3 if a table is truncated, does it's associated indexes will be automatically rebuild & high water mark reset?

    thanks 4 all your answers
     
  2. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    Yes, TRUNCATE also removes all data from all indexes in the underlying table and returns the freed space to the tablespaces containing them.
     
  3. ora_student

    ora_student Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    yes thanks