Getting PL/SQL: ORA-02289: sequence does not exist
Hi All,
First off, setup:
instanceA : Oracle 10gR2 Standard 64bit solaris
instanceB : Oracle 10gR2 Standard 64bit linux
instanceA2 : Oracle 11gR2 Standard 64bit linux, replacement of instanceA
The code runs on instanceB and accesses sequence on instanceA via link using a synonym SYN4SEQ_NAME.
We had this code in place and working for last few years.
Now as we plan to move on to instanceA2, testing shows this peice of code does not compile and returns
"PL/SQL: ORA-02289: sequence does not exist"
GLOBAL_NAMES is FALSE on all systems.
If I create a local sequence on instanceB, code compiles - but that is not acceptable as sequence must reside on instanceA2.
0