Error 904 Export Oracle
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 oracle error 904 ora-00904 invalid identifier Member First I got errors when I did the export with oracle error 904 encountered an export tool of Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like the exp-00008 oracle error 904 encountered 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 exp-00008 oracle error 904 encountered ora-00904 poltyp invalid identifier 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: "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
Oracle Error Code 904
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: 24930Registered: 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: 63856Registered: 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
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
Ora-00904 Poltyp Invalid Identifier Oracle 11g
back on and reload this page. Please enter a title. exp-00008: oracle error 1003 encountered You can not post a blank message. Please type your message and try again. More discussions ora-00904: "maxsize": invalid identifier in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 7 Replies Latest reply on Jun 25, 2011 7:20 AM by user13461835 error while http://www.orafaq.com/forum/t/178387/ using 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 and actions . exporting foreign function library names for user SIEBEL . exporting PUBLIC type synonyms https://community.oracle.com/thread/882259 . 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 . . 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) 8647Views 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 L
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-backup-l/exp00008-oracle-error-904-encountered-ora00904-tabobjno-invalid-identifier-1526208 PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX https://knowledgeispower11.wordpress.com/2012/04/20/ora-00904-maxsize-invalid-identifier/ 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 maxwellarnold PCMag I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Dennis oracle error Stevenson Craig Borysowich Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat bluesguyAZ59 iudithm COMPANIES RSA Conference UC4 Apperian Sophos 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. oracle error 904 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 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 c
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. 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 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 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 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