fload error

Tools
Enthusiast

fload error

Hi,
These are my fast export and fast load sripts which I am trying to use to load from one table to the other. The definition of the source table was copied to create the target table. But still I get the error as:

##################################################################
===================================================================
= =
= Insert Phase =
= =
===================================================================

0011 INSERT database2.tablename.*;

**** 21:12:19 Number of recs/msg: 431
**** 21:12:19 Starting to send to RDBMS with record 1
**** 21:12:19 RECORD is too long by 134 byte(s)

####################################################################

These are the scripts:

Fast Export:
============
.LOGTABLE logtablename;
.LOGON database1/uname,pwd;
.BEGIN EXPORT ;
.EXPORT OUTFILE filename format binary;
locking tablename for ACCESS
select * from databasename1.tablename sample 20000;
.END EXPORT;
.LOGOFF;

#################
FastLoad
#################
SESSIONS 4;
RECORD 1 THRU 20000;
ERRLIMIT 25;
LOGON database2/uname,pwd;
DROP TABLE Error1;
DROP TABLE Error2;
SHOW;
BEGIN LOADING tablename2
ERRORFILES Error1,Error2
CHECKPOINT 10000;
DEFINE FILE = filename;
INSERT database2.tablename.*;
END LOADING;
LOGOFF;

Please let me know if you have seen this before and know the solution to my problem.
Thanks.
1 REPLY
Enthusiast

Re: fload error

Hi,
First try to load the data into new table using

insert into sel * from .

If this succeeds then try to debug the fast Load and fast export..
With the that we come to know the compatibilty of the table structures.

Regds,
Sachin