RE: slow insert

-Original Message- Sent: Saturday, February 22, 2003 7:54 AM To: Multiple recipients of list ORACLE-L You can read more abt it in PL/SQL User's Guide and Reference - Chapter 4 - Collections and Records ! anyway, below is the simple code to copy data from emp table. note that, after u

RE: slow insert

I tried this way and infact bulk collect took about 1 minutes more than my current case? Any thoughts thanks -Original Message- Sent: Saturday, February 22, 2003 7:54 AM To: Multiple recipients of list ORACLE-L You can read more abt it in PL/SQL User's Guide and Reference -

RE: slow insert

: Sent by: Subject: RE: slow insert [EMAIL PROTECTED

RE: slow insert

PROTECTED] obile.com cc: Sent by: Subject: RE: slow insert [EMAIL PROTECTED

RE: slow insert

You can read more abt it in PL/SQL User's Guide and Reference - Chapter 4 - Collections and Records ! anyway, below is the simple code to copy data from emp table. note that, after u fetch from the cursor, u have to check for the notfound condition at the end. say, the emp table has 15 rows and u

slow insert

hi, I have an insert statement that will insert about 40 records into a table having 43million records.The values for the insert statement are from a select statement that has a join.This query take about 5-10minutes.What are the ways in which we can speed up this process.the statement

RE: slow insert

if u r having oracle 8.1.7 EE or higher, try using bulk inserts ! that surely will speed up ! and of course, u surely might have thought of APPEND hint dropping/disabling indexes etc. -Original Message- Ravindra Sent: Friday, February 21, 2003 3:08 PM To: Multiple recipients of list

RE: slow insert

Yes I am usng 8.1.7 EE.How do I use bulk inserts..Any docs or links on metalink plss? -Original Message- Sent: Friday, February 21, 2003 3:34 PM To: Multiple recipients of list ORACLE-L if u r having oracle 8.1.7 EE or higher, try using bulk inserts ! that surely will speed up ! and