Re: How to convert Oracle tables/views etc to text files

You are probably wanting to import this into some other application that would easily except a *.csv file in order to do this try something like the following:

spool a.lst
SELECT
   '"' || owner || '","' || table_name || '"' FROM
  all_tables;
spool off

Your output would then look something like this: "SYS","V$XATRANS"
etc.......

Ken Hinerman
pgaur_at_cdotd.ernet.in wrote in message <7723pj$gbi$1_at_nnrp1.dejanews.com>...
>Hi , There is a strong need for this aspect here and I don't know how to
>do it. Is there some way to convert the Oracle Table/views etc in Text
files,
>so that these text files can be used by some other program. I am not very
>much familiar with Oracle programming as I am now these days only reading
the
>manual of Oracle, till now I was not able to find any such possibility.
>Thanks in advance !!!!! Praveen Gaur
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 07 1999 - 08:44:09 CST