OraFAQ Forum: SQL & PL/SQL » find updated table name

Home » SQL & PL/SQL » SQL & PL/SQL » find updated table name (oracle 11gr2)

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

find updated table name [message #644411]

Thu, 05 November 2015 03:59

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

Dear All,

We have some software programme written by people who left the company and i am debugging it. When we modify certain attribute through GUI then it goes and update oracle table. there are 120 table and i want to know which table got modified

Please help

Report message to a moderator

Re: find updated table name [message #644412 is a reply to message #644411]

Thu, 05 November 2015 04:48

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Trace the session

Report message to a moderator

Re: find updated table name [message #644413 is a reply to message #644411]

Thu, 05 November 2015 04:56

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

Any simple way, trace is not allowed to us

Report message to a moderator

Re: find updated table name [message #644417 is a reply to message #644413]

Thu, 05 November 2015 05:45

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

Senior Member
Account Moderator

Audit the tables.

Report message to a moderator

Re: find updated table name [message #644420 is a reply to message #644413]

Thu, 05 November 2015 06:43

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

guddu_12 wrote on Thu, 05 November 2015 04:56

Any simple way, trace is not allowed to us

Why?

If you are working in a warehouse and your boss tells you to unload a trailer, but won't let you use the forklift, then his priorities are something other than getting the trailer unloaded.

Do you not have access to the source code?

Report message to a moderator

Re: find updated table name [message #644421 is a reply to message #644411]

Thu, 05 November 2015 06:45

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

No
access to source code and firing query from reporting tool so not easy

Report message to a moderator

Re: find updated table name [message #644422 is a reply to message #644421]

Thu, 05 November 2015 06:47

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

Senior Member
Account Moderator

No answer n this?

Michel Cadot wrote on Thu, 05 November 2015 12:45

Audit the tables.

Report message to a moderator

Re: find updated table name [message #644423 is a reply to message #644422]

Thu, 05 November 2015 07:16

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

Hi Michael,

Auditing means gathering stats or what? we don't have and audit column in any of the table which track the records for insert or update

Report message to a moderator

Re: find updated table name [message #644424 is a reply to message #644421]

Thu, 05 November 2015 07:51

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

What access do you have? You said you were debugging the software, can you actually see or change anything?

audit, by the way, is described here,
http://docs.oracle.com/cd/E11882_01/network.112/e36292/auditing.htm

Report message to a moderator

Re: find updated table name [message #644425 is a reply to message #644423]

Thu, 05 November 2015 08:01

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

Senior Member
Account Moderator

... and https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4007.htm#SQLRF01107

Report message to a moderator

Re: find updated table name [message #644427 is a reply to message #644425]

Thu, 05 November 2015 08:20

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

And if you're allowed to run audit but not trace then something doesn't make sense.
If you can't access the source code then you're going to need one of those two. Trace would be my preferred option.

Report message to a moderator

Re: find updated table name [message #644428 is a reply to message #644421]

Thu, 05 November 2015 08:45

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

You can't debug something that you cannot see.

Report message to a moderator

Re: find updated table name [message #644433 is a reply to message #644421]

Thu, 05 November 2015 09:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

guddu_12 wrote on Thu, 05 November 2015 04:45

No
access to source code and firing query from reporting tool so not easy

How will you know that you have correctly identified the target table?

You could attempt a brute force search if you can know within a very narrow time window when the DML occurred by using DBMS_LOGMNR to isolate what UPDATE statement was issued during this same time period.

Report message to a moderator

Previous Topic:	i want to use temporary data source for next time and it is going in that way
Next Topic:	Oracle Regular Expression - Remove space between alphabetic tokens of length 1 within a string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 12:13:35 CDT 2024