Re: ORA-12500 TNS-12560 TNS-00530

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 14 Mar 2003 20:23:55 -0000
Message-ID: <3e72f1b4_1@mk-nntp-1.news.uk.worldonline.com>

"Rogbaker" <Rogbaker_at_gdi.net> wrote in message news:e40a12ea.0303130658.485152f8_at_posting.google.com... <snip>
> I have 2 nightly
> processes that run, they are Windows Scheduled tasks that run batch
> files. The first one Truncates a table, and the second task uses SQL
> Loader to load data into the table from a text file

Others have responded on the networking issues, but I'm wondering why you need two processes.

Why not:

LOAD DATA
TRUNCATE
INTO TABLE
blah ?

Regards,
Paul Received on Fri Mar 14 2003 - 14:23:55 CST