Registration | Login

Upcoming Projects

Firefly Online
To be announced


Peter Panzerfaust Motion Comic
To be announced

Upcoming Events

Planet Comicon Kansas City
April 28-30, 2017

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

Photos of celebrities from the Glau-verse & beyond
By KevinInEngland

The Happy Birthday thread
By KevinInEngland

The OFFICIAL Summer Glau Appreciation Page!
By KevinInEngland

Summer Glau at Rhode Island Comic Con 2016
By chrisdvanne

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

Misc. News on Pilots and Series
By chrisdvanne

Interesting about the franchise and other TSCC things
By chrisdvanne

The Secret History of The Beast Wizard in TSCC via io9
By KevinInEngland

Misc. News on Movies and other Tidbits
By KevinInEngland

Lost Wiki header for The Cape Wiki
By chrisdvanne




New comments

Admirator on: Fan-made video reminds us why we love Summer


Александр XF on: GQ Photo shoot update


Admirator on: New candid picture of Summer


chrisdvanne on: New candid picture of Summer


Admirator on: New candid picture of Summer


chrisdvanne on: New candid picture of Summer


chrisdvanne on: GQ Photo shoot update


chrisdvanne on: GQ Photo shoot update


chrisdvanne on: GQ Photo shoot update


ec039 on: GQ Photo shoot update


New videos

00:05:42

00:01:20



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 *: