intermittent commit on insert ?

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Tue, 4 Jun 2002 20:43:40 +0530
Message-ID: <TT4L8.8$DI4.88@news.oracle.com>

I need to insert into a table T1, data from two views V1 or V2. The name of the view will be passed in as a parameter to my procedure( l_view) . Also Each user has a limit on the number of records he can insert (say l_limit ) . This is also passed into the procedure.

I Have been thinking about dynamic sql on the lines of (

'insert into T1 select * from ' || l_view || ' where rownum < ' || l_limit ) as row by row processing will be slow.

But I am afraid of hitting the rollback segment limit. So I would like to commit when ever 'n' records are inserted ( again this can be passed as a parameter ) .

Is this possible, somehow?

Regards,
Sunil. Received on Tue Jun 04 2002 - 10:13:40 CDT