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
ORA-00972 Identifier is too long in Optimized Jobs
Moderators: chulett, rschirm, roy