Database Upgrade To 19c Fails on Type ST_CIRCULARSTRING (Doc ID 2670343.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On an upgrade from 12.1.0.2 to 19c with DBUA, the upgrade always fails at a spatial type -

CREATE OR REPLACE TYPE ST_CIRCULARSTRING

The upgrade log shows the following

14:37:54 341 EXECUTE IMMEDIATE '
14:37:54 342 CREATE OR REPLACE TYPE ST_CIRCULARSTRING
14:37:54 343 OID ''4BA3494AB402E5B6E040578CB2057856'' UNDER ST_CURVE (
14:37:54 344 CONSTRUCTOR FUNCTION ST_CIRCULARSTRING(apointarray ST_Point_Array)
14:37:54 345 RETURN SELF AS RESULT,
14:37:54 346 CONSTRUCTOR FUNCTION ST_CIRCULARSTRING(apointarray ST_Point_Array,
14:37:54 347 asrid INTEGER) RETURN SELF AS RESULT,
14:37:54 348
14:37:54 349 MEMBER FUNCTION ST_Points(apointarray ST_Point_Array)
14:37:54 350 RETURN ST_CircularString)';
14:37:54 351 exception
14:37:54 352 when others then
14:37:54 353 SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE,
14:37:54 354 'EXCEPTION[sdogmmh.sql(' || $$PLSQL_LINE || ')41]: ' || SQLERRM); RAISE;
14:37:54 355 end;

declare
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
ORA-06512: at line 354
ORA-06512: at line 341

Cause

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