Home » RDBMS Server » Server Administration » CPU patch issue (Oracle 10.2.0.3 on Windows 03)
CPU patch issue [message #385718] Tue, 10 February 2009 15:10 Go to next message
Ditch
Messages: 1
Registered: February 2009
Location: Frederick, MD
Junior Member
Hi all
I applied the Jan 09 CPU to my database this past Saturday and now my daily schema export is not running properly:

With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST 's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST 's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully


has anyone else experienced a similar problem? I tried to find any info on google and some other sites, but have found nothing. Please help.
Re: CPU patch issue [message #385719 is a reply to message #385718] Tue, 10 February 2009 15:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

>ORA-00904: "POLTYP": invalid identifier
using SQLPLUS along with CUT & PASTE to show us all that is known about object POLTYP

[Updated on: Tue, 10 February 2009 15:16]

Report message to a moderator

Re: CPU patch issue [message #385786 is a reply to message #385718] Wed, 11 February 2009 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you follow ALL the steps detailed in readme file?

Regards
Michel
Re: CPU patch issue [message #422727 is a reply to message #385786] Fri, 18 September 2009 09:39 Go to previous messageGo to next message
gibby
Messages: 1
Registered: September 2009
Junior Member
Hello Everyone,

I'm apparently having the same issue. I have a 10g out there that I need to replicate down for some testing, and exp is failing. I've googled "POLTYP" the best I can, and followed all the steps when the patches were applied (to the best of my knowlege)

In short I get:
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier

The patches applied are 5746875 and 7631956.

Any help is greatly appreciated!

Thank you
--

Export: Release 10.2.0.3.0 - Production on Fri Sep 18 00:59:59 2009

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


Connected to: Oracle Database 10g Release 10.2.0.3.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully

--
Details - Windows Server 2008 / 10g
SQL> SELECT * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.3.0 - Production
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
Re: CPU patch issue [message #429819 is a reply to message #422727] Thu, 05 November 2009 20:49 Go to previous messageGo to next message
shlim76
Messages: 1
Registered: November 2009
Location: Malaysia
Junior Member
I have the same error too. The exp program might have been overwritten when u applied you patch. Try to get the original version of exp program and use it to export your database.
Re: CPU patch issue [message #447622 is a reply to message #385718] Tue, 16 March 2010 16:54 Go to previous messageGo to next message
ttc123
Messages: 1
Registered: March 2010
Junior Member
I encountered the "ORA-00904: : invalid identifier" error, running the Oracle 10g (10.2.0.4.0) 'exp' utility.

A Google search led me to a Burleson tip,
www.dba-oracle.com t_exp_00008_904_error.htm

While the 3rd possible cause listed specified Oracle 8i,
I remember another member of my team was closing a reported
security vulnerability by revoking EXECUTE from PUBLIC on DBMS_JAVA, DBMS_JAVA_TEST and DBMS_JVM_EXP_PERMS.

I issued direct EXECUTE privleges on just DBMS_JAVA and DBMS_JAVA_TEST to the database account that I was trying to run 'exp' with, reran my export and it then succeeded without error. It's possible DBMS_JAVA_TEST was not needed.
Re: CPU patch issue [message #522599 is a reply to message #447622] Mon, 12 September 2011 13:06 Go to previous messageGo to next message
kotagirip
Messages: 1
Registered: November 2006
Junior Member
You may not be using same export utility version as your database.
Re: CPU patch issue [message #522602 is a reply to message #522599] Mon, 12 September 2011 13:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a 2 years old topic, let it rest in peace (unless you have a defintive answer/solution which is not the case here).
You should focus on more recent topic to give your help (which is welcome).

Regards
Michel
Re: CPU patch issue [message #539966 is a reply to message #522602] Thu, 19 January 2012 10:07 Go to previous message
hallo
Messages: 1
Registered: January 2012
Junior Member
I have the resolution:
I just ran into that error using an Oracle 11.2 db trying to export via sqlnet from a remote Oracle 10 db.
It would be nice if it would work that easily,
but one needs to do further steps.

Thus, the necessary steps:
export the Oracle 10 db with exp, copy the dmp to the the machine withe Oracle 11.2, import the dmp with imp to Oracle 11.2
That's all.
Just doing in 11.2: exp <user>/<passwd>@<oracle10> does give the error.
have fun

[Updated on: Thu, 19 January 2012 10:08]

Report message to a moderator

Previous Topic: Un necessary tables present
Next Topic: SCN max value (was: Oracle flaw revealed ?)
Goto Forum:
  


Current Time: Fri Mar 29 02:02:35 CDT 2024