+ Reply to Thread
Results 1 to 6 of 6
  1. 11-03-2002 09:33 PM #1
    ligang
    ligang is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 11-04-2002 12:14 AM #2
    chao_ping
    chao_ping is offline Member
    Join Date
    Jul 2002
    Posts
    157

    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
    Reply With Quote Reply With Quote
  3. 11-04-2002 12:59 AM #3
    ligang
    ligang is offline Senior Member
    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
    Reply With Quote Reply With Quote
  4. 11-04-2002 03:57 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    yes the same storage is used in 8i
    Reply With Quote Reply With Quote
  5. 11-04-2002 07:08 AM #5
    ligang
    ligang is offline Senior Member
    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
    Reply With Quote Reply With Quote
  6. 11-04-2002 07:13 AM #6
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width