saya mencoba import dengan menggunakan data pump, cara nya seperti ini:
c:\oracle> set oracle_sid=coba
c:\oracle> sqlplus /nolog, terus oracle saya startup
sql> create or replace directory dumporcl as 'd:\';
sql> exit;
-- > backup exp01.dat hasil dari export data pump saya letakkan di d:\
d:\backup ora> impdp d_transaksi/xx directory=dumporcl dumpfile=exp01.dat
ternyata hasilnya:
Import: Release 10.1.0.2.0 - Production on Friday, 21 April, 2006 17:00
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "D_TRANSAKSI"."SYS_IMPORT_FULL_03" successfully loaded/unloaded
Starting "D_TRANSAKSI"."SYS_IMPORT_FULL_03": d_transaksi/******** directory=dum
porcl dumpfile=exp01.dat
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [TABLE_DAT
A:"D_TRANSAKSI"."SYS_IMPORT_FULL_03"]
SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position,
:2), dump_length, dump_allocation, grantor, object_row, object_schema, object_lo
ng_name, processing_status, processing_state, base_object_type, base_object_sche
ma, base_object_name, property, in_progress FROM "D_TRANSAKSI"."SYS_IMPORT_FULL_
03" WHERE process_order between :3 AND :4 AND processing_state <> :5 AND duplic
ate = 0 ORDER BY process_order
ORA-25153: Temporary Tablespace is Empty
----- PL/SQL Call Stack -----
object line object
handle number name
694CA700 13460 package body SYS.KUPW$WORKER
694CA700 5810 package body SYS.KUPW$WORKER
694CA700 3080 package body SYS.KUPW$WORKER
694CA700 6353 package body SYS.KUPW$WORKER
694CA700 1208 package body SYS.KUPW$WORKER
693D86EC 2 anonymous block
Job "D_TRANSAKSI"."SYS_IMPORT_FULL_03" stopped due to fatal error at 17:01
Adakah teman2 yang tahu error tesebut bagaimana solusinya?
salam
betty
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
