Re: Metadata_filter
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 Jan 2011 14:29:49 -0600 (CST)
Hey Scott,
> h1 := DBMS_DATAPUMP.OPEN(operation => 'EXPORT', job_mode => 'TABLE', NULL,
> 'Scott table export','LATEST');
...
> -- A metadata filter is used to specify the schema that will be exported.
> DBMS_DATAPUMP.METADATA_FILTER(handle => h1, name => 'NAME_EXPR IN
> (''EMP'')');
>
> If I want to export a single table from a user how do I write the
> metadata_filter line?
The API for datapump should be much easier to use than it is, IMHO. In any
case...
Having done this, I believe you need to change your OPEN from a JOB_MODE of
'TABLE' to 'SCHEMA'. Once that's done, you can add your schema filter:
dbms_datapump.metadata_filter (
handle => handle,
name => 'SCHEMA_EXPR',
value => 'IN (''SCOTT'')'
);
Then you add your table filter:
dbms_datapump.metadata_filter (
handle => handle,
name => 'NAME_EXPR',
value => 'IN (''EMP'')',
object_type => 'TABLE'
);
This should get you started at least. The rest should be Googleable. As
always, TEST TEST TEST!!!!!!!
GL!
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
