Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: commit point reached
If you refuse to read, well..
The command line should include SILENT=(FEEDBACK)
It is in the manual, and if you want to use SqlLoader effectively, read it...
hmatijaca_at_yahoo.ca (Helena) wrote:
>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
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Aug 23 2002 - 15:11:07 CDT