menu
person
Welcome to summer-glau.com, your fan source for all things Summer on the web. Browse around the site and visit our growing GALLERY housing over 65,000 photos. Don’t forget to follow us on Twitter and Facebook and be sure to visit the site again!
Category: Charlie's blog

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.



Category: Summer Glau

Summer Glau is so beautiful

Summer Glau is so beautiful

 

Summer Glau is so beautiful<3

 



Category: Summer Glau

summer glau fan site

The new and improved fan site dedicated to Summer Glau.

Summer Glau Rules!!!!!!!!!!!!



Category: Summer Glau

Summer Supports Dragon Con Blood Drive

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.

 

 



« 1 2 ... 138 139 140