Re: Error executing DBMS_DATAPUMP

I tried this and it worked. Is this fine ?

DBMS_DATAPUMP.METADATA_FILTER(jobNo, 'SCHEMA_LIST','''ERLS'', ''ERLS_SCHEMA''', NULL, NULL); thanks
Sunit

Andy Hassall wrote:
> 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
Received on Mon Jan 22 2007 - 14:01:15 CST