storage clause .

Printable View

11-03-2002, 10:33 PM
ligang

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
11-04-2002, 01:14 AM
chao_ping

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

Quote:

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
11-04-2002, 01:59 AM
ligang

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 ?
11-04-2002, 04:57 AM
davey23uk

yes the same storage is used in 8i
11-04-2002, 08:08 AM
ligang

Quote:

yes the same storage is used in 8i

the same storage means A or B ?
11-04-2002, 08:13 AM
jovery

It will use the storage definition from the original index.

regards

All times are GMT -4. The time now is 01:11 PM.