Re: drop column; nologging!?

One of the options on the drop a column command is a commit size.

    CHECKPOINT INTEGER Be warned however that using this
option can results in lots of commits
taking place very rapidly, leading to
other long-running processes getting
ORA-01555. NB This probably won't reclaim any space for you either until you rebuild the table.

The best strategy is probably

    alter table set unused column XXX;

alter table move nologging;

This gets rid of the column without generating redo, and repacks the table. The downside is that you have to rebuild all the indexes (and you will probably want to take a new backup of the tablespace since there is no log of the table for recovery).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

cosmin_ioan_at_msn.com wrote in message <884opd$nrs$1_at_nnrp1.deja.com>...
>hello all,
>
>I'm trying to drop a column from a v. large table and it's creating a
>way too large rollback activity/file; is there any way to specify
>nologging on such operation or is my best bet reloading the table!?
>
>thanks,
>
>Cosmin
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Feb 13 2000 - 02:49:27 CST