SGA_TARGET nya diset seberapa besar? bw
--- In [email protected], "obie_xp" <obie...@...> 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 > > > > > >
