| 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.
|
|
|
] 
Members
Search
Help
Register
Login
Home
