Re: Copying lakhs of Records in a table of 25 columns from text file or Excel Sheet.

Pankaj_Jha wrote:

> Brian Peasland wrote:
>
> > Pankaj_Jha wrote:
> > > Hello world,
> > >
> > > can some one tell me how to Copy lakhs of Records in a table of 25
> > > columns from text file or Excel Sheet in one go.
> > >
> > > Pls. provide an example
> > >
> > >
> > > Thanks
> > >
> > > Pankaj
> > >
> >
> > With Excel, you can save the data as a comma-separated values format
> > (CSV). Once in CSV format, you can use SQL*Loader or External Tables to
> > load the data into an Oracle table. There are many options at play, so
> > your specific environment and requirements may dictate which options you
> > use. Please read the Oracle Utilities guide paying attention to the
> > chapters on SQL*Loader and External Tables:
> >
> > http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
> >
> >
> > HTH,
> > Brian
> >
> > --
> > ===================================================================
> >
> > Brian Peasland
> > dba_at_nospam.peasland.net
> > http://www.peasland.net
> >
> > Remove the "nospam." from the email address to email me.
> >
> >
> > "I can give it to you cheap, quick, and good.
> > Now pick two out of the three" - Unknown
>
>
> =============================================================
>
> Hello Brian
>
> Can You tell me how much time the SQL Loder take to copy 2 lakhs
> records from text file
>
> to an Oracle 10g Table of 20 Coloumns.
> Plz. give an example.
>
> Thanks
>
> Pankaj