Database Administration (MOSC)

MOSC Banner

need archivelog for logminer

edited Dec 20, 2013 7:26PM in Database Administration (MOSC) 5 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center