I’ve often found that while I’m investigating one Oracle feature I get waylaid by noticing anomalies in other parts of the code. I was caught by one of these events a little while ago while experimenting with the new (22.214.171.124) Inmemory Columnar Store. 1,978 more words
Tags » Partitioning
Continuing on with my Partitioning post series, this is part 6.
The partitioning includes several major components of work (and can be linked below); 1,368 more words
Oracle partitioned tables offer a variety of options to actually specify where to store the data, that is, the table-, index- and lob-partition-segments. However, iff you want to keep things simple and generic, you may leave all this tablespace spec stuff alone, just relying on the fact that the schema/user default tablespace will always also serve as the default tablespace for generated (interval partitioning) or added (range partitioning) or whatever partitions. 1,436 more words