commit during alter table drop column

From: George D. Benetos <gbenet_at_intranet.gr>
Date: Mon, 22 Apr 2002 08:57:18 +0300
Message-ID: <aa08qt$nla$1@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 - 00:57:18 CDT