index creation date

[Scunningham99]

hi all

is there any way to find out when an index was created. i have checked dba_indexes...no joy!


BAckground:-
The reason i need to know is because we have a standby database, which was created on 14-sep-02. I need to know if a handfull of indexes were created after this date as they all have the nologging clause which has created corrupt blocks.

Oracle say not to use the nologging clause once the standby is up.... which makes logical sense as data is passed to standby via redo.

Thanks in advance!!

S


Sy UK

 

[sem]

Check [user|all|db]_objects:

select CREATED from USER_OBJECTS where object_type='INDEX' and object_name = <name>

Regards, Dima

http://seminihin.narod.ru

 

[Scunningham99]

cheers sorry realised after i posted

thanks anyway

s


Sy UK