Upgrade From 12C To 18C (18.3) - ORA 942 Errors Are Observed
(Doc ID 2701367.1)
Last updated on NOVEMBER 13, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
- After an upgrade to 18C, one of the pl/sql block is failing and throwing a 942 Error in one of the sql which is dynamically generating:
PARSE ERROR #140737245922752:len=207 dep=2 uid=63 oct=3 lid=63 tim=2418737549978 err=942<<<<
SELECT distinct TBL$OR$IDX$PART$NUM("ENTITY_.....) ORDER BY 1
about to signal 942
Database upgrade to 18C from 12C.
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