Archives of the TeradataForum
Message Posted: Wed, 23 Oct 2002 @ 01:38:50 GMT
I am trying to load a column from Oracle that is of type CLOB. When i use Ole Load, CLOB is converted to VARCHAR 64000. The following error message is generated.
**** 12:34:49 Number of recs/msg: 1 **** 12:34:49 Starting to send to RDBMS with record 1 **** 12:34:49 Bad file or data definition. **** 12:34:49 The length of: PROFILE in row: 2 was greater than defined. Defined: 64000, Received: 64001
Structure in Oracle.
Name Null? Type USER_ROLE_ID NOT NULL VARCHAR2(22) USER_ROLE_DESC NOT NULL VARCHAR2(15) PROFILE CLOB
How do i overcome this issue? I tried using LONG VARCHAR instead of VARCHAR(64000), but the same error message was displayed.
In another instance, of loading a table i encountered this error(below). How do i increase the maximum row length/size? Can it be done or is it fixed to 64K.....
**** 09:32:28 Current CLI or RDBMS allows maximum row size: 64K **** 09:32:30 RDBMS error 3933: The Maximum Possible Row Length in the Table is too Large.
Hope to hear from you soon.
P.s Please reply ASAP....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|