Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: gary.yu@istark.com (Gary YU)
Newsgroups: comp.databases.oracle.server
Subject: Re: Import/Export a delimited text file?
Date: 4 Apr 2002 06:58:29 -0800
Organization: http://groups.google.com/
Lines: 33
Message-ID: <5483713a.0204040658.57d38bd@posting.google.com>
References: <5483713a.0204030822.3e70c064@posting.google.com>
NNTP-Posting-Host: 66.46.10.226
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1017932309 31840 127.0.0.1 (4 Apr 2002 14:58:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2002 14:58:29 GMT
Xref: easynews comp.databases.oracle.server:142032
X-Received-Date: Thu, 04 Apr 2002 07:56:17 MST (news.easynews.com)

gary.yu@istark.com (Gary YU) wrote in message news:<5483713a.0204030822.3e70c064@posting.google.com>...
> Hi all,
> 
> I'm new to Oracle, I just wondered, is there any tools that can export
> a table into delimited text file, or import a delimited text file from
> other source(excel, Informix...)?
> 
> when I'm using imp/exp, I can't modify the dump file, and I have to
> DROP the table completely before I re-import it.
> 
> any idea will be greatly appreciated.
> 
> Thanks,
> Gary

Thanks guys,

that's all great ideas, and it's true that painful to understand all
the parameter on imp/exp and SQLloader ;(

I have got a solution yesterday on how to export delimited text files,
by using a oracle front-end tool called Toad(free download from the
internet), you can select * from some_table, and save the result in
various format, really cool.  Howard was right, I can also use spool
in sqlplus, only trouble is when I try to export a table wiht 70
collumns, I have to write all the collumn names and '||' in the select
sql statement, and then I found that I can 'desc table_name' and spool
the result to a text file, then use some text editor to "cut" only the
collumn names and make them into the select sql statement -- it's so
fun to find out new solutions.

thanks again!
Gary