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

The official funny thread
By chrisdvanne

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

Misc. News on Movies and other Tidbits
By chrisdvanne

Submit a News or Article
By chrisdvanne

Sarah & Cameron in TSCC - I Was Made For Loving You - video
By chrisdvanne

The OFFICIAL Summer Glau Appreciation Page!
By chrisdvanne

The Happy Birthday thread
By chrisdvanne

Summer Glau at Rose City Comic Con 2016
By chrisdvanne

What was the best Cameron fighting scene in TSCC?
By chrisdvanne

Summer Glau at Dallas Comic Con 2014
By chrisdvanne




New comments

Admirator on: The Serenity cast hopes to make a trilogy in unearthed 2004 video interviews


chrisdvanne on: The Serenity cast hopes to make a trilogy in unearthed 2004 video interviews


chrisdvanne on: River Tam figure in the next Firefly Loot Crate!


chrisdvanne on: Have a question for Summer? Here's your chance to ask it!


William on: Have a question for Summer? Here's your chance to ask it!


chrisdvanne on: Have a question for Summer? Here's your chance to ask it!


resurgance2001 on: Have a question for Summer? Here's your chance to ask it!


dmitriy on: Have a question for Summer? Here's your chance to ask it!


chrisdvanne on: Have a question for Summer? Here's your chance to ask it!


Eric Hammers on: Have a question for Summer? Here's your chance to ask it!


New videos

00:05:50

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