Re: Drop unused Column

  • From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
  • To: Dennis Williams <oracledba.williams@xxxxxxxxx>, ken.payton@xxxxxxxxxxxxxxxxxx
  • Date: Thu, 4 Aug 2005 08:42:57 -0700 (PDT)

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 
--
//www.freelists.org/webpage/oracle-l

Other related posts: