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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 31 Aug 2006 22:57:13 -0700
Message-ID: <1157090231.544732@bubbleator.drizzle.com>

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.
>
>
> Thanks
>
> Pankaj

Impossible to predict.

In the future please use the metric system of measurement.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Sep 01 2006 - 00:57:13 CDT