to view log if reindexing done [message #314650] |
Thu, 17 April 2008 06:47  |
virmahi
Messages: 266 Registered: April 2008 Location: India
|
Senior Member |
|
|
Hi,
Please let me know if there is any log maintained in oracle to view if anyone has reindexed the indexes.
If there is any log maintained by oracle for the indexes history, please let me knoe where can I find it.
Immediate response would be appreciated.
Thanks in advance,
Mahi
|
|
|
Re: to view log if reindexing done [message #314659 is a reply to message #314650] |
Thu, 17 April 2008 07:29  |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
Quote: | Please let me know if there is any log maintained in oracle to view if anyone has reindexed the indexes.
|
I believe when you say reindexed the indexes is it something like index rebuild or reorg. If that is the case this could be of help to you.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for HPUX: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
SQL> drop table mytable purge;
Table dropped.
SQL> create table mytable as select * from cat;
Table created.
SQL> create index mytable_idx on mytable(table_type);
Index created.
SQL> select object_name, last_ddl_time from user_objects where object_name = 'MYTABLE_IDX';
OBJECT_NAME LAST_DDL_TIME
------------------------------ -----------------------------
MYTABLE_IDX 17-APR-2008 13:26:17
SQL> alter index mytable_idx rebuild;
Index altered.
SQL> select object_name, last_ddl_time from user_objects where object_name = 'MYTABLE_IDX';
OBJECT_NAME LAST_DDL_TIME
------------------------------ -----------------------------
MYTABLE_IDX 17-APR-2008 13:27:07
Regards
Raj
|
|
|