Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to kill EXP process

VIKHARAHMEDJun 29 2011 — edited Jun 29 2011
Dear All,

OS = HP-UX
Oracle database = Oracle 9i ( 9.2.0.8 )

I have set my FULL export in crontab -e to 8pm ysterday, today morning i see that my exp process is still running ( TOP command ). Also, my exp is failed.

When i see exp log file, it shows as below:

. exporting table CO_BRANCH_PROGRAMS 3 rows exported
. . exporting table CO_BRN_PATROLS 11 rows exported
. . exporting table CO_BRN_PATROL_MEMBERS 0 rows exported
. . exporting table CO_BRN_PATROL_SCHEDULES 0 rows exported
. . exporting table CO_BRN_PATROL_SEARCH_AREA 0 rows exported
. . exporting table CO_BRN_SEARCH_AREAS 11 rows exported
. . exporting table CO_BRN_SEARCH_AREA_DETS 0 rows exported
. . exporting table CO_DECRYPT_PRIVS 1 rows exported
. . exporting table CO_HOSTED_BENS 0 rows exported
. . exporting table CO_HOSTED_BENS_X 0 rows exported
. . exporting table CO_HOSTED_BENS_X1 0 rows exported
. . exporting table CO_JUVENILE_ADMT_DATA 1237 rows exported
. . exporting table CO_JUVENILE_SUITS 13558 rows exported

No message at last time of log file. When i go to
#ps -aef|grep exp

I see many process with exp, how do i kill of them bcoz, when i use "bdf" command, it shows more space occupied in percentage. Kindly help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2011
Added on Jun 29 2011
#general-database-discussions
2 comments
1,756 views