I am Having a problem loading a datafile using SQLLOADER.
I really don't know what the problem is. The Control File? The Datafile? Can Someone help me out? Here is the control file, datafile and error message I am getting.
Datafile:
1234567890002HSBCI Frank's CO
1334567890002HSBCI JJ's CO
1434567890002HSBCI JOHNS's CO
1534567890002HSBCI MARKS's CO
Table layout:
SQL> desc cust
Name Null? Type
------------------------------- -------- ----
ACCT_NO NOT NULL CHAR(10)
BANK_NO NOT NULL CHAR(3)
FEED NOT NULL VARCHAR2(16)
PROFIT_CENTER NOT NULL VARCHAR2(6)
ACCT_OFFICER CHAR(3)
NAME VARCHAR2(40)
ADDR VARCHAR2(160)
ICB_FLAG CHAR(1)
PRINT_SUPPRESS_FLAG CHAR(1)
COMA_STATEMENT_FLAG CHAR(2)
STOP_HOLD_FLAG VARCHAR2(2)
ACCT_STATUS CHAR(2)
ACCT_TYPE CHAR(2)
SEND_STMNT_TO_PARENT CHAR(1)
LAST_TXN_DATE DATE
CREATE_TIME NOT NULL DATE
DDA_INSERT_TIME DATE
PENDING CHAR(1)
PARENT_ACCT_NO CHAR(10)
PARENT_BANK_NO CHAR(3)
PASSWORD VARCHAR2(8)
Control file:(loadcust.txt)
LOAD DATA
INFILE 'sqltest.dat'
INTO TABLE CUST
(ACCT_NO POSITION(1:10) CHAR,
BANK_NO POSITION(11:13) CHAR,
FEED POSITION(14:18) CHAR,
ADDR POSITION(28:37) CHAR,
ICB_FLAG CONSTANT "0",
PRINT_SUPPRESS_FLAG CONSTANT "0",
CREATE_TIME SYSDATE,
DDA_INSERT_TIME SYSDATE,
PENDING CONSTANT "V")
ERROR MESSAGE:
SQL*Loader-524: partial record found at end of datafile (loadcust.txt)
loadcust is my control file
and there are no blank lines on my datafile.
