My Oracle Support Banner

Upgrade to 18.7 fails with ORA-02303: cannot drop or replace a type with type or table dependents for Multimedia component (Doc ID 2609932.1)

Last updated on APRIL 24, 2020

Applies to:

Oracle Multimedia - Version 11.2.0.3 to 19.3.0.0.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Following error is reported during database upgrade to 18.7

Start of Summary Report------------------------------------------------------

Oracle Database Release 18 Post-Upgrade Status Tool    10-16-2019 20:55:5

Component                               Current         Full     Elapsed Time
Name                                    Status          Version  HH:MM:SS

Oracle Server                          UPGRADED      18.7.0.0.0  00:31:15
JServer JAVA Virtual Machine              VALID      18.7.0.0.0  00:03:43
Oracle XDK                             UPGRADED      18.7.0.0.0  00:00:41
Oracle Database Java Packages          UPGRADED      18.7.0.0.0  00:00:16
Oracle Text                            UPGRADED      18.7.0.0.0  00:00:50
Oracle Workspace Manager               UPGRADED      18.7.0.0.0  00:01:18
Oracle Real Application Clusters       UPGRADED      18.7.0.0.0  00:00:00
Oracle XML Database                    UPGRADED      18.7.0.0.0  00:02:53
Oracle Multimedia 

ORA-02303: cannot drop or replace a type with type or table dependents

ORA-06512: at line 16
ORA-06512: at line 8

   ORA-06512: at line 16 ORA-06512: at line 8

   ORA-06512: at line 8
Oracle Multimedia                       INVALID      18.7.0.0.0  00:04:05
Upgrade Datapatch                                                00:02:10
Final Actions                                                    00:05:08
Post Upgrade                                                     00:01:02
Post Upgrade Datapatch                                           00:01:48

Total Upgrade Time: 00:53:58

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.