RE: Use sql*loader

Hi BaoDuy,

Yup I understand your problem, you can check your sqlloader control file under what Ravinder said bad file,
Your table constraints reject your bad data because you use conventional path,
if you use direct path bad data also will inserted into your table but your contraints will be disable and indexes will be unsued or not unique.

Ravinder how are you ???

Regards
Sinardy

-----Original Message-----
Ravinder_Bahadur_at_singaporeair.com.sg
Sent: Friday, 22 June 2001 4:52 PM
To: Multiple recipients of list ORACLE-L

Check your bad file and your error log file for sqlldr it should explain what happend.

                    Ngo BaDu
                    <ngo_duy_at_fmai        To:     Multiple recipients of list
ORACLE-L
                    l.vnn.vn>            <ORACLE-L_at_fatcity.com>
                    Sent by:             cc:
                    root_at_fatcity.        Subject:     Use sql*loader
                    com


                    22-Jun-2001
                    03:50 PM
                    Please
                    respond to
                    ORACLE-L

                    Sender Info:
                    No Sender
                    Info found in
                    the address
                    Book

Dear all,
I have a text file of 700000 rows. After using sql*loader to load it into my table, I select * from my table it only show 802 rows. Some people told me that's because of buffer. Who would like to show me how I ought to do? Thanks you and sorry for my bad english. BaoDuy

Visit us at www.singaporeair.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Ravinder_Bahadur_at_singaporeair.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  INET: sinardyxing_at_bcsis.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).