My Oracle Support Banner

Upgrade 12.1 to 12.2 Reports ORA-38824: A CREATE OR REPLACE Command May Not Change The EDITIONABLE Property (Doc ID 2326621.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Received an ORA-38824 during Upgrading Production database from 12.1.0.2 to 12.2.0.1 . 

 


21:14:29 SQL>
21:14:29 SQL> Rem *************************************************************************
21:14:29 SQL> Rem End Bug 22100322 https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=22100322 https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=22100322: Increase epg$_auth.dadname size
21:14:29 SQL> Rem *************************************************************************
21:14:29 SQL> Rem =========================================================================
21:14:29 SQL> Rem BEGIN upgrade unsharded Queue View
21:14:29 SQL> Rem =========================================================================
21:14:29 SQL>
21:14:29 SQL> DECLARE
21:14:29 2 BEGIN
21:14:29 3
21:14:29 4 FOR cur_rec IN (
21:14:29 5 SELECT t.schema, t.name, t.flags, q.eventid
21:14:29 6 FROM system.aq$_queue_tables t, system.aq$_queues q
21:14:29 7 WHERE t.objno = q.table_objno and NVL(q.sharded,0) =0
21:14:29 8 )
21:14:29 9 LOOP
21:14:29 10 BEGIN
21:14:29 11 IF cur_rec.name != 'AQ$DEF$_AQCALL' and cur_rec.name != 'DEF$_AQERROR' THEN
21:14:29 12 IF bitand(cur_rec.flags, 1) = 1 THEN -- multi-consumer queue
21:14:29 13 sys.dbms_prvtaqim.create_base_view(cur_rec.schema, cur_rec.name, cur_rec.flags);
21:14:29 14 ELSE -- singleconsumer queue
21:14:29 15 sys.dbms_aqadm_sys.create_base_view(cur_rec.schema, cur_rec.name, cur_rec.flags);
21:14:29 16 END IF;
21:14:29 17 END IF;
21:14:29 18 END;
21:14:29 19 END LOOP;
21:14:29 20 EXCEPTION
21:14:29 21 WHEN OTHERS THEN
21:14:29 22 DBMS_SYSTEM.ksdwrt(DBMS_SYSTEM.trace_file,
21:14:29 23 'error in unsharded view creation' || sqlcode);
21:14:29 24 RAISE;
21:14:29 25 END;
21:14:29 26 /
DECLARE
*
ERROR at line 1:
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.
ORA-06512: at line 24
ORA-06512: at "SYS.DBMS_AQADM_INV", line 88
ORA-06512: at "SYS.DBMS_AQADM_INV", line 51
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2169
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1818
ORA-06512: at line 15
ORA-06512: at line 15

Changes

Upgrading from 12.1.0.2 to 12.2.0.1

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.