Halo semua,
Mohon bantuan dan petunjuknya dalam solving kasus berikut.
Saya hendak meng-import schema dari Production ke Development environment, tapi
mengalami beberapa hambatan. Biasanya sih lancar2 saja, tapi baru kali ini
muncul kombinasi error :
IMP-00017: following statement failed with ORACLE error 3113
ORA-03113: end-of-file on communication channel
Berikut saya sertakan log yg sempat terbentuk:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00061: Warning: Object type "RMS13DEV"."RIB_LocPODtlsRspDtl_REC" already
exists with a different identifier
"CREATE TYPE "RIB_LocPODtlsRspDtl_REC" TIMESTAMP '2009-08-18:19:15:10' OID '"
"692DB40D36050FB0E04400144FB7C0D5' "
" "
" UNDER RIB_OBJECT ("
" item varchar2(25),"
" pack_size number(12,4),"
" ordered_quantity number(12,4),"
" unit_cost number(20,4),"
" OVERRIDING MEMBER PROCEDURE appendNodeValues( i_prefix IN VARCHAR2)"
");"
IMP-00017: following statement failed with ORACLE error 3113:
"CREATE TYPE "RIB_LocPODtlsRspDtl_TBL" TIMESTAMP '2009-08-18:19:18:37' OID '"
"692DB40D360F0FB0E04400144FB7C0D5' "
" "
" AS TABLE OF "RIB_LocPODtlsRspDtl_REC";"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully
Terima kasih banyak sebelumnya.
Regards,
Dimas
[Non-text portions of this message have been removed]
