sql loader

From: Mohammed Mehraj Hussain <mhdmehraj_at_gmail.com>
Date: Fri, 18 Dec 2009 14:31:18 +0530
Message-ID: <b081c0a50912180101l6ef4a1a3x40077673ad6dbf36_at_mail.gmail.com>



Hi all,

we have some few long datatype columns.
while unloaded the table which contains long columns usinf a third part tool (fast reader) , it makes the control file as below .

UNRECOVERABLE
 LOAD DATA
INFILE "IP_PHD_PRDCTN_MODULE_00.dat" "str X'2b0a'" BADFILE "IP_PHD_PRDCTN_MODULE_00.bad"

DISCARDFILE "IP_PHD_PRDCTN_MODULE_00.dis"

APPEND
PRESERVE BLANKS INTO TABLE TOTALPLANT.IP_PHD_PRDCTN_MODULE   FIELDS TERMINATED BY X'2a26' TRAILING NULLCOLS

(
"MODULE_NAME" CHAR(128) OPTIONALLY ENCLOSED BY '"',
"MODULE_TYP" CHAR(4) OPTIONALLY ENCLOSED BY '"',
LobFile2 FILLER char,
"MODULE_TEXT" LOBFILE(LobFile2) TERMINATED BY EOF NULLIF LobFile2 = ' '
)

this is my table structure :

SQL> desc IP_PHD_PRDCTN_MODULE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 MODULE_NAME                               NOT NULL VARCHAR2(32 CHAR)
 MODULE_TYP                                NOT NULL VARCHAR2(1 CHAR)
 MODULE_TEXT                               NOT NULL LONG

when iam loadind this table back to my db iam getting the following error.

D:\OUTPUT>sqlldr totalplant/bflex_at_totalplant control=IP_PHD_PRDCTN_MODULE.ctl direct=*true* errors=10000 readsize=1048576 log=IP_PHD_PRDCTN_MODULE.log

SQL*Loader: Release 10.2.0.4.0 - Production on Fri Dec 18 12:49:39 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL*Loader-418: Bad datafile datatype *for* column "MODULE_TEXT"

Its seems to be like the problem with Long database ,

can you please explain on this issue.

-- 
Regards,
H.Mohammed Mehraj Hussain
Oracle DBA,
Honeywell Technology Solutions,

--“Please consider the environment before printing this email”--
Lets Go Green.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 18 2009 - 03:01:18 CST

Original text of this message