Hi,
We are using Oracle 10g database UTF-8 complaint. We created a simple table with 4 columns of Varchar2(4000) and created Synonym. We created a Fex against that table and it is raising an error: (FOC336) THE SUM OF ALL FIELD LENGTHS EXCEEDS MAXIMUM.
eventhough the total length of all the columns < 37000 limit

FILENAME=test_length, SUFFIX=SQLORA , $
SEGMENT=TEST_LENGTH, SEGTYPE=S0, $
FIELDNAME=COL1, ALIAS=COL1, USAGE=A4000, ACTUAL=A4000,
MISSING=ON, $
FIELDNAME=COL2, ALIAS=COL2, USAGE=A4000V, ACTUAL=A4000VB,
MISSING=ON, $
FIELDNAME=COL3, ALIAS=COL3, USAGE=A4000V, ACTUAL=A4000VB,
MISSING=ON, $
FIELDNAME=COL4, ALIAS=COL4, USAGE=A4000V, ACTUAL=A4000VB,
MISSING=ON, $

Is there any setting we need to change to make this work?

Thanks,
DD

This message has been edited. Last edited by: Kerry,

Did you run this against the table and see the total length?

CHECK FILE test_length

Thanks Prairie.
I have opened a case with IBI. Since we are in UTF8 environment, each charater will become 3 chars in IBI. So we need to do Substr while creating database view. They said that the size limit will be increased to 256K in Rel8.0