OraFAQ Forum: Server Utilities » IMPDP in Oracle 11g

Home » RDBMS Server » Server Utilities » IMPDP in Oracle 11g (Oracle 11g)

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

IMPDP in Oracle 11g [message #601195]

Mon, 18 November 2013 06:45

kalpeshrmopkar
Messages: 10
Registered: November 2013

Junior Member

Pressing Ctrl+C navigates to impdp command prompt. Read many articles, but the actual result of pressing Ctrl+C is not clear.

Report message to a moderator

Re: IMPDP in Oracle 11g [message #601196 is a reply to message #601195]

Mon, 18 November 2013 06:58

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

In a command line the result is usually that SIGINT is sent to the program which causes it to terminate.

Report message to a moderator

Re: IMPDP in Oracle 11g [message #601251 is a reply to message #601196]

Mon, 18 November 2013 22:45

kalpeshrmopkar
Messages: 10
Registered: November 2013

Junior Member

But on getting the prompt, we can resume the job. So, it is still unclear that whether the job gets paused or it is terminated. Also, if the job gets paused, then does the job process still keeps alive in the background?

Report message to a moderator

Re: IMPDP in Oracle 11g [message #601254 is a reply to message #601251]

Mon, 18 November 2013 23:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

problem & solution have NOTHING to do with Oracle.
problem & solution are OS & shell dependent upon local customizations.

we don't even know which OS name or version you have.

Report message to a moderator

Re: IMPDP in Oracle 11g [message #601260 is a reply to message #601254]

Mon, 18 November 2013 23:28

kalpeshrmopkar
Messages: 10
Registered: November 2013

Junior Member

I have Oracle 11g installed on AIX 6.1

Report message to a moderator

Re: IMPDP in Oracle 11g [message #603206 is a reply to message #601260]

Thu, 12 December 2013 03:02

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Pressing <CTRL>-C causes IMPDP to put you into an interactive command mode. The process is obviously still running. You can decide to abort the export from there or allow it to continue.

What is the question here?

Report message to a moderator

Re: IMPDP in Oracle 11g [message #603214 is a reply to message #601195]

Thu, 12 December 2013 03:27

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Data Pump, in the opposite of old exp/imp, run with 2 levels, a client part and a server part.
impdp is the client part, suspending or stopping it does not do anything on the server part.
So, Ctl-C on impdp makes you get a prompt so you can send command to the server part (like suspend or aborting the import process) or exiting the client (which does not stop the server part and so the import is still going on).
You can even start an impdp process (so a client part) and attach it to a server part which is running and has even not be started by you.

Report message to a moderator

Re: IMPDP in Oracle 11g [message #603216 is a reply to message #601195]

Thu, 12 December 2013 03:32

kalpeshrmopkar
Messages: 10
Registered: November 2013

Junior Member

Thanks all

Report message to a moderator

Previous Topic:	ORA-01436 during export on Oracle 8i
Next Topic:	expdp JAVA_CLASS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 03:24:23 CDT 2025