Coba login sbg DBA, lalu jalankan query berikut:
select PROPERTY_NAME,PROPERTY_VALUE from database_properties where
PROPERTY_NAME IN ('NLS_LENGTH_SEMANTICS','NLS_CHARACTERSET');
Dan tolong hasilnya dikirim ke milis.
bw
--- In [email protected], Andes Febrian <pejanta...@...>
wrote:
>
> 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]
>
