Oracle Error 904 Encountered Poltyp Invalid Identifier
Contents |
here 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 Us Learn more about Stack Overflow the company Business Learn ora-00904: invalid identifier more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users oracle bug 7568350 Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping ora 00904 invalid identifier during export 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 exp 00008 oracle error 1003 encountered 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 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
Exp-00008 Oracle Error 1555 Encountered
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 Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged oracle oracle10g oracle11gr2 datapump or ask your own question. asked 4 years ago vie
that we could use it locally using the exp tool. I had to connect to exp like this: exp user/password@remote_address And then filled in the other parameters interactively. Unfortunately when I tried to actually export the specified tables I got the following error
Exp-00008: Oracle Error 3113 Encountered
message: EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully I eventually exp version parameter came across Oyvind Isene's blog post which pointed out that you'd get this problem if you tried to export a 10g database using exp-00008: oracle error 1455 encountered an 11g client which is exactly what I was trying to do! He explains it like so: The export command runs a query against a table called EXU9RLS in the SYS schema. On 11g this table was expanded with http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client the column POLTYP and the export command (exp) expects to find this column. I needed to download the 10g client so that I could use that version of exp instead. I haven't quite got it working yet but at least it's a different error to deal with! Be Sociable, Share! Tweet Written by Mark Needham January 13th, 2012 at 9:46 pm Posted in Software Development Tagged with oracle, Software Development « Learning Android: Roboguice - Injecting context into PreferenceManager http://www.markhneedham.com/blog/2012/01/13/oracle-exp-exp-00008-oracle-error-904-encounteredora-00904-poltyp-invalid-identifier/ Wireshark: Following HTTP requests/responses » Ali_mostafa24 Hi, I tried to exp and hit same error but after doing some analysis I came across below finding. Error: EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully Scenario 1: DB Instance 32 bit EXP possible via SQL : DB client 32 bit only Scenario 2: DB Instance 64 bit EXP possible via SQL: DB client 32 bit & 64 bit Regards,Alee Twitter Email Subscribe by email Search for: Archives Archives Select Month October 2016 (3) September 2016 (1) August 2016 (4) July 2016 (8) June 2016 (6) May 2016 (2) April 2016 (2) February 2016 (1) January 2016 (2) December 2015 (6) November 2015 (5) October 2015 (6) September 2015 (5) August 2015 (11) July 2015 (17) June 2015 (21) May 2015 (17) April 2015 (16) March 2015 (19) February 2015 (12) January 2015 (9) December 2014 (10) November 2014 (13) October 2014 (11) September 2014 (10) August 2014 (10) July 2014 (10) June 2014 (10) May 2014 (10) April 2014 (10) March 2014 (4) February 2014 (10) January 2014 (10) December 2013 (4) November 2013 (16) October 2013 (14) September 2013 (19) August 2013 (16) July 2013 (20) June 2013 (20) May 2013 (15) April 2013 (19) March 2013 (20) February 2013 (20) January 2013 (20) December 2012 (23) November 2012 (16) October 2012 (17) September 2012 (18) August 2012 (8) July
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 https://community.oracle.com/thread/2340482 and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions http://oisene.blogspot.com/2010/06/error-when-using-11g-export-client-on.html All PlacesDatabaseGeneral Database Discussions This discussion is archived 3 Replies Latest reply on Jan 27, 2012 5:41 AM by 900442 "ORA-00904: "POLTYP": invalid identifier" in export 913550 oracle error Jan 27, 2012 3:31 AM First I got errors when I did the export with an export tool of 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 00008 oracle error Then I tried to do export with another version of export tool (Release 10.2.0.4.0) The errors changed to the following: .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? Edited by: 910547 on Jan 26, 2012 7:31 PM I have the same question Show 0 Likes(0) 4185Views Tags: none (add) This content has been marked as final. Show 3 replies 1. Re: "ORA-00904: "POLTYP": invalid identifier" in export AliD Jan 27, 2012 3:34 AM (in response to 913550) Try exporting with EXPDP instead of EXP. Like Show 0 Likes(0) Actions 2. Re: "ORA-00904: "POLTYP": invalid identifier" in export Think_dba Jan 27, 2012 5:32 AM (in response to 913550) 910547 wrote: First I got errors when I did the export with an export tool of Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like the follow
the error "ORA-00904: "POLTYP": invalid identifier". This error occurs if you try the old export command from an 11g client against a database on version 10g or lower. The export command runs a query against a table called EXU9RLS in the SYS schema. On 11g this table was expanded with the column POLTYP and the export command (exp) expects to find this column. This should not be much of a problem since Data Pump export can be used. Posted by Oyvind Isene at 7:29 PM Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest Labels: 11g , exp , ORA-00904 , POLTYP 5 comments : Anonymous said... Data Pump cannot help: Export: Release 11.2.0.1.0 - Production on Wed Jun 30 14:44:57 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.UDE-00018: Data Pump client is incompatible with database version 10.2.0.3.0 June 30, 2010 at 2:54 PM Oyvind Isene said... Right, Data Pump export against a lower version won't work (Note 553337.1), you'll have to use the Data Pump client installed on the server with the source database. Since you'll have to fetch the export file from the same server it does not make much difference. Or you can run a Data Pump import over database link. June 30, 2010 at 3:57 PM Anonymous said... I found that if I ran the EXP command from an 11.2 client against an 11.1 server, I got the same error. If DESC SYS.EXU9RLS on this database, it is missing that column too. October 28, 2010 at 5:23 PM Anonymous said... there is a patch: 7568350executeCREATE OR REPLACE VIEW exu9rls ( objown, objnam, polgrp, policy, polown, polsch, polfun, stmt, chkopt, enabled, spolicy, poltyp) AS SELECT u.name, o.name, r.gname, r.pname, r.pfschma, r.ppname, r.pfname, DECODE(BITAND(r.stmt_type, 1), 0, '', 'SELECT,') || DECODE(BITAND(r.stmt_type, 2), 0, '', 'INSERT,') || DECODE(BITAND(r.stmt_type, 4), 0, '', 'UPDATE,') || DECODE(BITAND(r.stmt_type, 8), 0, '', 'DELETE,'), r.check_opt, r.enable_flag, DECODE(BITAND(r.stmt_type, 16), 0, 0, 1), case bitand(r.stmt_typ