Invalid data type
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Invalid data type

  1. #1
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    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
    What's the sound of one hand clapping - "CL"

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    check if u have these
    ( ORDImage ,ORDImageSignature , ORDImage , ORDVideo
    , ORDAudio , ORDDoc ) objects in ORDSYS USER .
    siva prakash
    DBA

  3. #3
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    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
    What's the sound of one hand clapping - "CL"

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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]
    siva prakash
    DBA

  5. #5
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Sorry but you talked about a list of tables but didn't include them in your reply, thanks for your continued help

    Allie
    What's the sound of one hand clapping - "CL"

  6. #6
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    name of the tables / objects that need to be present are ORDImage ,ORDImageSignature , ORDImage , ORDVideo , ORDAudio , ORDDoc
    siva prakash
    DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width