kill process

Posted on 2014-04-11
Medium Priority
Last Modified: 2014-06-10
If we kill export or import process any of the space get filled up..
if we kill the process and the do the export or import all over it will be ok or not ??
Question by:tonydba
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 672 total points
ID: 39995485
A 'killed' job is gone.

There is no way to 'restart' it.

Now if you are using datapump, you can use STOP_JOB to later restart it.

As we have suggested several times, the online docs are your friend:

If the master table and dump file set are not disturbed when or after the STOP_JOB command is issued, then the job can be attached to and restarted at a later time with the START_JOB command.


A job that is terminated using KILL_JOB cannot be restarted.
LVL 13

Expert Comment

ID: 39995554
In all fairness the question does state "do <it> all over" so it's rather pedantic to say a killed process cannot be restarted. Any given set of steps can be performed again usually. Did this same questioner get rude in another thread?

It depends on what kind of space ran out. If it's just table space of the table being loaded why not just add more? Almost all "space" issues can be resolved by just adding some. If your server is topped out for storage though, isn't that going to be obvious? Do you need to buy more disk capacity?
LVL 13

Expert Comment

ID: 39995571
OK, I hadn't logged in for a few days - now I see all the other questions from this person.  Hey tonydba, it might help if you wrote complete sentences on a more regular basis and clearly explained your various problems.
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 664 total points
ID: 39995686
--->If we kill export or import process any of the space get filled up..

If a process is Killed, space will fill up only to that extent before it is killed,(generally export will not consume any space, here it implies only to import,  once killed as the experts suggested, you cannot restart it in the same way which you have done it once.

If you want to restart it and you want the import to happen in the same way, then you have to use the option with the import


As Tables are the ones which generally consume a considerable amount of space, rest objects even if you restart the import, they will get skipped stating object already exists, which is expected and should be ok.

ie., your impdp command should be like this in case you don't know the progress and want to have a complete restart once again

impdp parfile.par

as per my previous experience in dealing your questions , i assume you have a par file
so parfile would now have an additional line


--->if we kill the process and the do the export or import all over it will be ok or not ??

It will be ok, if you do it in the above way
LVL 15

Assisted Solution

by:Devinder Singh Virdi
Devinder Singh Virdi earned 664 total points
ID: 39996746
If you killed export, the space used by it will remain there and can be reclaimed by removing the file created by export process. If there are lots of error in log file, then log file will also use some amount of space, that can be clean without any risk.
If you kill import process, then space used in Tablespace which may cause extension to data files may or may not be reclaimed easily. you may need to rebuild objects in certain case. Consider this: after you killed import, some other table need more extents, which is allocated to the very end of data file, therefore you may not able to shrink that file even if you remove all extents created by import process although you have big hole in data file.
For second question, you will need some cleanup at OS level and for import may be database level.
LVL 23

Expert Comment

by:Steve Wales
ID: 40124048
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question