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!

EXPDP/IMPDP INCLUDE=TABLES...USING LIKE

rg2Apr 10 2008 — edited Nov 21 2012
Hi,

I am trying to use DP to get only tables that begin with the name SYS_ and LU_. I have tried the below statement, but I get the following error:

Expdp system directory=??? Dumpfile=??? Logfile=??? Job_name=??? schemas=GEMDEV IINCLUDE=TABLE:" LIKE 'SYS_%'"

ORA-39001: invalid argument value
ORA-39071: Value for INCLUDE is badly formed.
ORA-00920: invalid relational operator

Any advice here on how I can achieve my goal?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2012
Added on Apr 10 2008
3 comments
54,870 views