Packages, tables, inbvoker and definer - wierd problem !

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 1 Aug 2003 12:34:40 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703FABE36@lnewton.leeds.lfs.co.uk>

Hi Connor,

Good point. Although getting access to the database might be problematical.

I'm in a 'hands tied' situation, I can only ask for stuff and they can (maybe) get it for me - if it doesn't break any of their rules !

Cheers,
Norm.

PS. Glad to be back on Oz ?

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Connor McDonald [mailto:connor_mcdonald_at_yahoo.com] Posted At: Friday, August 01, 2003 10:58 AM Posted To: server
Conversation: Packages, tables, inbvoker and definer - wierd problem ! Subject: Re: Packages, tables, inbvoker and definer - wierd problem !

If you haven't got trace you can do the old hack of trying to catch db file reads via v$session_Wait and glean which table is being read from the p1/p2 data.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"

Received on Fri Aug 01 2003 - 06:34:40 CDT