Home » SQL & PL/SQL » SQL & PL/SQL » getting last modified table name (oracle database 9i)
getting last modified table name [message #413685] Fri, 17 July 2009 01:03 Go to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
Hi
Is there any way I get the name of the table that was modified (updated / inserted into /deleted from ) as the result of the last query fires on database.
I cannot enable db audit due to performance issues.

Any help would be highly appreciated

Thanks
Sapan
Re: getting last modified table name [message #413686 is a reply to message #413685] Fri, 17 July 2009 01:06 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way I get the name of the table that was modified
NO
Re: getting last modified table name [message #413687 is a reply to message #413686] Fri, 17 July 2009 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BlackSwan wrote on Fri, 17 July 2009 08:06
>Is there any way I get the name of the table that was modified
NO

In addition it is meaningless: "last modified" depends on the session in multiuser environment.

Regards
Michel

Re: getting last modified table name [message #413719 is a reply to message #413687] Fri, 17 July 2009 05:39 Go to previous message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
Thanks
i figured it out
I get it using substr and instr on the last query text stored in
ora_sql_text for any operations insert update or delete

Previous Topic: materialized views
Next Topic: group by date range
Goto Forum:
  


Current Time: Wed Dec 07 20:49:37 CST 2016

Total time taken to generate the page: 0.11518 seconds