This content has been marked as final. Show 5 replies
Use expdp and a parameter file.
select table_name||',' from dba_tables where owner='ANALYTICS' and table_name like 'W_%'
Oracle provide the utility and documentation with details. Try to spend some time to get the hands on for your requirement.
Provide the version too from next time onwards
- Pavan Kumar N
EXPDP + parfile
For the parfile, look at the INCLUDE parm. Here you can specify each and every table (Obviously not what you want), but you can also plug a query in.
Like this -
expdp osama/osama@orcl schemas=osama include=TABLE:"IN ('test1', 'test2')" directory=TEST dumpfile=1.dmp logfile=1.log