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
check if u have these
( ORDImage ,ORDImageSignature , ORDImage , ORDVideo
, ORDAudio , ORDDoc ) objects in ORDSYS USER .
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.
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]
Sorry but you talked about a list of tables but didn't include them in your reply, thanks for your continued help
name of the tables / objects that need to be present are ORDImage ,ORDImageSignature , ORDImage , ORDVideo , ORDAudio , ORDDoc