Terima kasih pak yulius. Saya coba di environment lain yang SGAnya lebih besar dan berhasil. Thanks Atas petunjuknya.
--- In [email protected], "yulius_wibowo" <yulius_wib...@...> wrote: > > > SGA_TARGET nya diset seberapa besar? > > bw > > --- In [email protected], "obie_xp" <obie_xp@> wrote: > > > > Terima kasih pak yulius. saya sudah membuat logical Directory seperti yang > > bapak minta. dengan perintah sebagai berikut: > > CREATE OR REPLACE DIRECTORY backup AS '/dbop' ; > > GRANT IMP_FULL_DATABASE TO OBIE_DATA; > > GRANT EXP_FULL_DATABASE TO OBIE_DATA; > > grant read,write on directory backup to OBIE_DATA; > > > > lalu saya coba cek di DBA_DIRECTORIES: > > > > SELECT * FROM DBA_DIRECTORIES. > > > > Kemudian saya ulangi perintah backup tadi : > > > > expdp OBIE_DATA/xxxxx DIRECTORY=backup DUMPFILE=rpm_backup231109.dmp > > LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3) > > > > Tetapi masih terdapat error : > > > > 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 RMS13DEV > > 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_20091126153947" and > > "KUPC$S_1_20091126153947" 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") > > > > Mohon Petunjuk lagi. > > > > Regards, > > OBIE > > > > --- In [email protected], "yulius_wibowo" <yulius_wibowo@> wrote: > > > > > > > > > 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_xp@> 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 > > > > > > > > > >
