Home » RDBMS Server » Server Utilities » "ORA-00904 POLTYP: invalid identifier" when export (Oracle 10.2.0.4.0 -64bit, Windows 2003 R2 64bit)
"ORA-00904 POLTYP: invalid identifier" when export [message #540989] Thu, 26 January 2012 21:03 Go to next message
basarakin
Messages: 3
Registered: January 2012
Junior Member
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

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
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?
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #540990 is a reply to message #540989] Thu, 26 January 2012 21:18 Go to previous messageGo to next message
BlackSwan
Messages: 23065
Registered: January 2009
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;
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #540996 is a reply to message #540989] Fri, 27 January 2012 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste the complete sequence of statements and output.

Regards
Michel
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541018 is a reply to message #540996] Fri, 27 January 2012 01:59 Go to previous messageGo to next message
basarakin
Messages: 3
Registered: 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=<address>

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 links
. exporting sequence numbers
. exporting cluster definitions
. 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

Thanks
Kin

[Updated on: Fri, 27 January 2012 01:59]

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541027 is a reply to message #541018] Fri, 27 January 2012 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
exp parfile=<address>

Which gives us no clue of what was the parameters.

Regards
Michel
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541032 is a reply to message #541027] Fri, 27 January 2012 02:49 Go to previous messageGo to next message
basarakin
Messages: 3
Registered: January 2012
Junior Member
sorry for my missing the parameters of the parfile
the parameters were:

owner=FM
consistent=Y
grants=Y
indexes=Y
rows=Y
compress=Y
triggers=Y
statistics=NONE
direct=Y

Thanks
Kin

[Updated on: Fri, 27 January 2012 02:50]

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541033 is a reply to message #541032] Fri, 27 January 2012 03:04 Go to previous messageGo to next message
John Watson
Messages: 4812
Registered: January 2010
Location: Global Village
Senior Member
Bug 7568350, there's a patch.
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541235 is a reply to message #541033] Mon, 30 January 2012 03:06 Go to previous messageGo to next message
Shella
Messages: 2
Registered: January 2012
Junior Member
where is the patch?
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541253 is a reply to message #541235] Mon, 30 January 2012 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On MOS

Regards
Michel
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541360 is a reply to message #541253] Mon, 30 January 2012 20:28 Go to previous messageGo to next message
Shella
Messages: 2
Registered: January 2012
Junior Member
thank you Michel. I just feel a little doubt. The patch is 2G. It's bigger then oracle installer. I installed oracle express edition.
thanks again.

Regards
Shella
Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541392 is a reply to message #541360] Tue, 31 January 2012 01:43 Go to previous messageGo to next message
John Watson
Messages: 4812
Registered: January 2010
Location: Global Village
Senior Member
The patch is 113.8k

(that's the size, not the price)

[Updated on: Tue, 31 January 2012 01:44]

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541402 is a reply to message #541360] Tue, 31 January 2012 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think you get the correct patch.
If you are on Unix/Linux, the patch is around 100-150KB depending on the platform and Oracle version.
If you are on Windows, I bet it is include in a bundle which depends on your base version (the first 4 decimals).

Regards
Michel

[I should know that answering on a window opened since more than one hour would contain the same kind of answer. Smile ]

[Updated on: Tue, 31 January 2012 02:18]

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #577240 is a reply to message #541402] Wed, 13 February 2013 12:04 Go to previous message
Chris1000
Messages: 1
Registered: February 2013
Location: Canada
Junior Member
I had this with Oracle 11.2.0.3 64 bit on windows. Recently I had removed grants to java to tighten security. Granting these resolved the exp issues:

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> revoke execute on dbms_java from public;

Revoke succeeded.

SQL> revoke execute on dbms_java_TEST from public;

Revoke succeeded.

SQL> revoke execute on dbms_jvm_EXP_PERMS from public;

Revoke succeeded.

SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

E:\work\payroll>exp system/ABCDEF@DBNAME owner=payroll

Export: Release 11.2.0.3.0 - Production on Wed Feb 13 13:59:13 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PAYROLL
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: : invalid identifier
EXP-00000: Export terminated unsuccessfully

THE FIX:

E:\work\PAYROLL>
E:\work\PAYROLL>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 13 14:01:42 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> grant execute on dbms_java to public;

Grant succeeded.

SQL> grant execute on dbms_java_TEST to public;

Grant succeeded.

SQL> grant execute on dbms_jvm_EXP_PERMS to public;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

E:\work\PAYROLL>exp system/XXTYXYY@dbname owner=PAYROLL

Export: Release 11.2.0.3.0 - Production on Wed Feb 13 14:01:51 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PAYROLL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user PAYROLL
About to export PAYROLL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PAYROLL's tables via Conventional Path ...
. . exporting table ACPAYROLLS_ENROLLMENTS 107813 rows exported
. . exporting table AGENCIES 2 rows exported
. . exporting table APPROVAL_LEVELS 3 rows exported

Previous Topic: SQL Loader Error
Next Topic: Tracing
Goto Forum:
  


Current Time: Fri Nov 28 11:38:15 CST 2014

Total time taken to generate the page: 0.13189 seconds