Re: Exporting Oracle Database into text file

From: Bob Eisner <boei_at_trifox.com>
Date: 1997/06/26
Message-ID: <33B30A17.7173@trifox.com>#1/1

yoong pan wrote:
>
> Is there a way to export oracle database into a delimited text file?
>
> Also, is there a way to import oracle database into ms-SQL server?
>
> Thanks.
>
> --
> ---------------------------------
> | Eric Y. Pan (~{EKHYG?~} )
> | http://www.mech.utah.edu/~pan

Hi Eric,

You may want to take a look a TRIMreport from Trifox. It's runs with VORTEXchannel which talks to mulitple RDBMS. It contains a Data Migrator which will allow you to unload tables from an Oracle database and load them into a MS SQL Server database or flat files.

TRIMreport (GUI and character based) is an interactive screen painted report generator for simple and complex reports. The TRIMreport facility allows developers to lay out all reports on a screen. TRIMreport works with TRIMpl to allow predefined procedures to be used at many different stages of the report. The end-user also can develop user-defined procedures that are accessible to all other procedures in the report. TRIMapp is callable from TRIMreport. TRIMreport has interfaces to all output devices and supports color output.

Please have a look at http://www.trifox.com/j/trim/index.html for details

Regards,

Bob Eisner
408 369-2392 Received on Thu Jun 26 1997 - 00:00:00 CDT