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

Misc. News on Movies and other Tidbits
By chrisdvanne

The official funny thread
By chrisdvanne

Summer Glau at Planet Comicon Kansas City 2017
By chrisdvanne

Misc. News on Pilots and Series
By KevinInEngland

The Happy Birthday thread
By KevinInEngland

Summer Glau at FACTS
By chrisdvanne

The OFFICIAL Summer Glau Appreciation Page!
By KevinInEngland

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

Interesting about the franchise and other TSCC things
By KevinInEngland

Website Information
By Admirator




New comments

KevinInEngland on: Summer Glau and Joss Whedon at the Dizzy Feet Foundation gala


chrisdvanne on: Summer joins MCM Ireland Comic Con


KevinInEngland on: Brief interview with Summer Glau on set of Terminator: The Sarah Connor Chronicles


KevinInEngland on: Gallery update: Nathan Fillion, Summer Glau and Joss Whedon in UK TV show to promote Serenity


chrisdvanne on: Gallery update: Nathan Fillion, Summer Glau and Joss Whedon in UK TV show to promote Serenity


chrisdvanne on: Gallery update: Nathan Fillion, Summer Glau and Joss Whedon in UK TV show to promote Serenity


Admirator on: Happy New Year 2017 everyone!


chrisdvanne on: Happy New Year 2017 everyone!


KevinInEngland on: Happy New Year 2017 everyone!


chrisdvanne on: Happy New Year 2017 everyone!


New videos

00:01:20


00:02:56


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