Re: Commit for insert into table .... select ....

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 12 Dec 1999 18:55:00 +0800
Message-ID: <38537F04.583E@yahoo.com>

Thomas Kyte wrote:
>
> A copy of this was sent to yewpc_at_rnd.celcom.com.my
> (if that email address didn't require changing)
> On Fri, 10 Dec 1999 00:54:17 GMT, you wrote:
>
> >Hi,
> >Can anyone tell me can if it is possible to have
> >insert into table_a select * from table_b statement to include a commit
> >at certain internal ?
> >
> >As for import we can set commit=y how about insert ... select ?
> >if it is possible than how ? else I may need a stored procedure to
> >control the number of records to be committed this is what i not plan
> >to do.
> >Please let me know if you have any suggestions.
> >Thank you
>
> if you are using SQLPlus -- see the SQLPlus copy command -- it can do this for
> you....
>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation

Possibly also look at INSERT /*+ APPEND */ if the reason you wanted to commit was to avoid running out of rollback segment space..

Cheers
Connor
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Dec 12 1999 - 04:55:00 CST