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

Imp-00003 Oracle Error 942 Encountered

Here are the steps I did: 1. This dmp files contain some LOB columns and hence could not be given as INSERT statements. [cookiemonster] So why not use the 10g import? e. It can only be used by imp. Check This Out

Regards Michel Report message to a moderator Re: import failed [message #484750 is a reply to message #484743] Thu, 02 December 2010 09:35 sharminjose Messages: 8Registered: December 2010 Create a new user 2. Below are the actions taken: ========================================================================= C:\app\Administrator\admin\ORCLENT1\dpdump>imp Import: Release 11.2.0.1.0 - Production on Wed Aug 29 22:32:39 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. Once the import is done, you might try to recompile all invalid objects (triggers, procedures, packages, ...) and see what happens. check over here

You can not post a blank message. Re: Importing indexes causing - ORA-00942 668860 Jan 8, 2010 6:00 AM (in response to Lubiez Jean-Valentin) hello, thanks everyone....the index owner is same as table owner, as mentioned wiill try In my case, I can have 10g clients as well as 11g clients, but server will be always 10g.

  1. The time now is 04:51 PM.
  2. Show 7 replies 1.
  3. Import the data dump: Imp tennisdb/xxxxxxxxxxxxxx file=tennisdb.dmp log=imp3.log fromuser=DW_OWNER touser=tennisdb Am I following the right path?
  4. And what's that going to accomplish apart from making things more compilcated?
  5. 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.
  6. Import terminated successfully with warnings. ============================== Like Show 0 Likes(0) Actions 5.
  7. Article by: sdstuber Why doesn't the Oracle optimizer use my index?
  8. Watson Product Search Search None of the above, continue with my search Resolving Oracle import errors in Portfolio Manager Portfolio Manager; Installation and Configuration: Server; Windows; Unix; Linux; ORA-00942; IMP-00017; rpm
  9. Re: IMP-00017: following statement failed with ORACLE error 942 1005786 Apr 26, 2013 4:31 PM (in response to 472969) Kamal Shrivastava wrote: In my DB Import I am getting the following
  10. It is very helpful, especially for newbie like me. :) When I run the script, there seems to be a lot of error during this process.

Add one line as described in step 1 for each error received during the install process. Senior MemberAccount Moderator Quote:I was looking for a better option and wished to see if you could help me. SQL and PL/SQL FAQ Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Validate that the script executed without errors by reviewing the log file: (impErrorFix.log) Appendix A Import Error Fix spool impErrorFix.log CREATE UNIQUE INDEX HASSD_EID_MJIRV_CU ON HISTORY_ASSET_DOCUMENTS (ELEMENT_ID , MAJOR_REVISION DESC

PRTG is easy to set up & use. This could be run from any clients. Report message to a moderator Re: import failed [message #484796 is a reply to message #484767] Thu, 02 December 2010 15:32 sharminjose Messages: 8Registered: December 2010 Location: US http://www.ibm.com/support/docview.wss?uid=swg21330529 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.

Want to Advertise Here? importing table "PS_PSI_PRSNNL_ALL" 132293 rows imported IMP-00017: following statement failed with ORACLE error 942: "CREATE UNIQUE INDEX "PS_PSI_REP_TST_HIS" ON "PS_PSI_REP_TST_HIS" ("EMPLID" " ", "EMPL_RCD" , "EFFDT" , "EFFSEQ" ) PCTFREE 10 Solved import error: imp-00003 an oracle error 942 encountered. To start viewing messages, select the forum that you want to visit from the selection below.

Join Now For immediate help use Live now! importing table "TMP_MATCH_COURT_TYPE" 335562 rows imported . . Like Show 0 Likes(0) Actions 4. It returns with "AL32UTF8" Is there anything else I should check?

This tool uses JavaScript and much of it will not work correctly without it enabled. his comment is here Remove all quotes from the statement Example: CREATE INDEX HSRSC_RID_RDT_XX ON HISTORY_RESOURCES (RESOURCE_ID, REC_DATETIME DESC ) PCTFREE 30 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 6553 6 FREELISTS 1 FREELIST GROUPS 1 Advanced Search Forum Oracle Forums Oracle Database Administration Error in importing Index orgainzed table If this is your first visit, be sure to check out the FAQ by clicking the link You are not really giving good details.

importing table "W_MATCH_F" 1012812 rows imported . . I doubt he will care about your untimely response now. Re: How to fix this error: IMP-00003: ORACLE error 1435 encountered Srini Chavali-Oracle Sep 5, 2012 11:46 PM (in response to 958907) > import done in AL32UTF8 character set and AL16UTF16 http://wiiplay.net/imp-00003-oracle/imp-00003-oracle-error-604-encountered.html In your imp statement set show=y then try again.

Black Swann, In this post Mahesh talked about the usage of some views, hence I replied back to the same post. importing table "PS_PSI_REORG_LOAD" 0 rows imported . . Many thanks.

Re: IMP-00017: following statement failed with ORACLE error 942 654339 Aug 8, 2008 6:32 PM (in response to 472969) Hi I faced the same error in a similar scenario.

you might get lucky there. Please type your message and try again. importing WFDEV's objects into WFDEV . . why? 0 LVL 23 Overall: Level 23 Oracle Database 23 Message Accepted Solution by:seazodiac2004-02-24 ok, in that case, you have NOT run the catalog.sql and catproc.sql already.(they are in the

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. Privacy Policy Site Map Support Terms of Use Register Help Remember Me? Re: IMP-00017: following statement failed with ORACLE error 942 sb92075 Apr 26, 2013 4:36 PM (in response to 1005786) Adeleke, Please wake up before responding again. navigate here Does Oracle has a GUI tool somewhere I can try or how I can fix this issue?

importing table "TMP_PLAYER_ATP" 47070 rows imported . . importing table "W_PLAYER_D_M" 45804 rows imported . . Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows Re: IMP-00017: following statement failed with ORACLE error 942 472969 Feb 23, 2006 10:03 AM (in response to 464759) It doesn't have any foreign key constraints.

skipping TOID validation on type MDSYS.SDO_ELEM_INFO_ARRAY . . And export file created by exp command cannot be used by impdp. 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 Tables are created without any problem but the index creations are failing with: IMP-00017: following statement failed with ORACLE error 942: Like Show 0 Likes(0) Actions 5.

Report message to a moderator Re: import failed [message #484752 is a reply to message #484750] Thu, 02 December 2010 09:50 Michel Cadot Messages: 63892Registered: March 2007 Location: Thanks, Sharmin Report message to a moderator Re: import failed [message #484751 is a reply to message #484750] Thu, 02 December 2010 09:40 BlackSwan Messages: 24947Registered: January 2009 You import all except the Indexes and Constraints: rows = y indexes = n constraints = n- 2. Re: Importing indexes causing - ORA-00942 Srini Chavali-Oracle Jan 5, 2010 3:07 PM (in response to 668860) Did this start happening recently ?

Create a SQL Script file to create the Import DB Fix 1.