Re: Findout if SQL Loader is ready with loading Data

That's what I am doing.

The Logfile is written, the SQL Loader has done.

An after waiting 1 Minute.
If I make an "select max(id) from xy " the result is wrong.

If I wait an hour the result is right.

If I look at the proccesses/session I see nothing.

-=< a q u a b u b b l e >=-
<aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com> schrieb in im Newsbeitrag: 7viom1$un1$1_at_news4.svr.pol.co.uk...
> Michael Kurz <Michael.Kurz_at_c-plan.com> wrote in message
> news:7vhf0g$bfj$1_at_bnews.gigabell.net...
> > Hello
> >
> > I have following Problem
> >
> > I wrote an Import Program which is using SQL LOader to Load the Data.
> >
> > I start the Loader thru a DOS Batchfile.
> > When the Loader is Ready i make a select on a table (via ADO)
> > but the Data is not ready loaded at this time.
> >
> > Minutes Later (depends on Datasize) i get the right result.
> >
> > Who can I find out when the Loading Proccess ist done ???
> >
> > I looked at the Sessions/Processes but that's not the answer.
> > When they are done the Data is still not loaded.
>
> You can specify SQL*Loader to produce log files, which you could keep tabs
> on...
>
>
Received on Mon Nov 01 1999 - 11:07:16 CST