Path: news.easynews.com!easynews!novia!novia!newsfeed.icl.net!newsfeed.esat.net!diablo.theplanet.net!news.theplanet.net!not-for-mail From: Connor McDonald Newsgroups: comp.databases.oracle.misc Subject: Re: dbms_job and SQL LOADER Date: Wed, 10 Oct 2001 21:11:14 +0100 Lines: 25 Message-ID: <3BC4AB62.8AD@yahoo.com> References: <0h1x7.97202$6x5.21271729@afrodite.telenet-ops.be> Reply-To: connor_mcdonald@yahoo.com NNTP-Posting-Host: modem-165.iron.dialup.pol.co.uk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news6.svr.pol.co.uk 1002744788 9210 62.136.25.165 (10 Oct 2001 20:13:08 GMT) NNTP-Posting-Date: 10 Oct 2001 20:13:08 GMT X-Complaints-To: abuse@theplanet.net X-Mailer: Mozilla 3.01 (WinNT; I) To: CrazyIvan Xref: easynews comp.databases.oracle.misc:70148 X-Received-Date: Wed, 10 Oct 2001 13:12:52 MST (news.easynews.com) CrazyIvan wrote: > > Is it possible te create a job that launches sql loader ? > > I know it is possible to lauch system commands from sql plus using the > host command, but can this also be used in a job ? > > Thanx Not by default - but you could: - use dbms_pipes to talk to an waiting C routine - use external procedures - use java, all of which can let you launch an OS command from within the db hth -- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."