Re: Can an IMPORT be stopped/interrupted?

kill -l

1. HUP 14) ALRM 27) MSG 40) bad trap 53) bad trap
2. INT 15) TERM 28) WINCH 41) bad trap 54) bad trap
3. QUIT 16) URG 29) PWR 42) bad trap 55) bad trap
4. ILL 17) STOP 30) USR1 43) bad trap 56) bad trap
5. TRAP 18) TSTP 31) USR2 44) bad trap 57) bad trap
6. ABRT 19) CONT 32) PROF 45) bad trap 58) bad trap
7. EMT 20) CHLD 33) DANGER 46) bad trap 59) CPUFAIL
8. FPE 21) TTIN 34) VTALRM 47) bad trap 60) GRANT
9. KILL 22) TTOU 35) MIGRATE 48) bad trap 61) RETRACT
10. BUS 23) IO 36) PRE 49) bad trap 62) SOUND
11. SEGV 24) XCPU 37) bad trap 50) bad trap 63) SAK
12. SYS 25) XFSZ 38) bad trap 51) bad trap
13. PIPE 26) bad trap 39) bad trap 52) bad trap

try
kill -17 <pid_of_imp_session> -> suspend -> do your stuff
kill -19 <pid_of_imp_session>-> continue

or if you're running the imp in foreground: CTRL+Z (suspend - same as kill -17)
-> do your stuff
fg (foreground) or bg (background)

OR
you could suspend the Oracle serverprocess using oradebug oradebug setospid <pid imp shadow process> oradebug suspend
-> do your stuff
oradebug resume

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7038D9613_at_lnewton.leeds.lfs.co.uk...
> Morning Greg,
>
> I don't know how gracefully you want, but I've had no problems with :
>
> ps -ef|grep -i imp | grep -v grep | grep -i
> <username_doing_import>
>
> followed by
>
> kill -9 <pid_of_imp_session>
>
> After than I run a script to tidy up the carnage in the scheme I was
> importing into, and start the correct import again.
>
>
> Cheers,
> Norman.
>
> PS. Of course, the above is Unix.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
>
> -----Original Message-----
> From: Greg Brady [mailto:anonymous_at_nowhere.net]
> Posted At: Tuesday, April 15, 2003 3:44 AM
> Posted To: server
> Conversation: Can an IMPORT be stopped/interrupted?
> Subject: Can an IMPORT be stopped/interrupted?
>
>
> guys/gals,
>
> Is it possible to interrupt or stop an ongoing IMPORT ("imp") command?
> I want to stop it gracefully if possible.
>
> thanks,
> Greg Brady
>
Received on Tue Apr 15 2003 - 11:58:01 CDT