pak bowo, bila saya jalankan kedua file sql ini, ada pengaruh dgn dataguard yg ada di server ini gak ?
setelah jalankan .sql ini, saya lgsg coba export lagi kah ? Thanks On Fri, Feb 13, 2009 at 9:45 AM, Yulius Wibowo <[email protected]>wrote: > 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] <indo-oracle%40yahoogroups.com>, 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><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] > > > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
