Re: Loading data into a table from the file

In article <2upj9p$duc_at_hopscotch.ksr.com>, giroti_at_ksr.com (Sudhir Giroti) writes:
> Use the import command. [also see export].
>
> Semyon Basin (sb63_at_namaste.cc.columbia.edu) wrote:
> : I have a newbie question.
> : Since I do not know where the FAQ is, could you please help me.
> : How do I load data into a table directly from a disk file?
> : I know a little bit of INGRES and they have something like this:
> : COPY table FROM 'disk_file';
> : Thanx in advance.
>

Actually, the IMP (import) utility is only for loading data that was exported using EXP.

If you want to load a text file into ORACLE, use SQL*Loader. It is documented in the ORACLE7 Server Utilities User's Guide.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285