Hi All,
I received an error while running a script. Basically, this is an application-generated script (by Oracle ODI) to partition a table in a data warehouse:
SQL> @Create_Partitioned_Table.sql
Table renamed.
Table created.
,JOURNAL_LINE_DESCR
*
ERROR at line 334:
ORA-12899: value too large for column
"W_GL_OTHER_F"."JOURNAL_LINE_DESCR" (actual: 241, maximum: 240)
I am now trying to find out the data which is causing the error. I tried this SQL, but it didn't return anything:
select JOURNAL_LINE_DESCR from I$_66747501
where length(JOURNAL_LINE_DESCR) > 240;
Any ideas what is going on?
Note: I have run this script before, for a different table, and it worked fine (albeit, syntax is was particular to that table ... but all else should be the same).
DB version 12.1.0.2
Regards,
Charles