Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: commit during alter table drop column

Re: commit during alter table drop column

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Apr 2002 08:36:24 +0100
Message-ID: <1019461219.12836.0.nnrp-08.9e984b29@news.demon.co.uk>

Read the manual pages for "alter table". You will find

    alter table XXX drop column YYY checkpoint NNN;

--

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

George D. Benetos wrote in message ...
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 ???? Received on Mon Apr 22 2002 - 02:36:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US