Oracle Error Imp-00017
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. imp-00017: following statement failed with oracle error 2430 Please enter a title. You can not post a blank message. Please imp-00003 type your message and try again. More discussions in Export/Import/SQL Loader & External Tables All PlacesDatabaseOracle Database + imp-00017: following statement failed with oracle error 959 OptionsExport/Import/SQL Loader & External Tables This discussion is archived 9 Replies Latest reply on Apr 26, 2013 4:36 PM by sb92075 IMP-00017: following statement failed with ORACLE error 942
Imp 00017 Following Statement Failed With Oracle Error 1
472969 Feb 23, 2006 7:47 AM In my DB Import I am getting the following error, can anybody help me out what may be the reason behind it and appropriate solution. The Error is: IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "PRMSELINCPUBT" ADD CONSTRAINT "PRMPRMCHPT_PRMSELINCPUBT_FK" FO" "REIGN KEY ("PRM_IDT","CHP_NUM") REFERENCES "PRMPRMCHPT" ("PRM_IDT","CHP_NUM" "")" Thanks in advance Kamal imp 00017 following statement failed with oracle error 2304 Shrivastava 27151Views Tags: none (add) This content has been marked as final. Show 9 replies 1. Re: IMP-00017: following statement failed with ORACLE error 942 464759 Feb 23, 2006 8:36 AM (in response to 472969) This error: $ oerr ora 942 00942, 00000, "table or view does not exist" // *Cause: // *Action: generally means: that the table does not exist or that you don't have the right privileges to run the statement. Are you sure this table exist ? Do you have any other error before ? How has been the export command run (which user, which schema) ? How how the import command run (which user, which schema) ? Like Show 0 Likes(0) Actions 2. Re: IMP-00017: following statement failed with ORACLE error 942 464759 Feb 23, 2006 9:34 AM (in response to 472969) One reason could be that the imported table is a child of another table that is not imported: there is a foreign key constraint and the parent table is not imported). Is it the case ? Like Show 0 Likes(0)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://stackoverflow.com/questions/10892847/oracle-import-error more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up oracle import error up vote 3 down vote favorite While importing oracle error a dump file into oracle 11gr2 i am getting this error please suggest a way to resolve this *Warning: the objects were exported by D7IDMP, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) . importing D7IDMP's objects into MIGRATE . . importing table "TXALLTXTS" 245628 rows imported . . importing table "TXAUTH" 377 following statement failed rows imported . . importing table "TXBAIMERT" 244 rows imported . . importing table "TXBARESC" 178 rows imported . . importing table "TXBOILER" 458940 rows imported . . importing table "TXCLASSES" 980 rows imported . . importing table "TXCLOSEDPERIODS" 1 rows imported . . importing table "TXCOMPANIES" 1 rows imported . . importing table "TXCONCLAUSES" 187 rows imported IMP-00017: following statement failed with ORACLE error 959: "CREATE TABLE "TXCONFIGSETTINGS" ("CFS_CODE" VARCHAR2(20), "CFS_RCODE" VARCHAR2(2" "0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FR" "EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MP5TEXT" LOGGI" "NG NOCOMPRESS LOB ("CFS_XMLCONFIG") STORE AS (TABLESPACE "MP5TEXT" ENABLE " "STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREE" "LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'MP5TEXT' does not exist* As per alex comments i tried with other attributes of imp but it resulted someother error The command which i run is imp fromuser=d7idmp touser=&&from_user file=test.dmp log= test.log ignore=y transport_tablespace = y tablespaces = MP5TEXT the error is import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) IMP-00053: Import mode incompatible with Export dump file IMP-00000: Import terminated unsuccessfu