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 17, 2023
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 |