Home » SQL & PL/SQL » SQL & PL/SQL » to view log if reindexing done
to view log if reindexing done [message #314650] Thu, 17 April 2008 06:47 Go to next message
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 Go to previous message
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
Previous Topic: is there something wrong with my variable?(pl/sql)
Next Topic: please check the query
Goto Forum:
  


Current Time: Tue Feb 11 08:10:50 CST 2025