Oracle Database Discussions

hi all,

i tried to export data using expdp. i read somewhere that using expdp creates a background process so that even if i turn off my client machine, it won't stop the export.

problem is i need to stop the expdp process. how do i kill it?

when i query the database using

select *
from DBA_DATAPUMP_JOBS;

the jobs are still there with a value of NOT RUNNING in the STATE column. i think the jobs are already done in this case but how do i remove them from the list? also how do i kill a currently running datapump job?

any suggestions?

thanks