Re: Error executing DBMS_DATAPUMP

On 22 Jan 2007 11:13:53 -0800, "sjoshi" <sjoshi_at_ingr.com> wrote:

>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');
 The filter parameters need to be valid SQL expressions, so something like:

DBMS_DATAPUMP.METADATA_FILTER(jobNo, 'SCHEMA_LIST',

   'IN (''SJSITE'', ''SJSITE_SCHEMA'')');

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool