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

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...b14215/toc.htm


HTH,
Brian

--
================================================== =================

Brian Peasland
dba@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

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...b14215/toc.htm
>
>
> HTH,
> Brian
>
> --
> ================================================== =================
>
> Brian Peasland
> dba@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

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...b14215/toc.htm
> >
> >
> > HTH,
> > Brian
> >
> > --
> > ================================================== =================
> >
> > Brian Peasland
> > dba@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
==================

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...b14215/toc.htm
>>
>>
>> HTH,
>> Brian
>>
>> --
>> ================================================== =================
>>
>> Brian Peasland
>> dba@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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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

The answer is....it depends. It depends on too many factors. How many
indexes are on the table? Do any foreign key constraints need to be
verified? Are there any triggers on the table? How fast is your disk
I/O? Will this be done during prime time or during off hours? There are
too many factors at play here...

I would venture to say that 200,000 records will not take that long to
ingest with SQL*Loader. But as they say, your mileage may vary. The only
way for you to know for sure, is to run SQL*Loader on our records and
test it out for yourself.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba@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

Pankaj_Jha wrote:

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

Of course it depends, as everyone says. For my 9206 system with
a table that has 6 character and 24 quantity or dollar columns:

307285 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 255936 bytes(31 rows)
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 307285
Total logical records rejected: 0
Total logical records discarded: 0

Run began on Thu Aug 03 15:33:05 2006
Run ended on Thu Aug 03 15:33:55 2006

Elapsed time was: 00:00:49.84
CPU time was: 00:00:09.42

Really, it's simple enough to just try it! Try external tables while
you are at it.

jg
--
@home.com is bogus.
http://www.pseudodictionary.com/word.php?randomizer=on