Column Name too long
556981Apr 11 2009 — edited Mar 30 2011While loading the data from XML source I am getting following error
ORA-00972: identifier is too long
I understand that some of the Column name are more then 30 char (Oracle Limit) inmy source but I like to know what needs
to be modified in the IKM to pick only first thirty characters of column name in case of column name is more then 30 Char.
The LKM works fine as it take only the first 30 char to create the table name, I think it take that setting from topology manger.
but what need to modify in IKM to take only first 30 char for column name.
I am creating target table on the fly and I dont wanna modify each column name in the target table, It'll be alot of work for me.
Please let me know your thoughts on this.
Thanks