My Oracle Support Banner

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 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Database successfully upgraded to 19c .But executing postupgrade_fixups.sql fails with error:

SQL> @postupgrade_fixups.sql

..

..

Package body created.

No errors.

DECLARE

*

ERROR at line 1:

ORA-04023: Object with

segments as (select tablespace_name, inuse from(

select ds.tablespace_name,

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

Session altered.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.