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: Copying lakhs of Records in a table of 25 columns from text file or Excel Sheet.

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

From: Pankaj_Jha <pankajjha1979_at_gmail.com>
Date: 31 Aug 2006 21:59:42 -0700
Message-ID: <1157086782.532582.110480@m79g2000cwm.googlegroups.com>

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.

Thanks

Pankaj Received on Thu Aug 31 2006 - 23:59:42 CDT

Original text of this message

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