OraFAQ Forum: SQL & PL/SQL » Timestamp of DML and DDL staatements

Home » SQL & PL/SQL » SQL & PL/SQL » Timestamp of DML and DDL staatements

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

Timestamp of DML and DDL staatements [message #196903]

Mon, 09 October 2006 01:53

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

Report message to a moderator

Re: Timestamp of DML and DDL staatements [message #196910 is a reply to message #196903]

Mon, 09 October 2006 02:10

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Timestamp of DML and DDL staatements [message #196956 is a reply to message #196910]

Mon, 09 October 2006 06:03

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

Report message to a moderator

Re: Timestamp of DML and DDL staatements [message #196967 is a reply to message #196956]

Mon, 09 October 2006 06:47

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Multi date column report using range
Next Topic:	Trigger mutation error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 05:35:44 CST 2024