2 Replies Latest reply on Apr 1, 2014 6:50 AM by vikramrathour

    Export data from multiple tables




      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.



      Vikram R