Re: rollback segment too small

From: Ong Chin Hui <chong_at_hq.psa.com.sg>
Date: Sat, 13 Jun 1998 08:57:32 GMT
Message-ID: <35823eee.287898209@butler.psa>

On Sat, 13 Jun 1998 05:40:38 GMT, "rok" <rok_at_MCI2000.com> wrote:

Thanks for responding

1. Forget to mention one thing. I perform a commit after every update/insert in the select.

ie.

	main()
	{
 		select * from TABLE_A where processed_i = 0
 		
 		// process the records
 
 		for each record
 		{
 			// processing of record

			start transaction
	 			update/insert TABLE_B
 
 				// update record as processed
 
 				if no error
 				  update TABLE_A set processed_i = 1  
			commit transaction
 		}
	}


2.	Can my table use more than 1 data file ? Then this should not

be a problem.

>1. You commit every few thousand rows or whatever batch size your rollback
>segment can handle.
>2. I hope you know that you can have more than one data file for each
>tablespace. And there is no limit on number of datafiles for a tablespace,
>I believe. Each datafile can be upto 2GB. So each time you run out of space
>you can add one more datafile of 2GB. So you should not have any problems.
>
>raghuvir
>
  Received on Sat Jun 13 1998 - 03:57:32 CDT