Query Errors with ORA-00978 on 19C
(Doc ID 2714782.1)
Last updated on APRIL 09, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
- Query errors with ORA-00978 in 19C
- If alter the session and set optimizer_features_enable='18.1.0' and '188.8.131.52' 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:
with t1 as (select statement_1)
create table maddedo.query_2 as select statement_1; -- success
with t1 as (select * from maddedo.query_2)
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