OraFAQ Forum: SQL & PL/SQL » getting last modified table name

Home » SQL & PL/SQL » SQL & PL/SQL » getting last modified table name (oracle database 9i)

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

getting last modified table name [message #413685]

Fri, 17 July 2009 01:03

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

Report message to a moderator

Re: getting last modified table name [message #413686 is a reply to message #413685]

Fri, 17 July 2009 01:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there any way I get the name of the table that was modified
NO

Report message to a moderator

Re: getting last modified table name [message #413687 is a reply to message #413686]

Fri, 17 July 2009 01:14

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: getting last modified table name [message #413719 is a reply to message #413687]

Fri, 17 July 2009 05:39

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 22:26:21 CST 2025