sql loader
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-lReceived on Fri Dec 18 2009 - 03:01:18 CST