Re: Help Required: How can I export my Oracle data into a flat file
Date: Thu, 16 Mar 2000 16:31:18 -0500
Message-ID: <8ark45$qpc$1_at_slb1.atl.mindspring.net>
Antony,
[Quoted] I am not an expert on this matter... I don't know if there is a [Quoted] better/more efficient way to accomplish the same.
SPOOL filename
SELECT * FROM table;
The above statement would write all columns in all records to filename. The [Quoted] fields will be fixed length. If you want delimited fields you would have to [Quoted] write the SQL statement and concatenate the delimiter and columns. I hope there's an easier way...
Abey Joseph.
"PSINet News Service" <Antony.Amalraj_at_tpg.com> wrote in message
news:7E8A4.416$iB5.781_at_client...
> Hello All,
>
> I am new to oracle, I want to export the table data(From
oracle)
> alone into flat file.From the flat file I want to import the data into
> another database(db2) table.
>
> Can any one help me.
>
> Regards
> Antony
>
>
>
Received on Thu Mar 16 2000 - 22:31:18 CET