Registration | Login

Upcoming Projects

Firefly Online
To be announced


Peter Panzerfaust Motion Comic
To be announced

Upcoming Events

Wizard World Comic Con Chicago
August 24-27, 2017

San Francisco Comic Con
September 1-3, 2017

Wizard World Comic Con Nashville
September 8-10, 2017

Wizard World Comic Con Austin
November 17-19, 2017

Juke Joint!
By Admirator

Interesting about the franchise and other TSCC things
By KevinInEngland

The OFFICIAL Summer Glau Appreciation Page!
By chrisdvanne

The Happy Birthday thread
By KevinInEngland

Summer Glau at Comicpalooza 2015
By chrisdvanne

Everything on Wonder Woman Reboots
By robbo

Misc. News on Movies and other Tidbits
By robbo

Game of Thrones
By robbo

The official funny thread
By chrisdvanne

Summer Glau at Wizard World Comic Con Austin
By chrisdvanne




New comments

robbo on: Lovely shot of Summer and Val's wedding by Joan Allen


Admirator on: Lovely shot of Summer and Val's wedding by Joan Allen


robbo on: Breathtaking photo of Summer by Tarina Tarantino


chrisdvanne on: The cast of Firefly is coming to Wizard World Chicago, Nashville and Austin


Jim Scalia on: Breathtaking photo of Summer by Tarina Tarantino


mark cornwell on: The cast of Firefly is coming to Wizard World Chicago, Nashville and Austin


Martin John on: Artist Jake Thompson wins prize at Mary Valley Art contest with portrait of Summer


chrisdvanne on: Breathtaking photo of Summer by Tarina Tarantino


RedsBaron on: Breathtaking photo of Summer by Tarina Tarantino


KevinInEngland on: Breathtaking photo of Summer by Tarina Tarantino


New videos

00:04:51




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