OraFAQ Forum: Server Utilities » "ORA-00904 POLTYP: invalid identifier" when export

Home » RDBMS Server » Server Utilities » "ORA-00904 POLTYP: invalid identifier" when export (Oracle 10.2.0.4.0 -64bit, Windows 2003 R2 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"ORA-00904 POLTYP: invalid identifier" when export [message #540989]

Thu, 26 January 2012 21:03

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?

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: 26766
Registered: 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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account 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: 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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

exp parfile=<address>

Which gives us no clue of what was the parameters.

Regards
Michel

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541032 is a reply to message #541027]

Fri, 27 January 2012 02:49

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

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Bug 7568350, there's a patch.

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541235 is a reply to message #541033]

Mon, 30 January 2012 03:06

Shella
Messages: 2
Registered: January 2012

Junior Member

where is the patch?

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541253 is a reply to message #541235]

Mon, 30 January 2012 03:50

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

On MOS

Regards
Michel

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541360 is a reply to message #541253]

Mon, 30 January 2012 20:28

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

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #541392 is a reply to message #541360]

Tue, 31 January 2012 01:43

John Watson
Messages: 8964
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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #674803 is a reply to message #541402]

Mon, 18 February 2019 04:22

sajidnas
Messages: 1
Registered: February 2011
Location: Makkah

Junior Member

Regards Sir
can you please send patch for 7568350, I don't have the user id for MOS in [removed]

[Edit MC: email removed]

[Updated on: Mon, 18 February 2019 04:28] by Moderator

Report message to a moderator

Re: "ORA-00904 POLTYP: invalid identifier" when export [message #674805 is a reply to message #674803]

Mon, 18 February 2019 04:28

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you can't have the patch.

Report message to a moderator

Previous Topic:	impdp can't read the file
Next Topic:	SQL Loader for XML File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:31:46 CST 2025