Rollback segments

From: <cristgar_at_my-deja.com>
Date: Mon, 28 Jun 1999 17:03:57 GMT
Message-ID: <7l89tl$m8c$1@nnrp1.deja.com>

Hello!
I'm trying oracle 8 on linux in order to purchase it if it meets our requirements.
To test it i've done a pl/sql procedure which inserts a variable number of rows on two tables. When I inserted 1000 rows all was ok, when I inserted 100000 rows the dbms returned a 1600 condition (cannot extend rollback segments). I think this behavior is correct but... when I cleared the tables and tried to insert 1000 rows again it shows the error again.
In that procedure there was no commit statement (probably that's a problem with rollback segments) however, why Oracle can't insert a number of rows which previosly could.

Thank you
Cristóbal

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 12:03:57 CDT