0

I am using dbms_metadata to extract the objects of a schema and to filter all tables whose names start with either TEMP_ or TMP_:

dbms_metadata.set_filter(exp_h, 'NAME_EXPR', q'[not like 'TEMP_%' ESCAPE '\']', 'TABLE');
dbms_metadata.set_filter(exp_h, 'NAME_EXPR', q'[not like 'TMP_%'  ESCAPE '\']', 'TABLE');

This worked without a problem. However, there is now one TMP_ table, (say TMP_BAR) which must not be excluded. I am not sure how I can extend my script to explicitely include this table to the set of exported objects.

René Nyffenegger
  • 39,402
  • 33
  • 158
  • 293

1 Answers1

0

Try using this -

dbms_metadata.set_filter(exp_h, 'NAME_EXPR', q'[= 'TMP_BAR' OR 'TABLE' NOT like 'TMP_%' ESCAPE '\']', 'TABLE');
Pankaj
  • 2,692
  • 2
  • 6
  • 18