Query Errors with ORA-00978 on 19C
(Doc ID 2714782.1)
Last updated on MAY 19, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
- Query errors with ORA-00978 in 19C
- If alter the session and set optimizer_features_enable='18.1.0' and '12.1.0.2' are used, then functionality works just fine
- However, 'WITH' statement that was being used and created the result as a table - using that table in the with statement - the query runs fine with no error returned:
(query1.txt)
with t1 as (select statement_1)
select statement_2;
-> ORA-00978(query_with.txt)
create table maddedo.query_2 as select statement_1; -- success(query2.txt)
with t1 as (select * from maddedo.query_2)
select statement_2;
-- Success
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |