EXPDP/IMPDP INCLUDE=TABLES...USING LIKE
rg2Apr 10 2008 — edited Nov 21 2012Hi,
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?