Re: SQL Loader Headache!

From: <liam_2e_at_my-deja.com>
Date: 2000/03/05
Message-ID: <89u1f6$56e$1@nnrp1.deja.com>

Here is the LOG file

SQL*Loader: Release 8.1.5.0.0 - Production on Sun Mar 5 11:20:58 2000

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Control File:   d:\control\publisher\publisher.ctl
Data File:      d:\control\publisher\publisher.out
  Bad File:     d:\control\publisher\publisher.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 65536 bytes
Continuation:    none specified
Path used:      Conventional

Table PUBLISHER, loaded from every logical record. Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- --------------
-------
PUB_ID                               1:28    28
CHARACTER
PUB_NM                              11:50    40
CHARACTER
PHONE_NO                            51:60    10
CHARACTER
CITY_NM                             71:89    19
CHARACTER
STATE_CD                            91:92     2
CHARACTER
ZIP_CD                              93:97     5
CHARACTER
ZIP_CD_EXT                         98:101     4
CHARACTER
ADDRESS1_TXT                      102:132    31
CHARACTER
ADDRESS2_TXT                      132:161    30
CHARACTER
FAX_NO                            162:181    20

CHARACTER Record 1: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 2: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 3: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 4: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 5: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 6: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 7: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 8: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 9: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 10: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 11: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 12: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 13: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 14: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 15: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 16: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 17: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 18: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 19: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 20: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 21: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 22: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 23: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 24: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 25: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 26: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 27: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 28: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 29: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 30: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 31: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 32: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 33: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 34: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 35: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 36: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 37: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 38: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 39: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 40: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 41: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 42: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 43: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 44: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 45: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 46: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 47: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 48: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 49: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Record 50: Rejected - Error on table PUBLISHER, column PUB_ID. ORA-01722: invalid number

Table PUBLISHER:
  0 Rows successfully loaded.
  50 Rows 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:                  65508 bytes(309 rows)
Space allocated for memory besides bind array:        0 bytes

Total logical records skipped:          0
Total logical records read:            50
Total logical records rejected:        50
Total logical records discarded:        0

Run began on Sun Mar 05 11:20:58 2000
Run ended on Sun Mar 05 11:21:19 2000

Elapsed time was:     00:00:20.98
CPU time was:         00:00:00.16

Thanks for the help Liam

In article <89tssh$26o$1_at_nnrp1.deja.com>,   Thomas J. Kyte <tkyte_at_us.oracle.com> wrote:
> In article <89s4gk$u8r$1_at_nnrp1.deja.com>,
> liam_2e_at_my-deja.com wrote:
> > Hello Everyone
> >
> > I am currrently trying load data in to that have Foreign Keys and I
 am
> > unable to do it. I have several tables in the schema that I am
 working
> > on that don't take any foreign keys and I was able to load the data
> > without any problem. Now that I am gettting to the tables that
 recieve
> > foreign keys they will not load! I am doing everything the same and
 all
> > of the tables which supply the current table with foreign keys are
> > loaded. What is even more frustrating is that I am not getting any
> > error messages the command prompt says that the records were loaded.
> > When I check the table in sql plus nothing was loaded. Here is my
> > control file and a clip of the dat. Thanks for the help!! Liam
> >

>

> What does the .log file say? The command line interface says how many
> records were read from the input file -- not how many loaded. The log
> file will reveal all.

>


> --

> Thomas Kyte                              tkyte_at_us.oracle.com

> Oracle Service Industries
> http://osi.oracle.com/~tkyte/index.html
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corp

>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Mar 05 2000 - 00:00:00 CST