Oracle Sql Loader Error 605
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL*Loader-605: Non-data dependent ORACLE error occurred — load discontinued up vote 0 down vote favorite I am getting error when I try to load Incl_c.ctl, all other control files are loading perfectly fine. Here's the error: [navy10@sit ~]$ sqlldr navy10@studb10g Incl_C.ctl Password: SQL*Loader: Release 10.2.0.3.0 - Production on Wed Mar 27 10:26:52 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-2028: load discontinued to user interrupt (Ctrl-C) [103] SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued. here's the control file for Incl_C: LOAD DATA INFILE 'Incl_C.dat' REPLACE INTO TABLE Includes_C FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'" (Tnum, ConfID) Here's the .log file for Incl_C: SQL*Loader: Release 10.2.0.3.0 - Production on Wed Mar 27 10:26:52 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: Incl_C.ctl Data File: Incl_C.dat Bad File: Incl_C.bad Discard File: none specified (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array: 64 rows, maximum of 256000 bytes Continuation: none specified Path used: Conventional Table INCLUDES_C, loaded from every logical record. Insert option in effect for this table: REPLACE Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- TNUM FIRST * , O(') CHARACTER CONFID NEXT * , O(') CHARACTER Record 22: Rejected - Error on table INCLUDES_C, column TNUM. Column not found before end of logical record (use TRAILING NULLCOLS) SQL*Loader-2028: load discontinued to user interrupt (Ctrl-C) [103] ORA-01013: user requested cancel of current operation SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued. Table INCLUDES_C: 0 Rows successfully loaded. 1 Row not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Space allocated for bind array: 33024 bytes(64 rows) Read buffer bytes: 10485
Sign in Expand/collapse global hierarchy Home Aleph Knowledge Articles Expand/collapse global location SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued Last updated 09:14, 9 Dec 2015 Save as PDF Share Share Share Tweet Share No headers Article Type: General Product: Aleph Product Version: 16.02 Description:The p_manage_01 job completed this morning. It's seems to have finished OK, but I see the following in the log:Commit point reached - logical record count 14853242Commit point reached - logical record count 14853342Commit point reached - logical reSQL*Loader-605: Non-data dependent http://stackoverflow.com/questions/15661444/sqlloader-605-non-data-dependent-oracle-error-occurred-load-discontinued ORACLE error occurred -- load discontinued.cord count 14853442Commit point reached - logical record count 14853542Commit point reached - logical record count 14853642And later:mv /exlibris/aleph/u16_3/odn07/files/z98.seq /exlibris/aleph/u16_3/odn07/files/z98.seq.variablefixed_size 40Username:SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.SQL*Loader: Release 9.2.0.3.0 - Production on Thu Apr 3 07:20:08 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Commit point reached - logical record https://knowledge.exlibrisgroup.com/Aleph/Knowledge_Articles/SQL*Loader-605%3A_Non-data_dependent_ORACLE_error_occurred_--_load_discontinued count 100Commit point reached - logical record count 200Resolution:As described in KB 16384-2561, this "non-data-dependent ORACLE error" can be due to a lack of space. The job halts. If space is added, it continues. It seems that this is what happened since we see that the job *did* continue, and seems to have finished successfully.It may be that the tablespace is automatically extensible: this message occurred and after it automatically added the space, it continued.You can check the alert.log -- which, in this case, is on the $ORA_HOST server. That may show more. Though it's not always fool-proof, all of the p_manage_01_e.cycles lines have "+ +", indicating success. Article last edited: 10/8/2013 Back to top SQL*Loader-510: Physical record in data file is longer than the maximum SQL "select count" is slow Was this article helpful?YesNo Recommended articles There are no recommended articles. Article type topic Content Type Knowledge_Article Language english Product aleph Tags 16.02 contype:kba Prod:Aleph Type:General © Copyright 2016 Ex Libris Knowledge Center Powered by MindTouch
Sign in Expand/collapse global hierarchy Home Aleph Knowledge Articles Expand/collapse global location SQL Loader error 605 Non-data dependent ORACLE error -- load discontinued Last updated 02:22, https://knowledge.exlibrisgroup.com/Aleph/Knowledge_Articles/SQL_Loader_error_605_Non-data_dependent_ORACLE_error_--_load_discontinued 9 Dec 2015 Save as PDF Share Share Share Tweet Share No headers Article Type: General Product: Aleph Product Version: 2 Description:We ran our first full http://board.phpbuilder.com/showthread.php?623266-SQL*Loader-ERROR-what-does-it-mean ETL after having Oracle and Cognos upgraded on the test server. There are 5 errors in the logs. 3 of them are normal errors that always oracle sql appear (2 small data issues on fact_items and bib_info, and the absence of the call_no_topics table). I am not concerned about those errors.However, there are 2 additional errors this time that appear to be related to Oracle. These errors appear in the ETL Extract Error List p_arc_extract_error_list.log and appear to be related to oracle sql loader the loading of OPAC events:/exlibris/aleph/u20_1/abc50/scratch/p_arc_01_c.log: Commit point reached - logical record count SQL*Loader-605- Non-data dependent ORACLE error occurred -- load discontinued./exlibris/aleph/u20_1/abc50/scratch/p_arc_01_c.log:Username-SQL*Loader-605- Non-data dependent ORACLE error occurred -- load discontinued./exlibris/aleph/u20_1/abc50/scratch/p_arc_01.log:Table mrr_opac Loaded 13276384 of 20915261 - Not all records were loadedWe are scheduled to have the production server upgraded on July 19-21. We would like to have a better understanding of what the problem is here before proceeding.Resolution:[From Jerry:] It seems that KB's 16384-2563 and 16384-2561 may be relevant. [From site:] Our DBA added more datafiles to the TS_ARC_D tablespace, which appears to have fixed the problem. Article last edited: 10/8/2013 Back to top SQL for updating one type of record with fields from another type. SQL queries slow in Aleph 18-up **MASTER record** Was this article helpful?YesNo Recommended articles There are no recommended articles. Article type topic Content Type Knowledge_Article Language english Product aleph Tags 2 contype:kba Prod:Aleph Type:General © Copyright 2016 Ex Libris Knowledge Center Powere
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: SQL*Loader ERROR -- what does it mean ? Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-04-2001,10:36 AM #1 Anon View Profile View Forum Posts Senior Member Join Date Jun 2000 Posts 65,357 SQL*Loader ERROR -- what does it mean ? Hello, I recently restarted my Oracle8i database on my Linux box and configured PHP with Oracle8i. Now I cannot load any data into my tables. I created a tablespace. Here is the syntax i used: CREATE TABLESPACE IAIII DATAFILE \'/usr/local/oracle/8i/u01/app/oracle/oradata/DATA.dbf\'SIZE 300M REUSE DEFAULT STORAGE (INITIAL 25M NEXT 25M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) PERMANENT; The tablespace was created with no problem. But, when I try to load some data with SQL*Loader I\'m getting an error. Here is the error as it reads in the log file. There is actually two of them. ORA-01552: cannot use system rollback segment for non-system tablespace \'IAIII\' SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued. I cannot load any rows at all. I already tried resizing my tablespace to 500M but I still get the same errors. Can anyone tell me why this is happening, please ? Thank you. Reply With Quote 12-04-2001,11:21 AM #2 Anon View Profile View Forum Posts Senior Member Join Date Jun 2000 Posts 65,357 RE: SQL*Loader ERROR -- what does it mea you have to create non-system rollback segment(s) and but it online. Reply With Quote 12-04-2001,01:03 PM #3 Anon View Profile View Forum Posts Senior Member Join Date Jun 2000 Posts 65,357 RE: SQL*Loader ERROR -- what does it mea Thanks, but ... How do I create non-system rollback segments and put them online ? Reply With Quote Quick Navigation Database Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums PHP Help General Help Newbies Database Install Coding Code Critique Upgrading PHP Discussion Echo Lounge Mods' Bods Feedback Available positions Tools Zend Studio Dreamweaver Misc Tools Misc Help ClientSide Technologies Windows Help Linux/Unix Help PHPBuilder Forum Archives « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and 1 guests) Posting Permissions You may