data unload using shell

Shell Programming and Scripting
1

hi,
I work on oracel 10g unix system.

I need to unload data from few tables to a unl file using shell script. I've a file which contains the list of tables. The shell has to refer to this list and create a unl for each table.

Table_list.txt

table1|
table2|
table3|

has to create three unl's

I've worked on Informix db, its quite simple there, just UNLOAD TO would do. But i cudnt get the equivalent one in Oracle.

Thanks!

2

Dvah, this site is to help with unix related issues/questions.

If you have a question on Oracle table unload, you better off post your question on an Oracle forum.

After you find out your unload question, here is a generic shell that could work for you:

#!/bin/ksh
IFS='|'
while read mTabName
do
  echo "Now unloading <${mTabName}>"
  <<< your unloading statements here >>>
done < table_list.txt