This content has been marked as final. Show 4 replies
There are loads of tools to choose from. Personally I always use datapump. As an example of how you can generate a table list dynamically for an export here's an example.
include=TABLE:"IN (SELECT table_name from dba_tables where owner='ENDURF_ENV01' and temporary='Y')"
This includes all tables that match the criteria -the SQL can be pretty much anything you like.