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_wib...@...> 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
> >
>
