Home » RDBMS Server » Server Utilities » IMPDP in Oracle 11g (Oracle 11g)
IMPDP in Oracle 11g [message #601195] Mon, 18 November 2013 06:45 Go to next message
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.
Re: IMPDP in Oracle 11g [message #601196 is a reply to message #601195] Mon, 18 November 2013 06:58 Go to previous messageGo to next message
ThomasG
Messages: 3101
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.
Re: IMPDP in Oracle 11g [message #601251 is a reply to message #601196] Mon, 18 November 2013 22:45 Go to previous messageGo to next message
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?
Re: IMPDP in Oracle 11g [message #601254 is a reply to message #601251] Mon, 18 November 2013 23:04 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
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.
Re: IMPDP in Oracle 11g [message #601260 is a reply to message #601254] Mon, 18 November 2013 23:28 Go to previous messageGo to next message
kalpeshrmopkar
Messages: 10
Registered: November 2013
Junior Member

I have Oracle 11g installed on AIX 6.1
Re: IMPDP in Oracle 11g [message #603206 is a reply to message #601260] Thu, 12 December 2013 03:02 Go to previous messageGo to next message
gazzag
Messages: 332
Registered: November 2010
Location: Bristol, 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?
Re: IMPDP in Oracle 11g [message #603214 is a reply to message #601195] Thu, 12 December 2013 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: IMPDP in Oracle 11g [message #603216 is a reply to message #601195] Thu, 12 December 2013 03:32 Go to previous message
kalpeshrmopkar
Messages: 10
Registered: November 2013
Junior Member

Thanks all
Previous Topic: ORA-01436 during export on Oracle 8i
Next Topic: expdp JAVA_CLASS
Goto Forum:
  


Current Time: Tue Oct 21 15:49:23 CDT 2014

Total time taken to generate the page: 0.13783 seconds