Exp-00008 Oracle Error 904 Encountered Export
Contents |
Message Navigator E-mail to friend "ORA-00904 POLTYP: invalid identifier" when export [message #540989] Thu, 26 January 2012 21:03 basarakin Messages: 3Registered: January 2012
Ora-00904: Invalid Identifier
Junior Member First I got errors when I did the export ora-00904: invalid identifier with an export tool of Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like
Exp 00008 Oracle Error 1003 Encountered
the following: XP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier . . exporting table XRATE_INFO EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed Then I ora 00904 invalid identifier during export tried to do export with another version of export tool (Release 10.2.0.4.0) The errors changed to the follwing: .about to export FM's tables via Direct Path... EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully The export tool I used is of Release 10.2.0.4.0 Has anyone had similar problems before? Report exp-00008 oracle error 1555 encountered message to a moderator Re: "ORA-00904 POLTYP: invalid identifier" when export [message #540990 is a reply to message #540989] Thu, 26 January 2012 21:18 BlackSwan Messages: 24942Registered: January 2009 Location: SoCal Senior Member It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/ post results from following SQL SELECT * FROM V$VERSION; Report message to a moderator Re: "ORA-00904 POLTYP: invalid identifier" when export [message #540996 is a reply to message #540989] Fri, 27 January 2012 00:48 Michel Cadot Messages: 63882Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Copy and paste the complete sequence of statements and output. Regards Michel Report message to a moderator Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541018 is a reply to message #540996] Fri, 27 January 2012 01:59 basarakin Messages: 3Registered: January 2012 Junior Member Oracle Version: 1 Oracle Database 10g Release 10.2.0.4.0 - 64bit Production 2 PL/SQL Release 10.2.0.4.0 - Producti
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 more about Stack Overflow the company Business
Oracle Bug 7568350
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs exp-00008 oracle error 3113 encountered Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just
Error Code 904 Oracle
like you, helping each other. Join them; it only takes a minute: Sign up Export from Oracle 10g database with 11g client up vote 10 down vote favorite Database Version : 10g Enterprise Edition Release 10.2.0.4.0 Client http://www.orafaq.com/forum/t/178387/ Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit) When I try to export (exp) a table from database: exp usr/pass@remote_db file=f.dmp tables=table I get the following error: EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully I searched about it on the net and I understand that the problem is version incompatibility. What do you advice me to do about it? NOTE: I also tried to export with data pump http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client but it gives: UDE-00018: Data Pump client is incompatible with database version 10.2.0.4.0 oracle oracle10g oracle11gr2 datapump share|improve this question asked Dec 21 '11 at 16:13 bonsvr 1,25641427 I think it would be appropriate to ask to dba.stackexchange.com –Luc M Dec 21 '11 at 16:23 add a comment| 2 Answers 2 active oldest votes up vote 11 down vote accepted Generally speaking, Oracle export is not backward compatible with prior releases. You'll need to use the 10g export on the 10g database. Get the 10g client and install it with the database utilities option to get the exp/imp tools. On the flip side, Oracle imp is generally backward compatible with prior releases of exp. share|improve this answer answered Dec 21 '11 at 16:44 DCookie 28.8k84765 add a comment| up vote 0 down vote I use VERSION=10.2 from a 11g client share|improve this answer answered May 22 '14 at 17:52 Ankit 845816 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged oracle oracle10g oracle1
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-backup-l/exp00008-oracle-error-904-encountered-ora00904-tabobjno-invalid-identifier-1526208 Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate oracle error JoeTorre Locutus Dennis Stevenson bracke Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Dell Software Panaya Inc. Oracle VAI View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database Backup For discussion on Oracle 00008 oracle error Database Backup , please visit the Oracle Database group. More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. EXP-00008: ORACLE error 904 encountered ORA-00904: "TABOBJNO": invalid identifier Heather Lowry asked Jul 13, 2007 | Replies (4) Trying to do a full export, encountered the following errors: EXP-00008: ORACLE error 904 encountered ORA-00904: "TABOBJNO": invalid identifier The errors occurred on the table WM$VERSIONED_TABLES that is owned by wmsys. Any ideas? Joi