Home » SQL & PL/SQL » SQL & PL/SQL » Timestamp of DML and DDL staatements
Timestamp of DML and DDL staatements [message #196903] Mon, 09 October 2006 01:53 Go to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Hi,

Need to confirm if somehing of this sort as mentioned below exist in ORACLE.

1. Does data dictionaries of Oracle hold the timestamp of the last DDL or DML operation being performed on the table.

2. Also, is there something like maintaining the history of DDL or DML operations being performed on the table along with timestamps.

thanks
Re: Timestamp of DML and DDL staatements [message #196910 is a reply to message #196903] Mon, 09 October 2006 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Query USER_OBJECTS to see the last DDL time.

As far as I can tell, there's no history about either DDL or DML statements. You might, however, use database triggers to audit DML statements (inserts, updates and deletes). DDL? Not sure.

Or, of course, enble database Auditing.
Re: Timestamp of DML and DDL staatements [message #196956 is a reply to message #196910] Mon, 09 October 2006 06:03 Go to previous messageGo to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Littlefoot,

thanks for the reply............from USER_OBJECTS we get the Last_DDL_Time. This gives us the timestamp of the last DDL that was fired but does not indicate as to which DDL was fired. Does ORACLE also stores the last DDL that was executed.

thanks
Re: Timestamp of DML and DDL staatements [message #196967 is a reply to message #196956] Mon, 09 October 2006 06:47 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Honestly, I've never seen anything but the last DDL time - I *think* that Oracle doesn't store the actual command. I might be wrong about it, of course.
Previous Topic: Multi date column report using range
Next Topic: Trigger mutation error
Goto Forum:
  


Current Time: Sun Dec 11 08:05:53 CST 2016

Total time taken to generate the page: 0.03938 seconds