CODEWITHSUNDEEP
sqloracle10gsqlplussql-loader
Navy
Navy

Reputation: 59

SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued

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: 1048576

Total logical records skipped:          0
Total logical records rejected:         1
Total logical records discarded:        0

Run began on Wed Mar 27 10:26:52 2013
Run ended on Wed Mar 27 10:27:01 2013

Elapsed time was:     00:00:09.17
CPU time was:         00:00:00.03

Please tell me where I am going wrong?, I cannot display the data from Incl_C.dat.

Upvotes: 0

Views: 9160

Answers (2)

Pierre-Jean MEUNIER
Pierre-Jean MEUNIER

Reputation: 1

This also happened to me when the Tablespace which contained the index of my table in which I uploaded data was FULL. I extended that Tablespace and error went away.

Upvotes: 0

user2499378
user2499378

Reputation: 1

It seems the tablespace is full.

Here is my code:

  select a.tablespace_name,
       a.bytes / 1024 / 1024 "Sum MB",
       (a.bytes - b.bytes) / 1024 / 1024 "used MB",
       b.bytes / 1024 / 1024 "free MB",
       round(((a.bytes - b.bytes) / a.bytes) * 100, 2)||'%' "percent_used"
  from (select tablespace_name, sum(bytes) bytes
          from dba_data_files
         group by tablespace_name) a,
       (select tablespace_name, sum(bytes) bytes, max(bytes) largest
          from dba_free_space
         group by tablespace_name) b
 where a.tablespace_name = b.tablespace_name
 order by ((a.bytes - b.bytes) / a.bytes) desc

Upvotes: 0

Related Questions