DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: export errors - urgent please

  1. #1
    Join Date
    Feb 2003
    Posts
    67

    export/import errors - urgent please

    I exported a schema and importing into another user in the same database and I am getting all kinds of errors like this:

    "CREATE TYPE "CHAR_ARR" TIMESTAMP '2003-03-02:14:03:34' OID 'AACE9C282EFE4BA"
    "4E03400005A997EA4' "
    " IS TABLE OF VARCHAR2(50)"
    " INDEX BY BINARY_INTEGER;"


    Did anyone see this before?
    Last edited by sureshot; 06-27-2003 at 11:32 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    where is the errors?
    Giani

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    You are having import errors, not export errors. Please list the error message.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Feb 2003
    Posts
    67
    11500 lines of this:

    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "CHAR_ARR" TIMESTAMP '2003-03-02:14:03:34' OID 'AACE9C282EFE4BA"
    "4E03400005A997EA4' "
    " IS TABLE OF VARCHAR2(50)"
    " INDEX BY BINARY_INTEGER;"
    "CREATE PROCEDURE test_valid_product_code (product_code IN VARCHAR2,"
    " compare_date IN VARCHAR2,"
    " auto_workman_comp_ind OUT char_arr,"
    " destination OUT char_arr)"
    "AS"
    " retVal VARCHAR2(8);"
    " i INTEGER := 0;"
    " CURSOR product_code_cur IS"
    " select auto_wc_ind,"
    " destination"
    " from PROD_RTNG"
    " where prod_cd = product_code"
    " and TO_DATE(compare_date, c_date_fmt) >= NVL(eff_dt, c_early_dt)"
    " and TO_DATE(compare_date, c_date_fmt) <= NVL(trmn_dt, c_future_dt);"
    "BEGIN"
    " OPEN product_code_cur;"
    " LOOP"
    " i := i+1;"
    " FETCH product_code_cur into"
    " auto_workman_comp_ind(i), destination(i);"
    " EXIT WHEN product_code_cur%NOTFOUND ;"
    " END LOOP;"
    " CLOSE product_code_cur;"
    "END test_valid_product_code;"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "COLT" TIMESTAMP '2003-03-04:19:06:17' OID 'AB943B9930FA695DE03"
    "400005A997EA4' "
    " AS OBJECT"
    "(NAME VARCHAR2(50),"
    " VALUE VARCHAR2(50)"
    ")"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "COL_ARR" TIMESTAMP '2003-03-04:19:06:17' OID 'AB943B9930FE695D"
    "E03400005A997EA4' "
    " AS TABLE OF COLT"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "DUMMYOBJ" TIMESTAMP '2003-03-04:19:06:18' OID 'AD373FAA867C07D"
    "EE03400005A997EA4' "
    " AS OBJECT ("
    " f1 NUMBER,"
    " f2 NUMBER,"
    " MEMBER PROCEDURE Method1(x IN VARCHAR2),"
    " MEMBER FUNCTION Method2 RETURN DATE"
    ")"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "NVARR" TIMESTAMP '2003-03-04:19:06:18' OID 'AB90A84606422D12E0"
    "3400005A997EA4' "
    " "
    " AS TABLE OF NVPAIR"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "NVPAIR" TIMESTAMP '2003-03-04:19:06:18' OID 'AB90A846063E2D12E"
    "03400005A997EA4' "
    " "
    " AS OBJECT"
    "(NAME VARCHAR2(50),"
    " VALUE VARCHAR2(50))"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:
    "CREATE TYPE "ROW_ARR" TIMESTAMP '2003-03-04:19:06:18' OID 'AB943B993103695D"
    "E03400005A997EA4' "
    " IS VARRAY(100) OF COL_ARR"
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Just for your information, this is your error:
    IMP-00003: ORACLE error 2304 encountered
    ORA-02304: invalid object identifier literal
    IMP-00017: following statement failed with ORACLE error 2304:


    Another object probably already exists in your database with this Object identifier.
    Jeff Hunter

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Did you set ignore=y, do these objects already exist?

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    Hope ignore=Y would helps but if it doesn't go to :
    http://asktom.oracle.com/pls/ask/f?p...4540782494895,
    Giani

  8. #8
    Join Date
    Dec 2000
    Posts
    138
    This is documented in Oracle Metalink.This happens if you are exporting and importing in the same machine. because the object identifier already exists there. either you can recreate them or take all the types and remove the OID CLAUSE and run it again. or drop the Types if its not needed anymore from the existing schema.

    HTH.
    -dharma

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