Re: How to export data in Oracle to text format?

Hi Chen:

Write a sql like the following and spool it to file.txt: set head off pages 0;
spool test.txt;
select col1||','||col2||',' from your_table where with_your_criteria; spool off;

Ps. the above out file is a example is of "," delemiter file.

I think the easiest way is to use the dblink. This will change your requirement.

Good luck

Zosen

In article <8dhl7r$20so$1_at_reader.ccu.edu.tw>,   "jlchen" <views_at_mis.ccu.edu.tw> wrote:
> Hi,
> I need to export data according to some criteria from one Oracle
 server
> to another.
> For some reason , the two Oracle server can only communicate by
 files
> with text format.
> How to export data in Oracle server to text file and import it
 into
> another Oracle server?
>
> CHEN, JR-LU
>
>

--
Zosen Wang (wangz_at_rocketmail.com)


Sent via Deja.com http://www.deja.com/
Before you buy.