PL/SQL (MOSC)

MOSC Banner

Getting PL/SQL: ORA-02289: sequence does not exist

edited Sep 12, 2013 6:51AM in PL/SQL (MOSC) 4 commentsAnswered ✓
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center