Re: ODL in Oracle

In article <Cn3vMD.Dxo_at_cix.compulink.co.uk> asc_at_cix.compulink.co.uk ("Tony Scott") writes:
>
> (SCHALLER Gerard) wrote:
> > Subject: ODL in Oracle
> >
> > I have a basic problem. I am trying to import ascii datas in a Oracle
> > table.
> > I found in my user guide the command ODL (Oracle Data Loader) which
 seems
> > appropriate for this purpose. Unfortunately, when I am in SQLplus with
 the
> > prompt
> > SQL this command is not recognized and furthermore doesn't appear in the
> > Help.

ODL was replaced by SQL*Loader a *long* time ago. Both programs (odl and sqlload) are invoked from the command-line of your operating system. They have nothing to do with SQL*Plus.

> > Can you help me? Could it be due to the fact that I am using the demo
> > account
> > "scott"?

The SCOTT account is a fine account indeed and useful for many things. If you can use it in SQL*Plus, it will work with any other tool also.

>
>
> Which Oracle version and what is the exact manual and page? Is it the
> ORACLE RDBMS Utilities User Guide, for instance?

ODL is documented in the v5 documentation set (utilities manual). Use SQL*Loader instead.

>
> Tony Scott
> (asc_at_cix.compulink.co.uk)

--

Magnus Lonnroth
Tech.Sales & Consultant
Oracle Sweden
Mail: mloennro_at_se.oracle.com