4 Replies Latest reply: Feb 13, 2013 3:55 PM by Richard Harrison . RSS

    export a long list of tables

    989658
      Hi Guys,

      I want to export a long list of selected tables, i can retrive table names from database dictionary, how can i copy my script in sqlldr instead of typing each table name, there might be any easy option, i might not know, any help would be greatly appretiated?
       exp scott/tiger@pxe file=d:\ar_18_7.dmp tables= (a,b,c,d,e,f,g, .......................................)
      log=d:\poi_release_impexp\ar_poi_18_7.log
      i just do not want to type 100 table names, any alternate where i could paste table names retrieved from tabs.

      Thanks in advance,