DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00972: identifier is too long in ODI

716454Sep 14 2009 — edited Dec 11 2012

I am loading the oracle db data in XML datastore in odi then 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) in my source but I like to know what needs
to be modified in the IKM and LKM.

I have also fixed the Maximum table name length and Maximum column name length
under Oracle technology in Topology Manager.

Please let me know your thoughts on this.

Thanks
RA

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2013

Added on Sep 14 2009

#general-xml, #xml

2 comments

3,489 views