Ora-00904 Export Error
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 I ora-00904: "poltyp": invalid identifier did the export with an export tool of Release 11.1.0.7.0 and there were oracle error 904 ora-00904 invalid identifier lot of ORA-00904 and ORA-01003 like the following: XP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier . ora-00904: "maxsize": invalid identifier . 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 changed to
Oracle Error 904 Encountered
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 message #540989] Thu, 26 ora 00904 invalid identifier during export January 2012 21:18 BlackSwan Messages: 24958Registered: 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: 63912Registered: 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 WE8MSWIN1252 character set and AL16UTF16 NCHAR characterhere 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 exp 00008 oracle error 1003 encountered Us Learn more about Stack Overflow the company Business Learn more about hiring
Exp-00008 Oracle Error 1555 Encountered
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the
Oracle Bug 7568350
Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Export from Oracle 10g database with http://www.orafaq.com/forum/t/178387/ 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 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 http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client 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 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.9k84765 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
10g ORA-904 I was trying to export from a database over the network. Oracle 11g Release 11.2.0.1.0 https://knowledgeispower11.wordpress.com/2012/04/20/ora-00904-maxsize-invalid-identifier/ resides in my unit. My export activity was terminated due to this error: EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier EXP-00000: Export terminated unsuccessfully http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-backup-l/exp00008-oracle-error-904-encountered-ora00904-tabobjno-invalid-identifier-1526208 I researched about these error and found out that it was really a known bug of 11g and there are patches that can resolve this invalid identifier error. This was what I got from Oracle Metalink: ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.(exp) [ID 957380.1] Modified 22-SEP-2011 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2 Information in oracle error 904 this document applies to any platform. ***Checked for relevance on 22-SEP-2011*** Symptoms ORA-904 occurs when using a release 11g export client to export from release 10g database. Export succeeds when using any 10g export client (10.2.0.1 … 10.2.0.4). Example:exp scott/****** file=d:\exp.dmp
Using export client (11.1.0.7) to export from 10.2.0.4 database
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 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 VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct 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 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 identi