Re: How to export Oracle data to Non-Oracle db?

Hi,

Try Chyfo (www.ispirer.com/chyfo.html). It can convert Oracle data into a text file (CSV, TAB, fixed length), supports moving LOBs. You can create scripts and schedule running.
Now it generates scripts for SQLLoader (control files) but in future it will generate scripts for Sybase BCP.

Best regards, Dmitry.

"PasirRis" <jackling_at_singnet.com.sg> wrote in message news:97a8b8$r2k$1_at_clematis.singnet.com.sg...
> ver: 8.1.7 Std edition (on Solaris 8)
>
> I'm a newbie in Oracle. And at first glance, it appears to me that there
 are
> limited ways to export data from other databases (like Sybase, SQL server
> etc.)
>
> To import into oracle, SQL*Loader can read some delimited text files and
 put
> to oracle db.
>
> But I fail to find a way readily to export or output data from oracle db
 to
> e.g. Sybase.( In Sybase, there is a utility called bcp which is convenient
> to move(import/export) data across platforms by using Text / ASCII file
> format.)
>
> Question:
> on export -
> - Any way to export/output oracle data into text/ASCII files? or,
> - How can I export/output oracle data to another db platform like Sybase
> etc. in whatever way you can recommend? And we may need to do this export
 on
> regular basis.
> - I saw something called Open Gateway. Does it serve the purpose?
> on import -
> - We need to import data on regular basis and thus want it to be schedule.
> Is SQL*Loader the only means to serve this purpose or any better
 suggestion?
>
> hope can learn from expertise.
> thanks,
> jackling.
>
>
>
Received on Mon Feb 26 2001 - 05:48:53 CST