Failed With Oracle Error 2304
Contents |
January 10, 2008 - 5:31 pm UTC Category: Database – Version: oracle 8.1.7 Latest Followup You Asked i have installed oracle 8.1.7. and i have exported a table having object data type and i am tring to ora-02304 invalid object identifier literal impdp import it in different schema but it is giving me error -> "IMP - ora-39083: object type type failed to create with error: 00017:following statement failed with oracle error 2304: "CREATE TYPE TEMP_TYPE TIMESTEMP '2001-01-24:12:54:38' OID 'C07F6E6CF1E' "511D488B80050BA897E09" AS OBJECT (TP1 VARCHAR2(30),TP2 VARCHAR2(30))" transform=oid:n IMP 00003:ORACLE ERROR 2304 ENCOUNTERED ORA-02304:INVALID OBJECT IDENTIFIER LITERAL IMP 00063:WARNING: SKIPPING TABLE "TEMPUSER"."FIRST_TABLE" BECAUSE OBJECT TYPE "TEMPUSER"."TEMP_TYPE" CAN NOT BE CREATED OR HAS DIFFERENT IDENTIFIER and we said... That will not work --
Imp 00017 Following Statement Failed With Oracle Error 2304
the OID already exists in that database. In order to import that data, we need to use the SAME exact type -- not a "similar" type, the same type. You should not install the same type more then once in a database for this and OTHER reasons. It would be a good practice to create a schema, say called TYPES, and install all types into that schema. ora-02304 invalid object identifier literal create type This ensures a type is installed ONCE per database instance -- never once per schema. In this fashion, all schemas will use the same consistent type. They will be able to do things like: insert into myobjectTable select * from someone_elses.objectTable; if we used "similar" types -- each in our own schema -- that would not be possible. Think about what would happen if everyone had their own "NUMBER" type -- it would be a mess. The same thing is true for user defined types. If you had a user TYPES with the type in it and you had a user "A" with a table "T" of that type and a user "B" with a table (or not -- the table doesn't have to exist) you will be able to: 1) exp owner=a 2) imp fromuser=a touser=b ignore=y that'll create (or not) the table based on the common type and fill it up. the same would be true of CROSS DATABASE issues. You would install the types into 1 database and then export them and import them into the other databases. In this fashion, they all get created with the same OID and you can import/export back and forth between th
April 2006 16:30 faiz_hyd Messages: 294Registered: February 2006 Senior Member Hi I did impdp transform an export from Schema A and import to Schema
Imp-00003
B. Using Toad, Export was succesful and while importing i got this error Warning: the objects were exported by R1APP50, not by you import done in WE8MSWIN1252 character set and UTF8 NCHAR character set import server https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1323002416801 uses AL32UTF8 character set (possible charset conversion) IMP-00017: following statement failed with ORACLE error 2304: "CREATE TYPE "CD_ISO_BAT_R" TIMESTAMP '2006-03-29:10:11:27' OID '10256EFEAB4" "3359FE0440003BA7CEECD' AS OBJECT (" " bat_id NUMBER," " cd_vol_nb NUMBER," " cd_iso_id NUMBER," " bat_data_size NUMBER," " bat_image_size NUMBER," " cr_dt DATE" ");" IMP-00003: http://www.orafaq.com/forum/t/61346/ ORACLE error 2304 encountered ORA-02304: invalid object identifier literal IMP-00017: following statement failed with ORACLE error 2304: "CREATE TYPE "CD_ISO_BAT_T" TIMESTAMP '2006-03-29:10:11:28' OID '10256EFEAB4" "C359FE0440003BA7CEECD' AS TABLE OF cd_iso_bat_r;" IMP-00003: ORACLE error 2304 encountered ORA-02304: invalid object identifier literal IMP-00017: following statement failed with ORACLE error 2304: "CREATE TYPE "CD_ISO_R" TIMESTAMP '2006-03-29:10:11:28' OID '10256EFEAB50359" "FE0440003BA7CEECD' AS OBJECT (" " cd_iso_id NUMBER," " cd_iso_burn_id NUMBER," " cd_vol_nb NUMBER," " cd_vol_trans_count NUMBER" ")" IMP-00003: ORACLE error 2304 encountered ORA-02304: invalid object identifier literal IMP-00017: following statement failed with ORACLE error 2304: "CREATE TYPE "CD_ISO_T" TIMESTAMP '2006-03-29:10:11:28' OID '10256EFEAB57359" "FE0440003BA7CEECD' AS TABLE OF cd_iso_r;" IMP-00003: ORACLE error 2304 encountered ORA-02304: invalid object identifier literal IMP-00017: following statement failed with ORACLE error 2304: "CREATE TYPE "ID_TYP" TIMESTAMP '2006-03-29:10:11:28' OID '10256EFEAB5B359FE" "0440003BA7CEECD' AS TABLE OF NUMBER(20);" IMP-00003: ORACLE error 230
errors - urgent please If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register http://www.dbasupport.com/forums/showthread.php?37183-export-errors-urgent-please before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: export errors - urgent please Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to failed with Threaded Mode 06-27-2003,09:40 AM #1 sureshot View Profile View Forum Posts Larry's bro-knows nothing 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)" failed with oracle " INDEX BY BINARY_INTEGER;" Did anyone see this before? Last edited by sureshot; 06-27-2003 at 11:32 AM. Reply With Quote 06-27-2003,09:46 AM #2 Giani View Profile View Forum Posts Oracle DBA Join Date Nov 2002 Location Dublin, Ireland Posts 133 where is the errors? Giani Reply With Quote 06-27-2003,10:59 AM #3 Mr.Hanky View Profile View Forum Posts X-Mas poo 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. Reply With Quote 06-27-2003,11:35 AM #4 sureshot View Profile View Forum Posts Larry's bro-knows nothing 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(com