Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export with expdp tables with name like 'name1%' or like 'name2%'

478354Oct 6 2006 — edited Oct 9 2006
How 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2006
Added on Oct 6 2006
2 comments
1,067 views