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