Upcoming Projects

Firefly Online
To be announced


Peter Panzerfaust Motion Comic
To be announced

Upcoming Events

Wizard World Comic Con Austin
November 17-19, 2017

Wizard World Comic Con New Orleans
January 5-7, 2017

The OFFICIAL Summer Glau Appreciation Page!
By Admirator

The official funny thread
By Admirator

TSCC fanfictions
By The1Russter

obsessed with Summer
By diya123working

Josh Friedman news
By chrisdvanne

Summer Glau at San Francisco Comic Con 2017
By chrisdvanne

The Fanart Thread
By chrisdvanne

Misc. News on Movies and other Tidbits
By chrisdvanne

Submit a News or Article
By chrisdvanne

Summer Glau at Wizard World Chicago Comic Con 2017
By chrisdvanne




New comments

Admirator on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


chrisdvanne on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


Admirator on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


chrisdvanne on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


Lewis on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


Lewis on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


Jimmy PK on: Convention stories : Gregg's trip to Nashville to meet Summer


Admirator on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


chrisdvanne on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


Admirator on: Fans share photos and stories of meeting Summer at San Francisco Comic Con


New videos

00:02:30

00:01:03

00:44:02


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