stop impdp job works too slow
Hello. I started to import job. but I realized that my database is in archivelog mode. I want to change "no archivelog" and I am trying to stop import job. but I run sql command, I still wait about 30 minutes. What should I do to stop import job immediately? can I kill from operating system? ps -ef|grep imp kill -9 importID ??
DECLARE
2 h1 NUMBER;
3 BEGIN
4 h1:=DBMS_DATAPUMP.ATTACH('SYS_IMPORT_FULL_01','SYSTEM');
5 DBMS_DATAPUMP.STOP_JOB(h1,1,0);
6 END;
7 /
2