Dear All,
Saya mempunyai problem ketika melakukan import schema. Ketika akan dilakukan
import dengan menggunakan login user sys, proses yang terjadi lama sekali
(seperti idle). Berikut saya sertakan log processnya :
---------------------------------------------------------------------------------------------------------------------
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing HRDEV's objects into HRISMALACCA_TMP
--------------------------------------------------------------------------------------------------------------------
Prosesnya hanya sampai log terakhir saja, padahal sudah berjalan selama
beberapa jam.
Pertanyaannya :
1. Kira-kira kenapa yaa prosesnya lama sekali, padahal data dump tersebut tidak
begitu besar (sekitar 500 Mb).?
2. Bagaimana kita mengetahui / mengecek status dari proses dump tersebut..?
3. Bila saya import menggunakan user biasa (user target), akan muncul error
"IMP-00013: only a DBA can import a file exported by another DBA", padahal saya
sudah tambahkan role DBA ke user target tersebut..?.
Mohon pencerahannya,
Regard's
izzudin hanafie
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total
Access, No Cost.
[Non-text portions of this message have been removed]
