-
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
-
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
-
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
-
yes the same storage is used in 8i
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|