- Use SQL*Plus to format and spool your query to a flat file.
- Use ODBC to make a connection to Oracle database from MS application
(Access, MSSQL, etc.).
Ram <kramac_at_hotmail.com> wrote in message
news:38DA7BF8.9DE29B8B_at_hotmail.com...
> Hi,
>
> Is there an easy and quick way to export the data from a oracle table
> to text file or another database (like MSSQL). I have to run a job every
>
> day to do this. One of my table is having 3 million records.
>
> Oracle is running on RS6000. if u have sample script, can u please email
>
> that to me .
>
> Thanks and regards
> Ram
>
>
>
Received on Thu Mar 23 2000 - 09:13:33 CST
