Coba pastikan nilai utk opsi directory sudah sesuai dgn informasi yg ada di DBA_DIRECTORIES. Perlu dicatat nilai DIRECTORY bukanlah PHYSICAL directory melainkan LOGICAL directory yg didefinisikan menggunakan CREATE DIRECTORY.
cmiiw, Bowo --- In [email protected], "obie_xp" <obie...@...> wrote: > > Teman2 master oracle saya ingin bertanya tentang masalah yang saya hadapi > saat melakukan export database dengan perintah EXPDP > > expdp OBIE_DATA/xxxxx DIRECTORY=/dbop/backup DUMPFILE=rpm_backup231109.dmp > LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3) > > Terdapat eror seperti dibawah ini : > Copyright (c) 2003, 2005, Oracle. All rights reserved. > > Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - > 64bit Production > With the Partitioning, OLAP and Data Mining options > ORA-31626: job does not exist > ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user OBIE_DATA > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 > ORA-06512: at "SYS.KUPV$FT_INT", line 600 > ORA-39080: failed to create queues "KUPC$C_1_20091126094544" and > "KUPC$S_1_20091126094544" for Data Pump job > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 > ORA-06512: at "SYS.KUPC$QUE_INT", line 1580 > ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams > pool","unknown object","streams pool","fixed allocation callback") > > Apakah ada konfigurasi yang belum dilakukan terhadap user OBIE_DATA? > > Mohon Petunjuknya. > > Regards, > OBIE >
