Dear All,

I've got a big table in Oracle 8i. There are 3 Mio records in a Datafile
with a size of 2GB. Now, i must modify a column in a table.

I create a big rollback segment to set a transaction, but nothing works.
Oracle tells me a ORA-01562 WITHOUT a Segment Number?????

What can i do?

Here my last statements:
22:10:32 archiv1:tsAdress>set transaction use rollback segment rbbroll;

Transaktion wurde gesetzt.

22:10:32 archiv1:tsAdress> alter table tbl_adress1 modify (name char(40));
alter table tbl_adress1 modify (name char(40))
*
FEHLER in Zeile 1:
ORA-01562: Fehler beim Erweitern der Rollback-Segmentnummer .

Why won't Oracle use that temporary rollback segment?

Hope someone can help
Ralf