Oracle Error 942 Encountered Imp
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > import error: imp-00003 an oracle error 942 encountered. Want to Advertise Here? Solved import error: imp-00003 an oracle error 942 encountered. Posted on 2004-02-24 http://dbaforums.org/oracle/index.php?showtopic=21902 Oracle Database 2 Verified Solutions 6 Comments 4,204 Views Last Modified: 2012-11-16 Hi experts, I am trying to import tables into a newly created instance. 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, please notify your DBA What https://www.experts-exchange.com/questions/20896651/import-error-imp-00003-an-oracle-error-942-encountered.html should I do to fix this problem? 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 as catexp.sql) again, log in as sysdba SQL>@catalog.sql SQL>@catproc.sql Go to Solution 6 Comments LVL 23 Overall: Level 23 Oracle Database 23 Message Assisted Solution by:seazodiac2004-02-24 log in as sysdba, run catexp.sql under %ORACLE_HOME%/rdbms/admin folder 0 LVL 23 Overall: Level 23 Oracle Database 23 Message Expert Comment by:seazodiac2004-02-24 after that, try your imp command again. the reason is that you have not created IMP/EXP dictionary views 0 Message Author Comment by:panpanW2004-02-24 thansk. But, I am getting "package STANDARD not accessible" error. 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 same folder as catexp.sql) again, log in as sysdba SQL>@catalog.sql SQL>@catproc.sql 0 LVL 13 Overall: Level 13 Oracle Database 12 Message Expert Comment by:riazpk2004-02-25 log in
all tables that contained a BLOB column. The source dump file was exported from a 10g database. Here is a sample . . importing table "TBL_OBSERVATION" IMP-00058: ORACLE error 942 http://mrrame.blogspot.com/2013/01/imp-00058-oracle-error-942-encountered.html encountered ORA-00942: table or view does not exist 2365 rows imported Even though the http://www.dbforums.com/showthread.php?1647811-Export-Import-issue imp complained about table not found, It did import all the records ( in my case 2365 rows imported) After some debugging, I found that the error was happening as I was using 11g (11.2.0.1) client to import into a 10g (10.2.0.4) database. When I used 10g (10.2.0.4) client to import, it worked fine. There oracle error is no proper explanation available for this error, but seems to happen when you use 11g client to import a 10g dump into a 10g database Workaround, Use 10g client to import into a 10g database. Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Oracle 1 comment: Valeriy PakMarch 28, 2014 at 4:19 AMUseful! Thank you! Met the same situation!:))ReplyDeleteAdd commentLoad more... Newer Post Older Post Home Subscribe oracle error 942 to: Post Comments (Atom) About Me Ramesh Manni View my complete profile Search This Blog Loading... Labels Oracle (115) .Net (12) Temples of India (8) Videos (8) ASP.Net (6) Flex (6) Funny (6) Windows (6) tamil (5) Tour India (3) C# (2) HTTP Error 401.3 - Unauthorized - ACL (2) WCF (2) WD LIVE NAS (2) Windows 8 (2) 0x8007232B error on Activating Windows 8 (1) Access (1) Audio (1) BlackBerry (1) C# SAML Concepts (1) C# SAML example (1) C# SAML sample code (1) Calling LoadLibraryEx on ISAPI filter failed (1) Comics (1) Compatibility View (1) Dropbox (1) GPG error:public key is not available;Linux (1) Google+ (1) HTTP Error 401.3 - Unauthorized (1) Hinduism (1) How to move tablespace data file (1) IE 11 (1) IGMP Proxy (1) IIS7 (1) Indian Food (1) JavaScript (1) Kick ass websites (1) Logitech Media Server (1) Media Server not visible (1) Merge TIF files (1) Nexus 4: Screen blacks out (1) ODAC (1) Oracle: forgot sys password;Oracle (1) Oracle;ORA-27046;OSD-04012 (1) OracleInternal.MTS.DTCPSPEManager (1) Password Expiry (1) Photos (1) Plex Media Server (1) SAML (1) SQL Developer: TNS Names empty dropdown (1) Spiritual (1) Squeezebox (1) Telnet (1) Tips and Tricks (1) Type provided must be an Enum (1) Ubunt
out the FAQ by clicking the link above. You may have to register 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 6 of 6 Thread: Export/Import issue Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-16-09,05:46 #1 prepek2000 View Profile View Forum Posts Registered User Join Date Sep 2009 Location Serbia Posts 17 Unanswered: Export/Import issue Hi guys! I have problem with importing schema from 9.2.0.4 db to 11.1.0.6 version. Both db are using Linux OS. I have done export of schema from 9i with no problem using EXP, but when i tried to do import to 11g with batch job that do this work it has stuck. I have then change system variables to use 10.2 version of EXP tool and i have done import of tables and indexes of source schema with no problem, but i had problem with triggers: IMP-00017: following statement failed with ORACLE error 942: "CREATE TRIGGER "HR".TRG_DINAMIKA_BI" "BEFORE INSERT ON USER_OBUKA.DINAMIKA FOR EACH ROW" "DECLARE" " OK BOOLEAN;" "BEGIN" " :NEW.STID := 0;" " :NEW.STID := PCK_Kljuc.SET_STID (:NEW.VDID, :NEW.DokID);" " IF :NEW.StID = 0 THEN" " NULL;" " END IF;" "END;" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: any advice? Reply With Quote 09-16-09,07:34 #2 Littlefoot View Profile View Forum Posts Lost Boy Join Date Jan 2004 Location Croatia, Europe Posts 4,090 Provided Answers: 4 Basically, export should be done with lower database version's EXP utility (9i in your case), while import should be done with target database version's IMP utility (11g in your case). As of ORA-00942 error, it appears that the table doesn't exist. Once the import is done, you might try to recompile all invalid objects (triggers, procedures, packages, ...) and see what happens. If there's still the same problem, check import's log file to see why this particular table was not imported. Reply With Quote 09-16-09,08:23 #3 prepek2000 View Profile View Forum Posts Registered User Join Date Sep 2009 Location Serbia Posts 17 I have check all that, you already have mine log error in post... Reply With Quote 09-16-09,11:46 #4 The_Duck View Profile View Forum Posts Registered User Join Date Jul 2003 Posts 2,296 does USE