Oracle Error 904 Encountered 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 more about hiring developers or ora-00904: invalid identifier posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss exp 00008 oracle error 1003 encountered Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only
Ora 00904 Invalid Identifier During Export
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
Exp-00008 Oracle Error 1555 Encountered
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 Pump client is incompatible with database version 10.2.0.4.0 oracle oracle10g oracle11gr2 datapump share|improve this oracle bug 7568350 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 viewed 24173 times active 2 years ago Related 1Oracle 11g Top N Query returns different values to the same query running under 10g1Export from Oracle 10g database 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
Exp-00008: Oracle Error 3113 Encountered
of Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like the error code 904 oracle following: XP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier . . exporting table XRATE_INFO EXP-00008: ORACLE error 1003 encountered ORA-01003: ora-00904 dbms_java . longname invalid identifier 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 http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client 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 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 http://www.orafaq.com/forum/t/178387/ 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: 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 obja valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option http://docs.oracle.com/cd/B10501_01/server.920/a96525/e900.htm (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. Action: Correct the syntax or install the Procedural Option. ORA-00901 invalid CREATE command Cause: The CREATE command was not followed by a valid CREATE option. Action: Correct oracle error the syntax. ORA-00902 invalid datatype Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid. Action: Correct the syntax. ORA-00903 invalid table name Cause: A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER 00008 oracle error or DROP CLUSTER statement. Action: Check spelling. A valid table name or cluster name must begin with a letter and may contain only alphanumeric characters and the special characters $, _, and #. The name must be less than or equal to 30 characters and cannot be a reserved word. ORA-00904 string: invalid identifier Cause: The column name entered is either missing or invalid. Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word. ORA-00905 missing keyword Cause: A required keyword is missing. Action: Correct the syntax. ORA-00906 missing left parenthesis Cause: A required left parenthesis has been omitted. Certain commands, such as CREATE TABLE, CREATE CLUSTER, and INSERT, require a list of items enclosed in parentheses. Parentheses also are required around subqueries in WHERE clauses a