pak bowo makasih atas responya, berikut hasil dari query berikut :
SQL> select PROPERTY_NAME,PROPERTY_VALUE from database_properties
2 where
3 PROPERTY_NAME IN ('NLS_LENGTH_SEMANTICS','NLS_CHARACTERSET');
PROPERTY_NAME
------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
WE8ISO8859P1
NLS_LENGTH_SEMANTICS
BYTE
On Thu, Feb 12, 2009 at 2:34 PM, Yulius Wibowo <[email protected]>wrote:
> 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] <indo-oracle%40yahoogroups.com>, 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]
> >
>
>
>
--
Cheers,
^_^ Andes ^_^
[Non-text portions of this message have been removed]
