Re: commit during alter table drop column

This error seems bizaire since you are not altering the data in the table, you are trying to drop a column, no rollback should be generated.

Hmm...

"George D. Benetos" <gbenet_at_intranet.gr> wrote in message news:<aa08u2$nld$1_at_newsserv.intranet.gr>...
> Hello ..
> I'm trying to execute statement
>
> alter table test drop column t1
>
> in a table with a number of rows >5000000
>
> I get an error message concering rollback segment
>
> -------------------------------------------------------------------------
> ----------------
> *
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 4
> ORA-01628: max # extents (330) reached for rollback segment R3 A
>
> -------------------------------------------------------------------------
> ----------------
>
> is there a way to do , ap eriodic commit in the statement above in order
> to terminate the command successfully ????
>
>
> thanx ..................
>
>
>
> --
> -------------------------------------------------------------------------
> --------
>
> George D. Benetos
> Electrical & Computer Engineer N.T.U.A
>
> -------------------------------------------------------------------------
>
>
> --
Received on Mon Apr 22 2002 - 13:21:54 CEST