Q:alter table and rollback problem

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Thu, 04 Mar 2004 22:30:06 +0100
Message-ID: <40479fdf$0$14823$9b4e6d93@newsread4.arcor-online.net>

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 Received on Thu Mar 04 2004 - 15:30:06 CST

Q:alter table and rollback problem - urgent