hi All,
I want to kill an existing oracle data pump job, where details are given below, in addition, i am not in export mode:
owner job_name operation job_mode state attached_sessions
scott SYS_EXPORT_TABLE_02 EXPORT TABLE EXECUTING 0
i have oracle
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Another issue i am facing is that when i try to execute an export command then getting following error in log file
*My para file contain*
directory=abc_dir
dumpfile=abc.dmp
logfile=abclog
JOB_NAME=abc_f
exclude=grant, constraint
tables=emp,
dept
*logfile*
;;;
Export: Release 11.2.0.2.0 - Production on Thu May 30 08:13:41 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39097: Data Pump job encountered unexpected error -6502
ORA-39065: unexpected master process exception in DISPATCH
ORA-06502: PL/SQL: numeric or value error
thanks in advance,
Zaid