Rodd,
What else is new! I've sent many a query to Oracle, along similar lines,
and gotten a 'boneheaded' reply, even on TARs. You then have to get down and
specific to finally get through the haze those guys work in, maybe it's a
hang-over (hung over from what I do not want to know). Anyway I sent them a
query on saving how long a job running under DBMS_JOB takes. All I got for a
reply was that "they don't keep that data in the database". Duh, I knew that,
the question was how do I catch & keep it. Basically I replied that I wanted to
put a on update trigger on sys.job$ as "PL/SQL stuff". Finally someone replied
that you could not do that due to startup issues. That's where it got left,
real smart. I'm now working on a package to do it for me. Looks like I'll have
to modify a lot of snapshot jobs.
Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
