Analytics Software

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!

Table Length Issue in ODI

user12005706Mar 28 2012 — edited Apr 12 2012

Hi There,

I have an issue while running an interface in ODI 11g.

There is a step in my interface where it creates unique index.
It usually takes the table name and prefixes with 'I$_' and suffix with '_x'
Example of my index is *'I$_Tablename_x'* if the table name is 30 charcaters then the index name will be 35 charcters which is not allowed in oracle . Hence giving an error in interface.
So i Went to topolgoy -> physical architecture -> oracle -> others and changed the table name and column name length to 25.

However when i run the interface again the table name is getting stripped to 25 charcters hence giving an error "ORA-00942: table or view does not exist" which makes sense.

Please help me to overcome this issue.

Thanks,
Babu.

This post has been answered by 929366 on Apr 9 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2012

Added on Mar 28 2012

#business-intelligence-applications, #data-integrator, #system-management-and-integration

10 comments

4,725 views