Re: How to use the Unused Column?
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 14:29:09 -0500
"Dropping a column is not a significant event."
It is a pretty significant event, at least in 9i. Full table lock while a
full table scan is performed. I had this happen to me on a 240GB partitioned
table. The whole database completely bogged down. So, after that I just
marked columns as unused. Downside is exports can only be in conventional
mode.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
