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