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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2012

Added on Apr 10 2008

#general-database-discussions

3 comments

54,871 views