ORA-00972 Identifier is too long in Optimized Jobs

wbeitler · Post by **wbeitler** » Thu Oct 04, 2012 3:35 am

Hi all,

we're planning to use the balanced optimizer functionality frrom within our 8.7 setup. We're now encountering the ORA-00972-error simply because the optimized job has rewritten an insert to an 'insert into as select', but uses the linknames (>30 chars....) as an alias

Can't be that we have to rename all linknames > 30 chars to get this up and running... So kind of looking for the hidden magic APT-parameter or Balanced Optimizer option to prevent linknames being used for aliasing ?!

thanks,

William

chulett · Post by **chulett** » Thu Oct 04, 2012 7:31 am

If I had to guess (and I do) I'd say you are looking for a patch.

wbeitler · Post by **wbeitler** » Thu Oct 04, 2012 9:11 am

PMR is logged at IBM. I'll keep you posted.

William

wbeitler · Post by **wbeitler** » Mon Oct 29, 2012 4:25 am

Reply from IBM on this one: Works as designed. Now trying to get the design altered...

William

wbeitler · Post by **wbeitler** » Wed Jan 30, 2013 3:58 am

patch_JR44518 did the job...

chulett · Post by **chulett** » Wed Jan 30, 2013 7:57 am

Thanks for updating us!