ORA-00932 DURING EXPORT
51511Oct 2 2009 — edited Oct 5 2009Trying to do an export, we encounter an ORA-00932.
This is what happens:
**************
C:\TEMP>exp userid=user/pwd@db file=expdat.dmp
Export: Release 10.2.0.1.0 - Production on To Okt 1 10:55:31 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user USER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user USER
About to export USER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully
***********************************
The failing command is:
****************
SQL> select url, local, stripped_val from sys.ku$_xmlschema_view;
select url, local, stripped_val from sys.ku$_xmlschema_view
...............*
**********************************
Any suggestions as to what I have to do to correct this? Please?
:-( arjo
Edited by: arnejohn on Oct 2, 2009 1:50 AM