This one turned out to be a an interesting bug the other day… I did a simple select from DBA_TAB_PARTITIONS and noticed that some tablespace_names were of the form “_$deleted$n$m” where n and m are numbers. Slightly worrying, but at least the data was all present and correct, when I checked. I knew the DBA [...]
Archive of posts tagged partitioning
No pruning for MIN/MAX of partition key column
Recently, I wanted to work out the maximum value of a column on a partitioned table. The column I wanted the maximum value for, happened to be the (single and only) partition key column. The table in question was range partitioned on this single key column, into monthly partitions for 2009, with data in all [...]
Partition exchange loading and ORA-14097
Continuing the theme of this post by Howard, I came across a scenario today which was resulting in this error: ORA-14097 – column type or size mismatch in ALTER TABLE EXCHANGE PARTITION I ran my checker script to try and identify exactly what the mismatch was but it came back with nothing. My script, whilst [...]
Changing the subpartition template and pre-existing partitions
My colleague Tank could not insert some records into a subpartitioned table the other day as he kept getting an ORA-14400 error and couldn’t work out why – nor could I straight away until he mentioned the possibility that the subpartition template had changed on the table…which it had. Lets try and work through the [...]