Registration | Login

Upcoming Projects

Firefly Online
To be announced


Peter Panzerfaust Motion Comic
To be announced

Upcoming Events

Paradise City Comic Con
December 9-11, 2016

MCM Hannover Comic Con
May 20-21, 2017

MCM London Comic Con
May 26-28, 2017

MCM Belfast Comic Con
June 24-25, 2017

MCM Ireland Comic Con
July 1-2, 2017

Interesting about the franchise and other TSCC things
By Admirator

The Fanart Thread
By Admirator

Summer Glau on Arrow
By KevinInEngland

Misc. News on Movies and other Tidbits
By chrisdvanne

Ron Glass, 'Shepherd Book' in Firefly, dies at 71
By chrisdvanne

Russian thread
By chrisdvanne

Summer Glau at Comic Con Russia 2015
By chrisdvanne

Voice Acting in 'Firefly Online' roleplaying game
By chrisdvanne

The OFFICIAL Summer Glau Appreciation Page!
By KevinInEngland

Misc. News on Pilots and Series
By robbo




New comments

Admirator on: Summer joins Paradise City Comic Con


chrisdvanne on: Summer joins Paradise City Comic Con


Admirator on: Summer joins Paradise City Comic Con


Admirator on: Photos from Summer's Rhode Island Comic Con panel


chrisdvanne on: Summer joins MCM Ireland Comic Con


chrisdvanne on: Photos from Summer's Rhode Island Comic Con panel


Garrett on: Photographer Joan Allen unveils lovely family photo with Summer, Val and Milena


chrisdvanne on: Photographer Joan Allen unveils lovely family photo with Summer, Val and Milena


chrisdvanne on: Interview: Summer talks about joining the Marvel Cinematic Universe


Dennis MacFarlane on: Interview: Summer talks about joining the Marvel Cinematic Universe


New videos

00:05:25

00:44:03

00:03:07


latest images

ORA-31634 and dbms_datapump

POSTED BY Charley_Dixon ON Nov 28, 2010 / 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: 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.





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

Total comments: 0



 
Name *:
Email:
Code *: