Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2012
Added on Mar 28 2012
10 comments
4,713 views