Re: Help Required: How can I export my Oracle data into a flat file

[Quoted] There are a couple of other methods available. First is the export utility. You can export a table from the original database and import it into the target database. Similar to this:

   exp userid=userid/password file=exp.dmp table=table_name    imp userid=userid/password file=exp.dmp full=y

Also, you can use the copy command (see SQL documentation). I can't remember the syntax off-hand but it allows you to copy the entire table or a portion thru the use of a select statement.

Both of these methods are much faster than creating simple flat files. Hope this helps
DawgByte

johng_at_mm.com (TurkBear) wrote:
>
>The easier way is to use a 3rd party tool to export the data :
>I use Crystal Reports 8 from seagate and it exports in comma delimited format
 (
>along with many, many others) which I can use in many other apps (or as
 a data
>file for SqlLoader to use)
>many other report writers will allow exports to a dilimited format, as will
>Access, Excel etc...
>
>
>"Abey Joseph" <abeyj_at_netzero.net> wrote:
>
>>Antony,
>> I am not an expert on this matter... I don't know if there
 is a
>>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
>>fields will be fixed length. If you want delimited fields you would have
 to
>>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
>>>
>>>
>>>
>>
>
>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Mar 16 2000 - 00:00:00 CET