OraFAQ Forum: SQL & PL/SQL » find latest ddl statement happened in table

Home » SQL & PL/SQL » SQL & PL/SQL » find latest ddl statement happened in table (11.2,AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

find latest ddl statement happened in table [message #608349]

Wed, 19 February 2014 00:17

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

Report message to a moderator

Re: find latest ddl statement happened in table [message #608351 is a reply to message #608349]

Wed, 19 February 2014 00:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

issue dbms_logmnr

Report message to a moderator

Re: find latest ddl statement happened in table [message #608353 is a reply to message #608351]

Wed, 19 February 2014 00:29

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..

Report message to a moderator

Re: find latest ddl statement happened in table [message #608356 is a reply to message #608353]

Wed, 19 February 2014 00:53

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Using LogMiner to Analyze Redo Log Files

Report message to a moderator

Previous Topic:	Struggling with DBMS_JOB.SUBMIT syntax
Next Topic:	get the data between the dates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:37:47 CDT 2024