Oracle: How to kill data pump jobs

When you import or export using data pump impdp or expdp tools, the import/export is done by a job. You have an option to provide a job name using JOB_NAME parameter too

Following sql will give you the list of data pump jobs

select * from dba_datapump_jobs

If you want to kill your impdp or expdp

1) Make sure that your impdp/expdp command prompt window is active
2) Press Control-C , It will pause the job. Done press another Control-C or close the command prompt. This will just close the window, but the job will still be running
3) Type Kill_Job
ex: Import>kill_job
Are you sure you wish to stop this job (y/n): y


If by mistake, you closed the window and your import/export job is still running,

1) Get the name of the job using
select * from dba_datapump_jobs
2) Open a new command prompt window. If you want to kill your import job type
impdp username/password@database attach=name_of_the_job
3) Once you are attached to job, Type Kill_Job
ex: Import>kill_job
Are you sure you wish to stop this job (y/n): y

And your job is killed, it will no longer show in dba_datapump_jobs

Force 64bit IIS to run in 32 bit mode

When you want to run 32 bit web applications on a 64bit Windows box, you need to enable IIS to run in 32 bit mode.

By default IIS is set to run in 64 bit.

To check if 32 bit support is enabled, go to command prompt on the IIS box and type the following command

cscript C:\Inetpub\AdminScripts\adsutil.vbs get W3SVC/AppPools/Enable32bitAppOnWin64

Change the path of adsutil.vbs according to your setup

The script will output either True (1) or FALSE(0)

To enable 32 bit support, go to command promtp again and run the following

cscript c:\Inetpub\AdminScripts\adsutil.vbs set W3SVC/AppPools/Enable32bitAppOnWin64

Now that you enabled 32 bit support, you will no longer see ASP.NET tab on your Web application, properties on Internet service manager

To fix that, jus run aspnet_regiis, from command prompt


C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe /i

Bipasha