Re: Q:alter table and rollback problem - urgent

"Ralf Bender" <ralf.bender_at_arcor.de> wrote in message news:40479fdf$0$14823$9b4e6d93_at_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

alter table is DDL, not DML -- could it be that the alter transaction does not affect DDL? (not exactly sure, but might be worth looking into)

;-{ mcs Received on Thu Mar 04 2004 - 15:45:20 CST