Tags » Partitioning
A few months ago I wrote in a blog post that incremental statistics cannot be combined with a small value for estimate_percent. Because this problem is still an issue for one of my customers (who runs a quite big Data Warehouse) I was looking for some additional information about this subject and found an excellent overview in the blog of Randolf Geist: 35 more words
With Basic Compression, you cannot drop a column.
create table t1 (col1 number ,col2 number) compress; table T1 created. alter table t1 drop column col2; SQL Error: ORA-39726: unsupported add/drop column operation on compressed tables 39726. 594 more words