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