2 Replies Latest reply: Dec 11, 2012 9:42 AM by 961221 RSS

    ORA-00972: identifier is too long in ODI

    716454
      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