Data pump expdp ORA-39097
Bonjour,
Je suis entrain de mettre un export sur notre base de données oracle 11.2 avec data pump.
voici la ligne que je fais:
Code:
1 2
|
expdp login/***** full=Y directory=data_pump_dir dumpfile=full_dev.dmp logfile=full_dev.log job_name=exp_full |
j'obtiens ces erreurs:
Code:
1 2 3 4 5 6 7
|
ORA-39097: Data Pump job encountered unexpected error -4031
ORA-39065: unexpected master process exception in MAIN
ORA-04031: unable to allocate 528 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","SQLA^bbcee4f7","qerixs : rixalo")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPC$QUE_INT"
Job "***"."EXP_FULL" stopped due to fatal error at 18:05:49 |
Quand je fais :
Code:
1 2
|
expdp login/****** full=Y estimate_only=y nologfile=y |
Code:
1 2 3
|
Total estimation using BLOCKS method: 38.19 GB
Job "***"."SYS_EXPORT_FULL_01" successfully completed at 17:44:56 |
donc il le prend bien en compte.
J'ai fais un df -h et j'ai de la place pour mettre le dump.
D’où ma question que se passe t il?
Merci d'avance.
Chris.