Coba jalankan script file berikut, lalu dicoba export lagi. > sqlplus /nolog
SQL> connect / as sysdba SQL> @?/rdbms/admin/catmetx.sql SQL> @?/rdbms/admin/utlrp.sql SQL> exit bw --- In [email protected], Andes Febrian <pejanta...@...> wrote: > > 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 <yulius_wib...@...>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 <pejantan4u@> > > 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] >
