Re: Findout if SQL Loader is ready with loading Data

Could ADO be caching some result ? Would be nice to try to do a select count(*) from your_tab in svrmgr or sqlplus and see if you the data is there. It could be that ADO keeps the cursor open with a SCN of before the data was inserted, so you don't see the data.

Anjo.

Michael Kurz wrote:

> 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 Tue Nov 02 1999 - 06:50:58 CST