Explain Plan Fails with ORA-00604 and ORA-02289
(Doc ID 2716699.1)
Last updated on DECEMBER 11, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- Explain Plan for statement fails with an ORA-00604 and ORA-02289 error:
SQL> connect scott/tiger
SQL> explain plan for
2 select * from emp;
select * from emp
ERROR at line 2:
ORA-00604: error occurred at recursive SQL level 1
ORA-02289: sequence does not exist
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document