Re: commit during alter table drop column

Hello,
during a DDl Statement, there is no chance. But

1. Make a copy of your Table with new name
2. Drop ald table, create Table (old name) with other structure
3. Append from old table. If there is a problem with your rollback segment

good luck, Tom

"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 - 12:48:37 CEST