Fail to extend rollback segment ?
From: WANG SHIANG HUEY <wshiang_at_a.cs.okstate.edu>
Date: 1996/10/17
Message-ID: <546c6s$f71_at_news.cis.okstate.edu>#1/1
Date: 1996/10/17
Message-ID: <546c6s$f71_at_news.cis.okstate.edu>#1/1
Hi,
when I insert 200,000 records into a table from a query, I encounter
the following errors.
I have added a datafile size 20M (total is 35M)
and increase the initial to 1M and next to 500K on ROLLBACK_DATA
tablespace, but it didn't solve the
problem. The number of extents is limited by db_block_size, so max
I can have is 121. I may be thinking in a wrong direction.
Please advise, thanks !
--
Shiang-Huey Wang
Leather Center, Inc.
sherry_at_leathercenter.com
wshiang_at_a.cs.okstate.edu
Received on Thu Oct 17 1996 - 00:00:00 CEST