| CPU patch issue [message #385718] |
Tue, 10 February 2009 15:10  |
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 #422727 is a reply to message #385786] |
Fri, 18 September 2009 09:39  |
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 |
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 |
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 #539966 is a reply to message #522602] |
Thu, 19 January 2012 10:07 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
