Ora-00904 Maxsize Invalid Identifier Error
Contents |
10g ORA-904 I was trying to export from a database over the network. Oracle 11g Release 11.2.0.1.0 resides in my unit. exp-00008 oracle error 904 encountered ora-00904 invalid identifier My export activity was terminated due to this error: EXP-00008: ORACLE ora 00904 invalid identifier during export error 904 encountered ORA-00904: "MAXSIZE": invalid identifier EXP-00000: Export terminated unsuccessfully I researched about these error oracle error 904 ora-00904 invalid identifier and found out that it was really a known bug of 11g and there are patches that can resolve this error. This was what I got from Oracle
Exp 00008 Oracle Error 1003 Encountered
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 this document applies to any platform. ***Checked for relevance on 22-SEP-2011*** Symptoms oracle bug 7568350 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss exp-00008 oracle error 1555 encountered the workings and policies of this site About Us Learn more
Ora-00904: "poltyp"
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Exp-00008: Oracle Error 3113 Encountered
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping https://knowledgeispower11.wordpress.com/2012/04/20/ora-00904-maxsize-invalid-identifier/ 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 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 http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client 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 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 answer
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 did the export with an export tool of http://www.orafaq.com/forum/t/178387/ Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like 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 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: oracle error "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 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 00904 invalid identifier 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 character set . exporting pre-schema procedural objects and actions . exporting foreign function library names for user FM . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user FM About to export FM's objects ... . exporting database links . exporting sequence n