I need to export specific tables from a schema in database
Eg: select table_name from dba_tables where owner='ANALYTICS' and table_name like 'W_%'
This query returns around 1500 tables.
How can I take export of these 1500 tables (Passing these 1500 tables one by one is not an easy task)
So need to have some tool, where all these tables are retrieved with a " , " and in one liine
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 -