Oracle Export Error 1003
Contents |
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
Exp-00008 Oracle Error 904 Encountered Ora-00904 Invalid Identifier
reload this page. Please enter a title. You can not post a oracle error 904 ora-00904 invalid identifier blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral
Exp 00008 Oracle Error 1003 Encountered
Database Discussions This discussion is archived 7 Replies Latest reply on Jun 25, 2011 7:20 AM by user13461835 error while using exp utility 684379 Apr 2, 2009 7:23 ora 00904 invalid identifier during export 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 and actions . exporting foreign function library names for user SIEBEL . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for ora-00904: "maxsize": invalid identifier 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 . . 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) 8723Views 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 o
10g ORA-904 I was trying to export from a database over the network. Oracle 11g
Exp-00008: Oracle Error 3113 Encountered
Release 11.2.0.1.0 resides in my unit. My export activity was terminated exp-00008 oracle error 1555 encountered due to this error: EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier EXP-00000: Export
Ora-00904 Dbms_java . Longname Invalid Identifier
terminated unsuccessfully I researched about these error and found out that it was really a known bug of 11g and there are patches that can https://community.oracle.com/thread/882259 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: 10.1 to https://knowledgeispower11.wordpress.com/2012/04/20/ora-00904-maxsize-invalid-identifier/ 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
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: http://www.databasesql.info/article/570855325/ 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 - 00008 oracle error 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 ... . exporting database linvalid identifier Cause: Oracle version is not the same Execution C :/> the EXP FILE = c :/ TABLES of plx.dmp = (s, sc, c) The results error Export: Release 11.1.0.6.0 - Production on Sunday, July 26, 2009 12:42:19 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Exported ZHS16GBK character set and UTF8 NCHAR character set server uses UTF8 character set (character set conversion possible) About to export specified tables via Conventional Path ... .. Table is derived S EXP-00008: ORACLE error encountered 904 ORA-00904: "MAXSIZE": invalid identifier .. Table is derived SC EXP-00008: ORACLE error encountered 1003 ORA-01003: no statement parsed .. Export Table C EXP-00008: ORACLE error encountered 904 ORA-00904: "MAXSIZE": invalid identifier EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024 Export View: not installed, please notify your DBA EXP-00000: Export terminated unsuccessfully Very strange, never seen an error will be reported how the field error. So Google BAIDU is garbage (technical information) Have a buddy that lost data dictionary, I am very surprised, I few days ago in the Oracle 10g Client under export, how you can lose data dictionary, or dubious performed. Executed on the server :> sqlplus as sysdba SQL> @ / opt/oracle/product/10.2/db_1/rdbms/admin/catexp.sql To rebuild the data dictionary. Built, perform the export again, or not. But I the same statement can be executed on the server. Then I realized that it might EXP version, so the test. On a 11g machine running an SQL detected that MAXSIZE column. SQL> select distinct table_name from user_col_comments where column_name = 'MAXSIZE'; TABLE_NAME -------------------- EXU9STOU EXU9PLB EXU9PDSU EXU9LBCPU EXU9PDS EXU9IXCP CPOOL $ EXU9TBCPU EXU9TBCP EXU9STO EXU9IXCPU TABLE_NAME -------------------- DBA_CPOOL_INFO EXU9TBS EXU9PLBU EXU9LBCP 10g server running the same statement, no rows are returned. Visible MAXSIZE is newly added item in the data dictionary 11g, 10g is not. # 1