Recent Comments
Monthly Archives: October 2016
Oracle: Partition by List Sub-Partition by Range– Example
The following post will walk you trough an exercise of creating a partitioned table, using the list partitioning, with range sub-partitioning (explicit definition of partitions and sub-partitions naming), populating and testing the partition pruning. Please note I will also post … Continue reading
Working with Large Data Volumes – Partitioning
As more and more the increase in information is getting visible to each database user, there comes a question on how are we to process these volumes in a Data Warehouse environment. One of the first answers provided by Oracle … Continue reading
Posted in DW
Tagged big data, DW, large data sets, Oracle, partition by list, partition by range, partition example, partition pruning, partitioning
Leave a comment
Oracle: Partition by Range– Example
The following post will walk you trough an exercise of creating a partitioned table, using the range partitioning (with auto define of partition names), populating and testing the partition pruning. Please note I will also post the scripts at each section so … Continue reading
Posted in DW
Tagged big data, DW, large data sets, Oracle, partition by range, partition example, partition pruning, partitioning
1 Comment
Oracle: Partition by List – Example
The following post will walk you trough an exercise of creating a partitioned table, using the list partitioning, populating and testing the partition pruning. Please note I will also post the scripts at the end of the post, so you … Continue reading
Posted in DW
Tagged big data, DW, large data sets, Oracle, partition by list, partition example, partition pruning, partitioning
2 Comments
