My Oracle Support Banner

Invalid objects under ORDSYS after downgrade to 9.2 (Doc ID 552849.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Multimedia - Version: to - Release: 10.2 to 10.2
Information in this document applies to any platform.


Downgrading from 10.2 to 9.2, the following objects are invalid after downgrade:

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ ---------------
ORDSYS     IMGSCORE                       OPERATOR
ORDSYS     IMGSIMILAR                     OPERATOR
ORDSYS     SCOREFUNC                      FUNCTION
ORDSYS     SIMILARFUNC                    FUNCTION

The logfile generated during downgrade may show the following errors:

    ERROR at line 1:
    ORA-04045: errors during recompilation/revalidation of ORDSYS.ORDIMGIDXMETHODS
    ORA-06545: PL/SQL: compilation error - compilation aborted
    ORA-06550: line 0, column 0:
    PLS-00908: The stored format of ORDIMGIDXMETHODS is not supported by this release
    ORA-06550: line 0, column 0:
    PLS-00707: unsupported construct or internal error [2603]
    ORA-06550: line 0, column 0:
    PLS-00565: ORDIMGIDXMETHODS must be completed as a potential REF target (object type)


Downgraded from 10.2. to 9.2


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

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