Home » SQL & PL/SQL » SQL & PL/SQL » find latest ddl statement happened in table (11.2,AIX)
find latest ddl statement happened in table [message #608349] Wed, 19 February 2014 00:17 Go to next message
shivshankar
Messages: 2
Registered: February 2014
Location: Bangalore
Junior Member
Hi Team,

How to find the latest dll statement issued in a table. Please help to find the information, i can see the last_ddl date as recent(17_FEB).

Thank You

Re: find latest ddl statement happened in table [message #608351 is a reply to message #608349] Wed, 19 February 2014 00:19 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
issue dbms_logmnr
Re: find latest ddl statement happened in table [message #608353 is a reply to message #608351] Wed, 19 February 2014 00:29 Go to previous messageGo to next message
shivshankar
Messages: 2
Registered: February 2014
Location: Bangalore
Junior Member
Thanks for the reply..but is there anyway to find if logmnr function not enabled..
Re: find latest ddl statement happened in table [message #608356 is a reply to message #608353] Wed, 19 February 2014 00:53 Go to previous message
Michel Cadot
Messages: 59425
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Using LogMiner to Analyze Redo Log Files
Previous Topic: Struggling with DBMS_JOB.SUBMIT syntax
Next Topic: get the data between the dates
Goto Forum:
  


Current Time: Fri Oct 24 08:14:11 CDT 2014

Total time taken to generate the page: 0.11315 seconds