Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: import text files

Re: import text files

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 04 Feb 2005 10:42:23 +0100
Message-ID: <cng601ppo31m6dah9btops0cv39b9boi7o@4ax.com>


On Fri, 04 Feb 2005 08:02:17 GMT, "pradeep via OracleMonster.com" <forum_at_OracleMonster.com> wrote:

>you suggested us to use SQL loader.We dont know how to use sql loader and where should we type the commands.we tried using load command at the sql prompt but we had an error (invalid sql statement)
>can u please suggest how to use SQL loader.
+

The basic idea is you have a controlfile, describing your table the generic syntax is (executable names may be platform dependent) sqlldr <username/password>@service control=<your control file> data=<your data file> log=<any filename> bad=<any filename for rejected records>

Sqlloader is documented in the Oracle Server Utilities Manual.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Feb 04 2005 - 03:42:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US