Re: Import/Export a delimited text file?

From: Kai-Joachim Kamrath <kaikamrath_at_nowhere.com>
Date: Wed, 03 Apr 2002 17:42:32 GMT
Message-ID: <caHq8.215765$q2.18617@sccrnsc01>

> 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...)?

Oracle's SQL*Loader is a very fast and flexible tool to *import* text files. It's one-way, though: IN-only. Also, the user interface (if you can even call it that) is not what you'd hope for. Strictly command-line which those of us who have grown up with GUIs find painfully archaic.

> 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.

You don't have to DROP a table when using IMP to import... you can allow IMP to truncate the table. Again, you'll need to read up on all the command-line switches. Received on Wed Apr 03 2002 - 11:42:32 CST