Re: intermittent commit on insert ?

Sunil,

Why do you want to copy your data from another table?

"Sunil" <sunil_franklin_at_hotmail.com> wrote in message news:TT4L8.8$DI4.88_at_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 - 14:20:14 CDT