Home > Imp 00003 Oracle > Imp-00003 Oracle Error 942 Encountered Ora-00942

Imp-00003 Oracle Error 942 Encountered Ora-00942

Justin Cave Distributed Database Consulting, Inc. right after I type : imp login/password i got this error: imp-00003 an Oracle error 942 encountered ORA-0942 a table or view does not exist imp-00023 imp view does not installed, Justin Cave Distributed Database Consulting, Inc. Powered by Blogger. Check This Out

importing table "TMP_RESULT_COMBINATIONS" 16889 rows imported . . skipping TOID validation on type MDSYS.SDO_ORDINATE_ARRAY . . Mentioned above -> "In my case, the Import_To is 10.2 and Export_From is 10.2. You can not post a blank message.

importing table "PS_PSI_PRSNNL" 13793 rows imported IMP-00017: following statement failed with ORACLE error 942: "CREATE UNIQUE INDEX "PS_PSI_REP_TST" ON "PS_PSI_REP_TST" ("EMPLID" , "EMPL_" "RCD" , "EFFDT" , "EFFSEQ" ) PCTFREE 10 You have mentioned below to install the views as a remedy. importing table "PS_PSI_RC_BENH02" 3 rows imported . . You import The Indexes and the Constraints ignore = y rows = n indexes = y constraints = yHope it can help.

If you look at my imp log, it says clearly that the export was done in 10.2 and import is done using 11.2. use the same version to import or install the views ( from the version used to export). Now check log file again and search for the "dinamika" table which was supposed to be imported into the "user_obuka's" schema. thanks. 0 Question by:panpanW Facebook Twitter LinkedIn Google LVL 23 Best Solution byseazodiac ok, in that case, you have NOT run the catalog.sql and catproc.sql already.(they are in the same folder

Remove all soft returns Example: "CREATE INDEX "HSRSC_RID_RDT_XX" ON … "K" LOGGING" Note: do not remove any text, the example was truncated to show the beginning and end of the line. An example of the full error is shown below: IMP-00017: following statement failed with ORACLE error 942: "CREATE INDEX "HSRSC_RID_RDT_XX" ON "HISTORY_RESOURCES" ("RESOURCE_ID" , "RE" "C_DATETIME" DESC ) PCTFREE 30 INITRANS Export and import Rohit Rajput asked Dec 10, 2009 | Replies (22) when i export emp table from user scott it gets exported sucessfully but with errors.. There are 4 relevant versions here: Source DB Target DB Import Export Plus you should get in the habit of stating the full version - 4 decimals.

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > [TabA] whatever needs to be here Top Best Answer 1 Mark this reply as the best answer?(Choose carefully, this can't be any idea whats causing this... ============================================================= . . IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "EMP" ENABLE CONSTRAINT "FK_DEPTNO"" Import terminated successfully with warnings. Regards Michel Report message to a moderator Re: import failed [message #484760 is a reply to message #484756] Thu, 02 December 2010 12:09 sharminjose Messages: 8Registered: December 2010

Justin Cave Distributed Database Consulting, Inc. http://www.ibm.com/support/docview.wss?uid=swg21330529 Connect with top rated Experts 12 Experts available now in Live! All rights reserved. Re: How to fix this error: IMP-00003: ORACLE error 1435 encountered Sunny kichloo Aug 30, 2012 7:54 AM (in response to 958907) Import entire export file (yes/no): no > yes .

You may have to register before you can post: click the register link above to proceed. his comment is here This could be run from any clients. By hook or crook I should meet it. Re: How to fix this error: IMP-00003: ORACLE error 1435 encountered Srini Chavali-Oracle Sep 5, 2012 2:24 AM (in response to 958907) > ...

That's expected behavior if you are importing a child table without its parent table and you are exporting and importing constraints. Username: scott [enter] Password: tiger [enter] Connected to: Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options Enter array fetch buffer size: 4096 You tried to import a foreign key constraint to the DEPT table, but you haven't imported the DEPT table so creating the constraint failed. this contact form importing DW_OWNER's objects into DW_OWNER IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not existThe user DW_OWNER is not present in your target database that is why you are getting the

Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud What I plan to do is, imp the 10g export file to 10g and expdp it to a new dmp file with target VERSION 10g. But the Import_Version_to_Use is 11.2.

Also, I know that the exp file is different from expdp file.

Rohit Rajput replied Dec 10, 2009 my interaction with cmd prompt C:\>exp [enter] Export: Release - Production on Thu Dec 10 22:50:37 2009 Copyright (c) 1982, 2005, Oracle. importing SCOTT's objects into ROHIT . . What's the point of having 11g clients if the DB is always going to be 10g? [me] As I told above, this is something which is not in my hand. For example - what errors ; what version of Oracle; do you ahe a parfiel for either/both expor import?

Black Swann, In this post Mahesh talked about the usage of some views, hence I replied back to the same post. C:\> ------------ when i logged into rohit schema and ran the query select * from tab; i couldn't see the emp table Top Best Answer 0 Mark this reply as the That means that you asked the import utility not to actually try to import the data. navigate here importing table "MVW_PLAYER_AGG" 34937 rows imported . .

I don't get this error for ordinary tables imported the same way, but for IOT. importing SYSTEM's objects into DATATEST . But most of our client machines are equipped with 11g and the servers are in 10g. The challenge here is, I have an installer which has a code snippet that imports a table.