Home » RDBMS Server » Server Utilities » Export Backup
Export Backup [message #223497] Fri, 09 March 2007 03:21 Go to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
Hi

I am getting this error while exporting the Database.

Can u help me?

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Export done in US7ASCII 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 SYSADM . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user SYSADM About to export SYSADM'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

Thanks and Regards
Manjunath Maller
Re: Export Backup [message #223632 is a reply to message #223497] Fri, 09 March 2007 19:36 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
>ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

I do not think blob's and clob's can be exported
Re: Export Backup [message #223641 is a reply to message #223497] Fri, 09 March 2007 23:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
http://www.oratransplant.nl/2005/11/22/unable-to-export-char-semantic-102-database/


Go through below link

regards
Taj
Re: Export Backup [message #223956 is a reply to message #223641] Mon, 12 March 2007 07:22 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


gr8 taj.

Babu
Previous Topic: sql loader and foreign keys
Next Topic: Import / Export
Goto Forum:
  


Current Time: Sat Dec 07 00:35:39 CST 2024