1) Start SQL*Plus and connect as SYSDBA.
2) Invoke the imdinst.sql script to render Oracle interMedia inactive:
-> SQL> @
@
3) Drop all tables and types that depend on interMedia object types.
4) Invoke the imdtyp.sql script to drop all the interMedia object types.
-> SQL> @
@
Encounter the following error message in 9.2.0.5 when running imdtyp.sql. Problem solved by re-run it.
More info about the dependencies example can be found here
SQL> @imdtyp
Session altered.
Type dropped.
Type dropped.
Type dropped.
Type dropped.
Type dropped.
Type dropped.
Indextype dropped.
Operator dropped.
Operator dropped.
Function dropped.
Function dropped.
Type dropped.
drop type ORDSYS.ORDImageSignature
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
Type dropped.
drop type ORDSYS.ORDImage
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
drop type ORDSYS.ORDIMGB
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
drop type ORDSYS.ORDIMGF
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
drop type ORDSource
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents