Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: commit during alter table drop column
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
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