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-----
[EMAIL PROTECTED]
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@fmai To: Multiple recipients of list
ORACLE-L
l.vnn.vn> <[EMAIL PROTECTED]>
Sent by: cc:
root@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).