-
I am having problems using sqloader
I want to load a data file into a table and set one column of the table to be a literal that I assign. It is not working Here is what am am doing and the error message can someone help me?
table desc.:Table name = abc
COL1 VARCHAR2(5)
COL2 CHAR(5)
COL3 DATE
table as is now:
COL1 COL2 COL3
----- ----- ---------
JOHN A 19-JAN-01
leon B 19-JAN-01
datafile:
frank
john
tim
al
tom
art
mark
larry
control file :
LOAD DATA
INFILE 'sqltestload.DAT'
APPEND
INTO TABLE abc
(col1 position(1:5) CHAR,
col2 "D")
this is the error that I'm getting in the log file
Control File: control.ctl
Data File: sqltestload.DAT
Bad File: sqltestload.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 ABC, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
COL1 1:5 5 CHARACTER
COL2 NEXT 1 CHARACTER
SQL string for column : "D"
Record 1: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 2: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 3: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 4: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 5: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 6: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 7: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Record 8: Rejected - Error on table ABC, column COL2.
ORA-00984: column not allowed here
Table ABC:
0 Rows successfully loaded.
8 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: 65532 bytes(5461 rows)
Space allocated for memory besides bind array: 0 bytes
Total logical records skipped: 0
Total logical records read: 8
Total logical records rejected: 8
Total logical records discarded: 0
Run began on Fri Jan 19 13:59:50 2001
Run ended on Fri Jan 19 13:59:50 2001
Elapsed time was: 00:00:00.15
CPU time was: 00:00:00.08
-
Try the following control file
LOAD DATA
INFILE 'sqltestload.DAT'
APPEND
INTO TABLE abc
(col1 position(1:5) CHAR,
col2 CONSTANT "D")
Soumya
still learning
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|