This discussion is archived
5 Replies Latest reply: Oct 26, 2012 10:00 AM by Srini Chavali-Oracle RSS

Export specif tables

user12868572 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points