Latest Photos

Check out the latest additions to our ever expanding GALLERY hosting over 65,000 photos!

ORA-31634 and dbms_datapump

28 Nov 2010
Charley_Dixon 0 Comments

Today I tried to import some data into the database. I used dbms_datapump instead of impdp which I usually use for that. Unfortunately I forgot to chgrp oinstall *.dmp, so I've got an obvious error and after an obvious fix I've tried to run the job again... and got ORA-31634: job already exists. I did not want to rename a new job and after a little googling I found this nice blog post: So I did like the post says:

> select * from user_datapump_jobs;
-------- --------- -------- -------- ------ ----------------- -----------------
MYJOB    IMPORT    SCHEMA   DEFINING      1                 1                 2

I tried:

drop table MYJOB;
purge recyclebin;

and I saw the job was still there. Then I did:

 j number;
 j := dbms_datapump.attach('MYJOB');

but the job obviously did not want to disappear. I had no idea what else I could do, so... I disconnected from the database. After I connected again the user_datapump_jobs was empty and I was able to import my data! I'm still wondering if it's because the job had attached sessions or it just takes some time to finish a job.

Like our Facebook fan page below to stay connected to the latest Summer Glau news!

Total comments: 0

Name *:
Code *:

Total online: 3
Guests: 3
Users: 0