This content has been marked as final. Show 2 replies
I am using the Data Export utility in SQL Developer 4.0.1. There is an option to choose a list of tables that I want to include, however in my case I can get the list of tables by running a query against USER_TABLES and applying some NOT LIKE filters. How do i pass this list to the export utility.
Is there a way to do this.
SELECT table_name from user_tables WHERE NOT (table_name LIKE 'DOD%' OR table_name LIKE 'DAY%' OR table_name LIKE '%_HIST');
Whatever is the result I get is the list of tables I need to export.