Home » Developer & Programmer » Precompilers, OCI & OCCI » Slow insertion in oracle table
Slow insertion in oracle table [message #94241] Thu, 03 June 2004 01:59 Go to next message
Avijit sen
Messages: 1
Registered: June 2004
Junior Member
i have to insert around 500000 data in a temporary table by selecting the data from another table.Temporary table does not have any primary key,index as it is not required for the same.My problem is that datas are inserted into the teporary table but at very slow rate.It takes around 15 minutes. Can anybody tell me how shall i make it faster so that i can insert the data in the temporary table with in 1 or 2 minutes?

Report message to a moderator

Re: Slow insertion in oracle table [message #94266 is a reply to message #94241] Wed, 23 June 2004 10:40 Go to previous message
sql gurus
Messages: 22
Registered: May 2002
Junior Member
instead of inserting create a table.

ex. create temp_table as (select * from your_table where your_condition)

Report message to a moderator

Previous Topic: Help for running and compile a Pro * C program
Next Topic: OCCI getString problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 01:44:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.