| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Error executing DBMS_DATAPUMP
Got the ADD_FILE to work. It seems I need to specify all args as in:
DBMS_DATAPUMP.ADD_FILE(jobNo,'SIEMENSSITE.dmp','EXPSUNIT', NULL, DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE); Now this part fails. I'm trying to use SCHEMA_LIST
DBMS_DATAPUMP.METADATA_FILTER(jobNo, 'SCHEMA_LIST','SJSITE,
SJSITE_SCHEMA');
thanks
Sunit
MTNorman wrote:
> sjoshi wrote:
> > Any hints are appreciated. Also how do I find out the job number of an
> > already submitted job since if I execute the script again it tells that
> > job already exists. I would like to stop that job using
> > DBMS_DATAPUMP.Stop
>
> DBA_DATAPUMP_JOBS lists all active jobs. You can attach to the job and
> stop it using dbms_datapump package.
Received on Mon Jan 22 2007 - 13:13:53 CST
 |
 |