Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

two exports

Which command will help we to know that there are two imports  going on..?
0
tonydba
Asked:
tonydba
1 Solution
 
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
 
Gerwin Jansen, EE MVETopic 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:
>>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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now