Re: drop column; nologging!?

A copy of this was sent to cosmin_ioan_at_msn.com (if that email address didn't require changing) On Sat, 12 Feb 2000 23:02:06 GMT, you wrote:

>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

scott_at_8i> alter table big_table set unused (column_name);

Table altered.

that will flag delete it and be very fast (I'm assuming of course you are using Oracle8.1 which supports the drop column and you aren't talking about exp/imp or create table as select or something like that).

>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Feb 13 2000 - 09:10:47 CST