alter index <index_name> rebuild tablespace <tablespace name> storage clause .
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: alter index <index_name> rebuild tablespace <tablespace name> storage clause .

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    alter index <index_name> rebuild tablespace <tablespace name> storage clause .

    alter index rebuild tablespace storage clause .

    If I don't specify storage clause . which storage clause will be used ?
    A. The Oracle default storage clause
    B. Old index storage clause
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2

    Re: alter index <index_name> rebuild tablespace <tablespace name> storage clause .

    Originally posted by ligang
    alter index rebuild tablespace storage clause .

    If I don't specify storage clause . which storage clause will be used ?
    A. The Oracle default storage clause
    B. Old index storage clause
    Isn't it pretty easy to get the answer? Just do it and see which one is the answer.
    There is nothing more we can learn from it,just remember oracle's default behavior
    www.cnoug.org

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    THX , actually I did the test before I post the thread , But My DB is oracle7.3 , I am not sure how it works on oracle8 . I just wander that I heard the storage clause of old index will be reused in oracle8 . So is it possible for you to get it verified ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes the same storage is used in 8i

  5. #5
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    yes the same storage is used in 8i
    the same storage means A or B ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It will use the storage definition from the original index.

    regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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