Wednesday, November 27, 2024

ORDSYS,ORDDATA, ORDPLUGIN and SI_INFORMTN_SCHEMA

In Oracle, Oracle Multimedia (formerly known as Oracle interMedia) is a feature to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data integrated with other enterprise information

ORDSYS -The Oracle Multimedia administrator account

ORDDATA - this account contains the Oracle Multimedia DICOM data model

ORDPLUGINS-The Oracle Multimedia user. Plug-ins supplied by Oracle and third-party, format plug-ins are installed in this schema

SI_INFORMTN_SCHEMA - The account that stores the information views for the SQL/MM Still Image Standard

 

Multimedia is deprecated in 18c. But it's still supported in this release , That said, start looking to migrate off Multimedia functionality you're using. Storing images as (securefile) BLOBs is the way to go. ou could use BFILEs. Though with these the files live outside the database

 

The following advice was given to me by Oracle Support services, to determine if either of these components are being used in the database

-- Is Multimedia being used?

 

set serveroutput on;

 @?/ord/im/admin/imremchk.sql

If you're not using this component, you will get the message returned "Oracle Multimedia is not being used".

No comments:

Post a Comment