Tim Gorman has a unload.sql routine on his website at
www.evergreen-database.com written
by Gary Dodge. I've seen other incarnations of this as well. Basically
select all your columns
from all your tables to a spool file. If you roll your own, write dynamic
sql to spool out
select statements by selecting column_name from user_tab_columns to build
your statements...
"George Clark" <george_at_webmd.net> wrote in message
news:3A9D8BF4.8A361676_at_webmd.net...
> Hi All,
>
> I'm trying to export data from a Oracle database in order to load it
> into a non-oracle database.
> To do this I need to have it in a plain ASCII file with something like
> "|" as a column delimiter.
> So far I have not been able to find an easy way to do this like an
> "unload" statement or something.
> I'm not looking forward to writing a special select statement for each
> table in th database in order
> to accomplish this task.
>
> Is there an easy way to do this?
>
> Thanks,
> George
>
Received on Wed Feb 28 2001 - 18:52:42 CST
