OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Data Pump HELP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Pump HELP [message #178928]

Fri, 23 June 2006 07:36

crosimoto
Messages: 6
Registered: June 2006
Location: Washington DC

Junior Member

Hello,
I'm having a bit of trouble with data pump.
I've had a few expdp jobs fail. each time it fails a table is created SYS_EXPORT_SCHEMA_01..up to 05. How di I get rid of these tables (I figured there's probably a function in dbms_datapump) to get rid of them. I didn't want to just 'drop' them and have things go even more horribly wrong.

Report message to a moderator

Re: Data Pump HELP [message #178931 is a reply to message #178928]

Fri, 23 June 2006 07:42

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

I've you don't want to restart those jobs, you can just drop their master tables.

Alternatively, start impdp/expdp, ATTACH to those jobs and issue the KILL_JOB command.

Report message to a moderator

Re: Data Pump HELP [message #178948 is a reply to message #178928]

Fri, 23 June 2006 09:39

crosimoto
Messages: 6
Registered: June 2006
Location: Washington DC

Junior Member

Thanks for the help,
I tried to ATTACH and KILL_JOB on these earlier but Oracle would only let me attach to the most recent job (not the 4 earlier mistakes).

Report message to a moderator

Re: Data Pump HELP [message #178952 is a reply to message #178948]

Fri, 23 June 2006 09:49

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

In that case, just drop the master tables. After doing it they will disappear from DBA_DATAPUMP_JOBS.

Report message to a moderator

Previous Topic:	imp/exp only procedures/packages only..
Next Topic:	More Datapump Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:42:30 CST 2024