udah pernah coba yang di url ini : http://www.oratransplant.nl/2005/11/22/unable-to-export-char-semantic-102-database/ http://forums.oracle.com/forums/thread.jspa?threadID=384449
--- On Thu, 2/12/09, Andes Febrian <[email protected]> wrote: From: Andes Febrian <[email protected]> Subject: [indo-oracle] ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR To: [email protected] Date: Thursday, February 12, 2009, 1:21 AM Dear gurus, database saya versi 10.2.0.1 running on AIX 5.3. ketika saya export, muncul error seperti dibawah ini, $ exp dakatsi/dakatsi file=dataksi120209. dmp Export: Release 10.2.0.1.0 - Production on Thu Feb 12 12:13:21 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. 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) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user DAKATSI . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user DAKATSI About to export DAKATSI'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 cari2 di inet tp semua membahas masalah migrasi, sedangkan saya bukan migrasi melainkan hanya export satu schema saja. mohon pencerahannya. Thanks, -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
