hi all, saya pengen coba migrasi data menggunakan fitur expdp. waktu saya coba menggunakan user scott semuanya berjalan lancar, artinya file.dmp dan .log tercreate tetepi sewaktu saya coba di mesin production nya malah gak jalan,
> mkdir /data_pump/backup > sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 6 18:02:14 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options SQL> create or replace directory dumpfile as '/data_pump/backup'; Directory created. SQL> GRANT READ, WRITE ON DIRECTORY dumpfile TO redfast; Grant succeeded. SQL> exit > expdp redfast/redfast123 tables=ADM_ACTIVITY_LOG,ADM_ACTIVITY_LOG2 directory=dumpfile dumpfile=adm_redfast.dmp logfile=adm_redfast.log Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 06 August, 2009 18:05:12 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options ORA-31626: job does not exist ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user REDFAST ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1201 ORA-39062: error creating master process DM00 ORA-39107: Master process DM00 violated startup protocol. Master error: ORA-06533: Subscript beyond count > > error ORA diatas sudah saya trace tetapi belum bisa solve mohon pencerahan ... catur.wibawa ------------------------------------- [email protected] [Non-text portions of this message have been removed]
