19c :postupgrade_fixups.sql fails with error "ORA-04023: Object with segments as .."
(Doc ID 2650211.1)
Last updated on MARCH 18, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Database successfully upgraded to 19c .But executing postupgrade_fixups.sql fails with error:
Package body created.
ERROR at line 1:
ORA-04023: Object with
segments as (select tablespace_name, inuse from(
row_number() over (partition by tablespace_name order by 1) rn,
round(nvl(sum(ds.bytes) over (partition by ds.tablespace_name),0)/:a,2) as inuse
from sys.dba_segments ds) where rn =1 ),
ts_qresult as (
SELECT /*+ MATERIALIZE */
dt.tablespace_name as name,
dt.contents could not be validated or authorized
ORA-06512: at "SYS.DBMS_PREUP", line 4086
ORA-06512: at "SYS.DBMS_PREUP", line 10540
ORA-06512: at line 11
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