|
|
|
|
Re: rebuild index and recreate them [message #515384 is a reply to message #515383] |
Mon, 11 July 2011 04:59 |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Test it yourself:
conn / as sysdba
drop user jon cascade;
grant dba to jon identified by jon;
conn jon/jon
create table t1 as select * from all_objects;
create index i1 on t1(object_name);
alter index i1 rebuild online;
--in another session, before/during/after the index rebuild:
conn jon/jon
select segment_name,segment_type,bytes from user_segments;
|
|
|
|