Hi all,
Would appreciate your expert advice on one of the issue I am facing.
While loading oracle table using oraoci stage I am getting the below error message in
DEV environment:(NLS not installed)
Error:
At row "ROW NUMBER" , link "LINK_NAME"
Inserted value too large for column, row rejected
(It does not give me any field name)
PROD environment: (NLS installed)
Error:
ORA-12899: value too large for column
FIELD NAME(actual: 11, maximun :10)
I know there is an issue but could not pinpoint where the issue exactly might be, could it be on the database side or on the datastage side. Will appreciate your help in troubleshooting the issue.
ORACLE version 11g running on both dev and prod environments.
Thanks,
gp
Error message diff between dev and prod environment
Moderators: chulett, rschirm, roy
Error message diff between dev and prod environment
Last edited by padma on Mon Nov 30, 2015 5:50 pm, edited 1 time in total.