Re: commit during alter table drop column
Date: 22 Apr 2002 02:18:16 -0700
Message-ID: <a20d28ee.0204220118.6a51b2b6_at_posting.google.com>
"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
>
> -------------------------------------------------------------------------
>
>
> --
NO
Oracle blocks have no 'holes'in them, so your complete table needs to be rewritten.
Oracle is also not exactly the product to design by means of hacking.
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Mon Apr 22 2002 - 11:18:16 CEST