Oracle Multimedia Is Invalid, Found IMGSIMILAR, IMGSCORE, ORDIMAGEINDEX Objects Invalid in ORDSYS Schema (Doc ID 1518750.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Multimedia - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Oracle Multimedia is invalid and the following objects are invalid as well

operator ordsys.IMGSIMILAR
operator ordsys.IMGSCORE
indextype ordsys.ORDIMAGEINDEX

These objects are deprecated in 11.2 as per the README.txt file:

"The deprecated image indexing object types and operators ORDImageIndex, IMGSimilar, and IMGScore have been removed and are no longer supported.  
Any user defined indexes of type ORDImageIndex will be deleted on upgrade from an earlier release to Oracle Database 11g, Release 2 (11.2).
"

Dropping them manually raises

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms