I know that, what I would like to know is the following
"I would like to know what Oracle parameters can be used to suppress
it,
since it looks as if the loader will be slow because it has to commits
every 7 rows (and there are 500K rows being loaded)"
"Alan" <alan_remove_this_shein_at_erols.com> wrote in message news:<ak3ggd$1fhbv2$1_at_ID-114862.news.dfncis.de>...
> With even a few seconds of research, you could find the answer yourself. Why
> don't you try typing sqlldr at the command prompt and read the help screen
> for starters... Hint: use a comma between keywords.
>
> "Helena" <hmatijaca_at_yahoo.ca> wrote in message
> news:c5a36d06.0208221150.6f9248fd_at_posting.google.com...
> > Hi there
> >
> > I was using sqldr in oracle 8170 on solaris and the file inserts
> > without any trouble but we are getting this messages at the end
> > Commit point reached - logical record count 12789
> > Commit point reached - logical record count 12796
> > Commit point reached - logical record count 12803
> > Commit point reached - logical record count 12810
> >
> > this is the table contents
> > ORACLE_HOME=/u01/app/oracle/product/8.1.7
> >
> > sqlldr userid=perfai/perfai@ DEVDB silent=header direct=no
> > errors=1 rows=10000 \
> >
> control=/products/acctinq/src_unix/loaders/lph_aiq_${table}_ldr.fmt
> > \
> > data=$PENDING_DIR/aiq.$table.insert \
> > log=aiq_$table.ctl.log \
> > bad=aiq_$table.ctl.bad
> >
> > can someone please tell me what to do, I don't want to get those
> > messages anymore "commit point reached"
> > Thanks
> > Helena
Received on Fri Aug 23 2002 - 14:34:56 CDT
