halo mas dody, yg oratransplant sudah saya baca, tp ada step startup migrate, sedangkan saya ngga pernah melakukan migrasi database, saya hanya ingin export satu schema dan muncul error tersebut. thanks.
On Thu, Feb 12, 2009 at 1:43 PM, dody osmon <[email protected]> wrote: > 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]<pejantan4u%40gmail.com>> > wrote: > From: Andes Febrian <[email protected] <pejantan4u%40gmail.com>> > Subject: [indo-oracle] ORA-00932: inconsistent datatypes: expected BLOB, > CLOB got CHAR > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
