Wednesday, 23 July 2014

ODI Errors - ORA-00972 Identifier is too Long

ORA-00972 Identifier is too Long

Oracle Database Object Names Max it will accept 30 Characters Only.  So We need consider this while
Creating  $ temporary tables at staging level.   If you are hard-coding any value at Physical Schema level

like  I$_STG or  I$_SESSION_NO it should not exceed more than 30 characters.


No comments:

Post a Comment