Re: How to call SQLLoader from a job?
From: HansF <news.hans_at_telus.net>
Date: Fri, 22 Oct 2004 01:46:17 GMT
Message-ID: <JDZdd.24147$_u6.9994_at_edtnps89>
Date: Fri, 22 Oct 2004 01:46:17 GMT
Message-ID: <JDZdd.24147$_u6.9994_at_edtnps89>
DA Morgan wrote:
>
> How about the use of DBMS_SCHEDULER in 10g?
- Big surprise - no idea from OP what is relevant version or OS;
- It's still external to the DB and needs to be configured;
- Most, but not all, platforms support external jobs*;
- Haven't done it yet, didn't want to comment 'till then** ;
- There's still the Database Control, the Grid Control and the new Management Agent to consider as alternatives as well.
However, I note that the Oracle DB 10g DBA guide chapter 27 would be a good place to start reading!
/Hans
* from the DBA manual ... perhaps relevant?
** for a change <g>
Received on Fri Oct 22 2004 - 03:46:17 CEST