Home » SQL & PL/SQL » SQL & PL/SQL » Monitoring Database changes
Monitoring Database changes [message #238690] Sat, 19 May 2007 01:48 Go to next message
sabishs
Messages: 5
Registered: February 2007
Junior Member
Hi All,

I am using Oracle8. In my database there is an encrypted package. I wanted to know which tables are afftected when I call a function in the package. Is there any way to monitor the database changes in Oracle8?

Thanks in advance
Sabish

Re: Monitoring Database changes [message #238700 is a reply to message #238690] Sat, 19 May 2007 07:03 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Trace your session?
Re: Monitoring Database changes [message #238991 is a reply to message #238700] Mon, 21 May 2007 02:36 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SELECT * 
FROM   USER_DEPENDENCIES
WHERE  referenced_type = 'TABLE'
AND    referenced_owner != 'SYS'
Re: Monitoring Database changes [message #238993 is a reply to message #238991] Mon, 21 May 2007 02:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
This does not account for dynamic sql.
(which, by the looks of this forums seems to be practically the only way to do dml nowadays Wink)
Re: Monitoring Database changes [message #239007 is a reply to message #238993] Mon, 21 May 2007 03:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
True - I pine for the days when DBMS_SQL was the only way to do dynamic SQL - you had to really, really want to do it for it to be worht the effort.
Re: Monitoring Database changes [message #239019 is a reply to message #239007] Mon, 21 May 2007 05:07 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
hehe Smile
I totally agree. I hated it then, but sometimes long for those days now..
Luckily we have a strict technical quality assurance at our current project; strict rules about must-do's and dont-do's.
Previous Topic: ora-27101 error in windows xp???
Next Topic: ConvertToClob
Goto Forum:
  


Current Time: Fri Dec 09 15:37:18 CST 2016

Total time taken to generate the page: 0.25221 seconds