import error for object type
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: import error for object type

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    Philippines
    Posts
    42

    Question

    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "TUXDATA_TXNID" TIMESTAMP '2002-04-03:16:00:27' OID '9DBA957C71"
    "6C3028E034080020FEC01A' AS VARRAY(25) OF number(12)"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "TUXDATA_RECSEQ" TIMESTAMP '2002-04-03:16:00:27' OID '9DBA957C7"
    "16F3028E034080020FEC01A' AS VARRAY(25) OF number"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal


    how do i go about this?

    thanks for the help,
    mel

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Did you try this and how did you import:

    ORA-02304 invalid object identifier literal
    Cause: An attempt was made to enter an object identifier literal for CREATE
    TYPE that is either:
    * Not a string of 32 hexadecimal characters
    * An object identifier that already identifies an existing object
    * An object identifier different from the original object identifier already assigned to the type
    Action: Do not specify the object identifier clause or specify a 32
    hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Feb 2001
    Posts
    82
    Just dont mind that error. You can approach anton if you have questions.....

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