SQL Loader error
i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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).
RE: SQL Loader error
Could you post the control file? Kev. -Original Message- Sent: 30 January 2002 09:15 To: Multiple recipients of list ORACLE-L i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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: Thomas, Kevin 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).
RE: SQL Loader error
heres the ctl LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', commentsterminated by ',' OPTIONALLY ENCLOSED BY '') dat file looks something like: aer100,customer's wish to cancel aer200,etc. Thomas, Kevin [EMAIL PROTECTED]@fatcity.com on 30/01/2002 11:25:34 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Could you post the control file? Kev. -Original Message- Sent: 30 January 2002 09:15 To: Multiple recipients of list ORACLE-L i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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: Thomas, Kevin 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: 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).
RE: SQL Loader error
If I remember right, SQL*LOADER has (or used to have) a maximum field size of 256 characters. This can be overcome by specifying the size you want to load like: LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', comments CHAR(xxx) terminated by ',' OPTIONALLY ENCLOSED BY '' ) Where xxx is the size of the field in the table you are trying to load into. Regards, Kev. -Original Message- Sent: 30 January 2002 12:11 To: Multiple recipients of list ORACLE-L heres the ctl LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', commentsterminated by ',' OPTIONALLY ENCLOSED BY '') dat file looks something like: aer100,customer's wish to cancel aer200,etc. Thomas, Kevin [EMAIL PROTECTED]@fatcity.com on 30/01/2002 11:25:34 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Could you post the control file? Kev. -Original Message- Sent: 30 January 2002 09:15 To: Multiple recipients of list ORACLE-L i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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: Thomas, Kevin 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: 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: Thomas, Kevin 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).
RE: SQL Loader error
The first is a SQL loader error: SQL*Loader-00621 Field in data file exceeds maximum length Cause: A field exceeded its maximum allowable length. The maximum length is either the length specified in the SQL*Loader control file, or, for delimitable fields without a length specified, the maximum length of the corresponding database column (for char, varchar columns). The second error is from the database like putting 999 into a two digits field: ORA-01401 inserted value too large for column Cause: The value entered is larger than the maximum width defined for the column. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 30, 2002 11:15 AM To: Multiple recipients of list ORACLE-L Subject: SQL Loader error i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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).
RE: SQL Loader error
Iashraf, Not knowing what your table desc looks like for the columns in question and what the actual data, (record 2389 and 885) looks like I can take a wild guess at the explaination. Record 2389 the comments column Delimited data was specified with a maximun length and the data value exceeded that length . You could be missing the field delimiter.. Record 885, you are trying to insert 6 char into a 5 char field . The data rows that are bad should be in the bad file location. Review the data for the errors. ROR mª¿ªm [EMAIL PROTECTED] 01/30/02 07:11AM heres the ctl LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', commentsterminated by ',' OPTIONALLY ENCLOSED BY '') dat fReceived: from CONNECT-MTA by galotterile looks something like: aer100,customer's wish to cancel aer200,etc. Thomas, Kevin [EMAIL PROTECTED]@fatcity.com on 30/01/2002 11:25:34 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Could you post the control file? Kev. -Original Message- Sent: 30 January 2002 09:15 To: Multiple recipients of list ORACLE-L i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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: Thomas, Kevin 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: 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: Ron Rogers 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).
SQl Loader error sql*loader 704
I am using Oracle version 8.1.6.3.0 on a sun 2.6 server and am getting the following error when trying to load a table using sql loader. SQL*Loader-704: Internal error: Maximum record length must be = [1000] The problem occurs when I set the bindsize parameter value to 1000 , the surprising fact is that the same load works fine on the devt version of the same database.The devt database are identical to the prod database settings.Metalink didn't prove to be much of a help and I was wondering if this is related to some kind of a bug. Any help would be greatly appreciated. Girijan -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Girijan Puthran 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).
SQL*LOADER ERROR
Hi gurus, Greetings. c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl ORA-12203: TNS:unable to connect destination SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1] But am able to connect with SQL*Plus with the same username/password. Why it's showing this error, then?. Am using oracle 8.0.4, on Win NT. Rgds, Nirmal. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
Re: SQL*LOADER ERROR
Hi, sounds stupid, but is your spelling correctly ? Try the pwd and SID uppercase. Nirmal Kumar Muthu Kumaran schrieb: Hi gurus, Greetings. c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl ORA-12203: TNS:unable to connect destination SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1] But am able to connect with SQL*Plus with the same username/password. Why it's showing this error, then?. Am using oracle 8.0.4, on Win NT. Rgds, Nirmal. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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).
Re: SQL*LOADER ERROR
Hello, Have you connected with "sqlplus username/password@qtel"? If you did sqlplus without the @qtel, you are not using the listener. In that case, you will probably want to get the listener running (or running correctly). HTH Stephen [EMAIL PROTECTED] 09/04/01 01:56AM Hi gurus,Greetings.c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctlORA-12203: TNS:unable to connect destinationSQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1]But am able to connect with SQL*Plus with the same username/password.Why it's showing this error, then?.Am using oracle 8.0.4, on Win NT.Rgds,Nirmal.-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
SQL*Loader - error writing to bad file
Hi, I am using Oracle 8.0.4 on Solaris 2.6. Trying to load data from a text file to a table using SQL*Loader. Receiving the following error during the load: SQL*Loader-523: error-2 writing to file (/mnt/voyager/ccuser/ccuser.bad) The load.shl file contains bad file parameter: BAD=$DIR/$FILENAME.bad \ Tried changing permissions on .bad file from: -rwx-- to -rw-r--r--. Still receive error. We are using fixed position records. The errant record is too short. I have also tried adding TRAILING NULLCOLS to the control file, but the error still occurs. Any ideas? Thanks, Michelle __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michelle Buyer 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).