Oracle Error 904 Maxsize Invalid Identifier
Contents |
10g ORA-904 I was trying to export from a database over the network. Oracle exp-00008 oracle error 904 encountered ora-00904 invalid identifier 11g Release 11.2.0.1.0 resides in my unit. My export activity was ora 00904 invalid identifier during export terminated due to this error: EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier EXP-00000:
Oracle Error 904 Ora-00904 Invalid Identifier
Export terminated unsuccessfully I researched about these error and found out that it was really a known bug of 11g and there are patches
Exp 00008 Oracle Error 1003 Encountered
that can resolve this 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: oracle bug 7568350 10.1 to 10.2 Information in 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
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please
Exp-00008 Oracle Error 1555 Encountered
type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral exp-00008: oracle error 3113 encountered Database Discussions This discussion is archived 7 Replies Latest reply on Jun 25, 2011 7:20 AM by user13461835 error while using ora-00904: "poltyp" exp utility 684379 Apr 2, 2009 7:23 AM Hi, I am getting the following oracle error while using exp, can someone please suggest on this, About to export specified users ... . exporting pre-schema procedural objects https://knowledgeispower11.wordpress.com/2012/04/20/ora-00904-maxsize-invalid-identifier/ and actions . exporting foreign function library names for user SIEBEL . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user SIEBEL About to export SIEBEL's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export SIEBEL's tables via Conventional Path ... . . exporting table EIM_ACCDTL_TNT EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier https://community.oracle.com/thread/882259 . . exporting table EIM_ACCNTROUTE EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table EIM_ACCNT_CUT EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier . . exporting table EIM_ACCNT_DTL EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed I have the same question Show 0 Likes(0) 8719Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: error while using exp utility Satish Kandi Apr 2, 2009 7:24 AM (in response to 684379) Few more details about the client and server Oracle versions and OS would be helpful. Like Show 0 Likes(0) Actions 2. Re: error while using exp utility zaffer khan, cisa Apr 2, 2009 7:52 AM (in response to 684379) ORA-02494: invalid or missing maximum file size in MAXSIZE clause Cause: UNLIMITED was not specified, or an invalid integer value was specified, for the MAXSIZE clause in the DATAFILE file list. The MAXSIZE value cannot be smaller than the SIZE value. Action: Use correct syntax. Like Show 0 Likes(0) Actions 3. Re: error while using exp utility 684379 Apr 2, 2009 8:01 AM (in response to Satish Kandi) am using Oracle 11g client and server, OS : windows XP SP 3 Like Show 0 Likes(0) Actions 4. Re: error w
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 http://www.orafaq.com/forum/t/178387/ of Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like the following: http://halimdba.blogspot.com/2010/07/exp-00008-oracle-error-904-encountered.html 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 oracle error 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 January 2012 21:18 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member It would be helpful if you followed Posting Guidelines oracle error 904 - 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: 63911Registered: 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 ... . exportingposition(http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html). I am maintaining this blog for helping myself while in work and sharing my knowledge with others. If you have any question. you can reach me at infohalimdba@gmail.com Thanks. Home Oracle 12c DBA Training SQL & PL/SQL Training Dataguard 12c Training RAC 12c Training Consulting & Support Linux Contact Us Reviews Thursday, July 8, 2010 EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier ORA-01003: no statement parsed EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier ORA-01003: no statement parsed--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------=============================================================When I execute a export (EXP) in this version I found this result............................-------------------------------------------------------------------------------------------------------------------------------------------------------==============================================================SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 13:00:12 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.SQL> hostMicrosoft Windows XP [Version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:\Documents and Settings\era-1>exp userid=basel2/basel2@test107 owner=basel2file=D:\basel_dump\basel2_08072010_test107.dmp LOG=D:\basel_dump\basel2_08072010_test107.LOGExport: Release 11.1.0.6.0 - Production on Thu Jul 8 13:00:19 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setAbout to export specified users .... exporting pre-schema procedural objects and actions. exporting foreign function library names for user BASEL2. exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user BASEL2About to export BASEL2's