Re: Exporting Oracle Database into text file

From: Norman Neil <obspg_at_fortress.awinc.com>
Date: 1997/07/04
Message-ID: <01bc877c$00b83d20$3670c2cf@fswcnslt.northwood.ca>#1/1

If you are using Oracle 7.3, you can use the UTL_FILE package. I've used this package to write to a file the same data that I am inserting into a table. I don't know if this is what you are referring to or not. If you want to create a *.dmp file then EXPORT is the key word to search Oracle's documentation.

Hope this helps,

Norm

yoong pan <pan_at_cadesm59.eng.utah.edu> wrote in article <5opctb$1ub$1_at_dorothy.cc.utah.edu>...
> 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
>
>
Received on Fri Jul 04 1997 - 00:00:00 CDT