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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Drop unused Column

Re: Drop unused Column

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Thu, 4 Aug 2005 08:42:57 -0700 (PDT)
Message-ID: <20050804154257.10420.qmail@web52809.mail.yahoo.com>

For tables this large, you could probably use dbms_redef, where you could create a new table w/o the unwanted column, and do the task online.

Thanks,
Deepak



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 04 2005 - 10:45:51 CDT

Original text of this message

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