Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Extracting Data From Oracle
I use a report writer ( Crystal Reports) which allows me to export the data in the report in a variety of formats ( CSV, Record, etc) . Otherwise it would involve writing sql statements that spool to a file and using that file to import ( the sql is tedious to write, so I haven't used that method for years )... Many other report writers offer this ability.
John.Greco_at_dot.state.mn.us
Charles D DeVries <cdevries_at_link.com> wrote:
>Maybee this is a RTFM but I sure can't find it. We have recently
>migrated an application from a Sybase database to an Oracle database for
>the maintenance tool. Due to several requirements for the data we still
>have the need to extract the data from Oracle and reimport it into
>Sybase on a nightly basis. I have yet to be able to figure out how to
>get data out of Oracle in a CSV type format for reimport.
>
> Is this an actual Oracle decision? You can import whatever you want
>but once it is in it is ours??
>
> If there is no Oracle way to do this does anyone know of any 3rd party
>tools??
>
> Please reply to my regular address as well as the news server.
>
> Thanks in advance.
>
> Chuck DeVries
> mailto:cdevries_at_link.com
Received on Mon Jun 16 1997 - 00:00:00 CDT