two exports

Which command will help we to know that there are two imports  going on..?
tonydbaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Gerwin Jansen, EE MVEConnect With a Mentor Topic Advisor Commented:
How did you start the imports? When started from Unix/Linux just use a 'ps' command to find the processes, like this:

ps -ef | grep imp

Look for lines that have the imp command with parameters you would regocnize. If you see more than one (of the same) then you have more than one running.

If it's about datapump, then:

ps -ef | grep impdp
0
 
slightwv (䄆 Netminder) Commented:
Check the online docs and the DBA_DATAPUMP_JOBS view.

http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_3144.htm#REFRN23338
0
 
slightwv (䄆 Netminder) Commented:
>>ps -ef | grep impdp

I believe the datapump jobs run internal to the database.  The problem here is you can kill the impdp OS process and the internal job is still running so it won't show up in the process list.

I don't have any Unix around to test this.  Just going from memory.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Gerwin Jansen, EE MVETopic Advisor Commented:
@slightwv - I have little experience with impdp and I started impdp from a Unix prompt last time I used it.
0
 
slightwv (䄆 Netminder) Commented:
But if you ctrl-c the impdp from the command prompt, does that actually kill the import database job?  Not sure if it remains in the OS process list or not.

I know after a ctrl-c you can reattach to the running job by running impdp.
0
 
Steve WalesSenior Database AdministratorCommented:
I've requested that this question be closed as follows:

Accepted answer: 250 points for slightwv's comment #a39995487
Assisted answer: 250 points for Gerwin Jansen's comment #a39996010

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
slightwv (䄆 Netminder) Commented:
tonydba is under suspension due to multiple accounts and has been directed to come back and close ALL his open questions across ALL accounts properly.
0
 
tonydbaAuthor Commented:
Yes, this helped

applied with ps -ef..

Thank you.
0
All Courses

From novice to tech pro — start learning today.