need archivelog for logminer
Below is the last_ddl_time:
select LAST_DDL_TIME,CREATED from dba_objects where object_name='DOWNLOADS';
LAST_DDL_TIME CREATED
-------------------- --------------------
19-NOV-2013 10:29:15 19-NOV-2013 10:12:13
23-JUL-2013 11:03:33 23-JUL-2013 11:03:33
Now I want to know what ddl was issued on this table
For this logminer can give me an answer but how do I restore the archived log file of this time?
Best regards,
Vishal
0