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

Instead of taking that route, how about the following:

Create a new table, on the source instance, which contains the "data according to some criteria".
Use EXP to export this new table's data. Use IMP to import the .dmp file onto the target server. On the target server "INSERT INTO table (select * from new_table)"; Drop the new table from both instances.

HTH Alan

jlchen wrote in message <8dhl7r$20so$1_at_reader.ccu.edu.tw>...
>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
>
>
>
>
Received on Tue Apr 18 2000 - 00:00:00 CDT