Exp-00008 Oracle Error 904
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 Junior Member First I got errors when exp-00008 oracle error 904 encountered ora-00904 poltyp invalid identifier I did the export with an export tool of Release 11.1.0.7.0 and exp-00008 oracle error 904 encountered ora-00904 invalid identifier there were lot of ORA-00904 and ORA-01003 like the following: XP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier
Exp-00008 Oracle Error 904 Encountered 11g
. . exporting table XRATE_INFO EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed Then I tried to do export with another version of export tool (Release 10.2.0.4.0) The errors
Oracle Error 904 Ora-00904 Invalid Identifier
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 message to a moderator Re: "ORA-00904 POLTYP: invalid identifier" when export [message #540990 is a reply to exp 00008 oracle error 1003 encountered 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 - Production 3 CORE 10.2.0.4.0 Production 4 TNS for 64-bit Windows: Version 10.2.0.4.0 - Production 5 NLSRTL Version 10.2.0.4.0 - Production the command I used is: cmd>exp parfile=
Output: Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production Export done in WE8MShere 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 Learn more about hiring
Ora-00904: Invalid Identifier
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question exp-00008 oracle error 1555 encountered x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; oracle bug 7568350 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 Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit) When http://www.orafaq.com/forum/t/178387/ 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 but it gives: UDE-00018: Data Pump client is incompatible with database version 10.2.0.4.0 oracle http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client 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 oracle11gr2 datapump or ask your own question. asked 4 years ago viewed 24096 times active 2 years ago Related 1Oracle 11g Top N Query returns different values to the same
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-backup-l/exp00008-oracle-error-904-encountered-ora00904-tabobjno-invalid-identifier-1526208 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 JoeTorre Locutus Dennis Stevenson bracke Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Dell Software oracle error 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 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 00008 oracle error 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? Join this group 4Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... ptaiwo replied Jul 16, 2007 See if this helps. Subject: Handling ORA-00904 errors on Export Doc ID: Note:232708.1Type: PROBLEM Last Revision Date: 06-OCT-2003Status: PUBLISHED fact: Oracle Server - Enterprise Edition symptom: ORA-00904: Invalid column name symptom: EXP-00008: ORACLE error %s encountered cause: The package is missing, invalid or