Tag: partitioning

ORA-14758: Last partition … cannot be dropped

As a DBA, its awesome when you have the Partitioning option at your disposal.  So many cool things suddenly become either possible or easier.  For example, all of a sudden you can separate the data of different time ranges into different partitions. But hand…

Compressed partitions are not compressed tables

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then you read about using compression to make your older, static data faster and smaller and you thought … “Cool!” Let’s see that in action…

can you lock part of a table ?

I should stress that this is all well covered in the documentation, but it was something I stumbled upon just recently. Its common knowledge that you can lock a table: SQL> create table T 2 ( x int ) 3 partition by range (…

Its not about the outage

My Oracle Support had a fairly lengthy outage today right in the middle of the Australian business day. But I’m not going to blog about that.  One thing I’ve learnt from many client sites is that people will understand and forgive things like outages,…