2 Replies Latest reply on Dec 11, 2012 3:42 PM by 961221

    ORA-00972: identifier is too long in ODI

      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.