Re: commit during alter table drop column

A "periodic commit" during a table structure change would result in a table that would be in a state of "flux", therefore it's impossible to do it.

Instead of trying to go around the problem, correct the problem:

Your "Next Extent" size for the rollback R3 is too small, or your tablespace fails to extend. There's only 2 places to look for this.

JP

"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:40:09 CEST