5 Replies Latest reply on Oct 26, 2012 5:00 PM by Srini Chavali-Oracle

    Export specif tables

      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