export with expdp tables with name like 'name1%' or like 'name2%'
478354Oct 6 2006 — edited Oct 9 2006How can I export data and metadata only from tables with name like 'name1%' or like 'name2%'
what value must have INCLUDE parameter ?
from one match it is
INCLUDE=TABLE:"LIKE 'REF%' "
this exports tables witch name begins with REF, but I need tables REF and REF1
if I write like this:
INCLUDE=TABLE:"LIKE 'REF%' ",TABLE:"LIKE 'REF1%' "
or
INCLUDE=TABLE:"LIKE 'REF%' "
INCLUDE=TABLE:"LIKE 'REF1%' "
it says that
Total estimation using BLOCKS method: 0 KB
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
I supose such constructions work like between them is logical AND.
I need an OR construction.