Question: How do I use the
name_expr in the dbms_datapump package? I want to use
name_expr to export a list of table names that I generate
dynamically via a data dictionary query.
Answer: In
dbms_datapump, you can use the name_expr in
the dbms_datapump.metadata_filter procedure to feed
a list of table names (generated from an SQL statement).
In this code example, we pre-create a table with a list of
table names in a table_name column in a table named
my_table_names:
dbms_datapump.metadata_filter(
handle=>handle,
name=>'NAME_EXPR',
value=>'IN (select
table_name from my_table_names where table_name like
''CUST%'')'
);
Here we use dbms_datapump with name_expr
to export a list of all table names beginning with CUST
dbms_datapump.metadata_filter (
handle => myhandle,
name => 'NAME_EXPR',
value => 'LIKE ''CUST%''',
object_type => 'TABLE'
);
