ORA-31634 and dbms_datapump
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: http://arjudba.blogspot.com/2009/05/how-to-cleanup-orphaned-datapump-jobs.html. So I did like the post says:
> select * from user_datapump_jobs; JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS -------- --------- -------- -------- ------ ----------------- ----------------- 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:
declare j number; begin j := dbms_datapump.attach('MYJOB'); dbms_datapump.stop_job(j); end; /
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.
summer glau fan site
The new and improved fan site dedicated to Summer Glau.
Summer Glau Rules!!!!!!!!!!!!
Summer Glau stopped by the Dragon Con Blood Drive to show her support. This was a charity auction at this years Dragon Con where people could give blood. Dragon Con is not all about the costumes and rubbing elbows with celebrities. The organizers also ensure that ample opportunity is provided to give back to the community by holding one of the largest blood drives in the city.
Dr. Koslow is the volunteer chairperson, They were 200 people and 300 units short of the world record with 2900 donors
Check out this cute video of Summer Glau in which she promotes the Dragon Con Blood Drive.