Invalid data type

[alison]

Hi there,

I'm trying to run a script which creates sample schemas for an Oracle Developer 6 course, it's running on a Sun Solaris box on an Oracle 9i database.

It seems to be sticking at the following create statement.

CREATE TABLE online_media
( product_id NUMBER(6)
, product_photo ORDSYS.ORDImage
, product_photo_signature ORDSYS.ORDImageSignature
, product_thumbnail ORDSYS.ORDImage
, product_video ORDSYS.ORDVideo
, product_audio ORDSYS.ORDAudio
, product_text CLOB
, product_testimonials ORDSYS.ORDDoc
) ;

ORA-00902 invalid data type.

Can anyone help

Thanks in advance

[prakashs43]

check if u have these
( ORDImage ,ORDImageSignature , ORDImage , ORDVideo
, ORDAudio , ORDDoc ) objects in ORDSYS USER .

[alison]

Hi there,

Ran the script

SELECT * FROM DBA_OBJECTS WHERE OWNER = 'ORDSYS';

Nothing like the objects you described came up, I guess we have some options missing but can you point me in the right direction.

Many thanks

[prakashs43]

to create inter media table u need to have ORDSYS USER . and have the below mentioned tables in it . and then use ( ORDImage ,ORDImageSignature , ORDImage , ORDVideo , ORDAudio , ORDDoc ) objects as datatypes in create table .

[Edited by prakashs43 on 09-18-2002 at 09:14 AM]

[alison]

Sorry but you talked about a list of tables but didn't include them in your reply, thanks for your continued help

Allie

[prakashs43]

name of the tables / objects that need to be present are ORDImage ,ORDImageSignature , ORDImage , ORDVideo , ORDAudio , ORDDoc

[m_albert137]

I just ran into the same issue. In the file "/opt/oracle/product/23ai/dbhomeFree/ord/im/admin/README.txt", it says:

Oracle Multimedia (formerly known as interMedia) was desupported in
release 19c. The component is no longer installed in new databases.

This is from the "FREE 23ai" distribution for Linux.