we do not track that, however - you can use flashback query on the dictionary perhaps to retrieve this, if your undo retention is good enough. You can use the droptime from user_recyclebin to query "as of" instead of the way I'm doing it below with dbms_flashback.get_system_change_number
ops$tkyte%ORA11GR2> create table t ( x int, constraint t_pk primary key(x), constraint check_x check(x>0) );
Table created.
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> pause
ops$tkyte%ORA11GR2> column SCN new_val S
ops$tkyte%ORA11GR2> select dbms_flashback.get_system_change_number SCN from dual;
SCN
----------
105021336
ops$tkyte%ORA11GR2> pause
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> drop table t;
Table dropped.
ops$tkyte%ORA11GR2> flashback table t to before drop;
Flashback complete.
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> column index_name new_val I
ops$tkyte%ORA11GR2> select index_name from user_indexes where table_name = 'T';
INDEX_NAME
------------------------------
BIN$zdcXg9tLXdPgQwEAAH/vtw==$0
ops$tkyte%ORA11GR2> connect / as sysdba
Connected.
sys%ORA11GR2> column index_name new_val OI
sys%ORA11GR2> select index_name from dba_indexes as of scn &S where owner = 'OPS$TKYTE' and table_name = 'T';
old 1: select index_name from dba_indexes as of scn &S where owner = 'OPS$TKYTE' and table_name = 'T'
new 1: select index_name from dba_indexes as of scn 105021336 where owner = 'OPS$TKYTE' and table_name = 'T'
INDEX_NAME
------------------------------
T_PK
sys%ORA11GR2> connect /
Connected.
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> alter index "&I" rename to "&OI";
old 1: alter index "&I" rename to "&OI"
new 1: alter index "BIN$zdcXg9tLXdPgQwEAAH/vtw==$0" rename to "T_PK"
Index altered.
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> column constraint_name new_val C
ops$tkyte%ORA11GR2> select constraint_name from user_constraints where table_name = 'T' and constraint_type = 'C';
CONSTRAINT_NAME
------------------------------
BIN$zdcXg9tJXdPgQwEAAH/vtw==$0
ops$tkyte%ORA11GR2> connect / as sysdba
Connected.
sys%ORA11GR2> column constraint_name new_val OC
sys%ORA11GR2> select constraint_name from dba_constraints as of scn &S where owner = 'OPS$TKYTE' and table_name = 'T' and constraint_type = 'C';
old 1: select constraint_name from dba_constraints as of scn &S where owner = 'OPS$TKYTE' and table_name = 'T' and constraint_type = 'C'
new 1: select constraint_name from dba_constraints as of scn 105021336 where owner = 'OPS$TKYTE' and table_name = 'T' and constraint_type = 'C'
CONSTRAINT_NAME
------------------------------
CHECK_X
sys%ORA11GR2> connect /
Connected.
ops$tkyte%ORA11GR2> alter table t rename constraint "&C" to "&OC";
old 1: alter table t rename constraint "&C" to "&OC"
new 1: alter table t rename constraint "BIN$zdcXg9tJXdPgQwEAAH/vtw==$0" to "CHECK_X"
Table altered.
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> select index_name from user_indexes where table_name = 'T';
INDEX_NAME
------------------------------
T_PK
ops$tkyte%ORA11GR2> select constraint_name from user_constraints where table_name = 'T' and constraint_type = 'C';
CONSTRAINT_NAME
------------------------------
CHECK_X