Re: Dropping a job

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3aa494eb_at_news.iprimus.com.au...
> I see Sybrand has provided the formally correct answer, and if you stick
> with that you'll be fine.
>
> However, I'd point out that a simple 'delete from dba_jobs' will do the
 deed
> as well, and has the advantages of brevity and syntax clarity (I *do* so
> wish Oracle wasn't bundling so much database functionality into the
> convoluted syntax that are packages and procedures!)
>
> Regards
> HJR
>
>
>
> "Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message
> news:98133h$ivb$03$1_at_news.t-online.com...
> > I created some replication jobs, but meanwhile I do not need them. How
 can
 I
> > drop it again?
> >
> > Thanks
> > Nicolas
> >
> >
>
>

I don't even want to *think* about manipulating dba_ entities *directly* and IMO this should simply *NOT* be advertised. In this particular case probably no harm is done, but what about if you delete directly from dba_tables? Will it work? Will it manipulate tab$ and obj? You are understanding what you are doing, but many people here aren't and IMO they shouldn't learn bad habits like *hacking* a dictionary.
Yet, all the best of course in your next job.

Regards,

Sybrand Bakker, Oracle DBA
(not working for Oracle, and doing this on a voluntary basis) Received on Wed Mar 07 2001 - 05:25:57 CST