Printable View
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?
where is the errors?:confused:
You are having import errors, not export errors. Please list the error message.
MH
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:
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.
Did you set ignore=y, do these objects already exist?
MH
Hope ignore=Y would helps but if it doesn't go to :
http://asktom.oracle.com/pls/ask/f?p...4540782494895,
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