What is a partitioned view? I googled but could not get a satisfactory result.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Partitioned views are a (very) old technique for partitioning data that are very rarely used today. Oracle added the ability to partition tables back in Oracle 8, which provides much more functionality than partitioned views, at which point partitioned views became obsolete. The only reason to consider using partitioned views would be if you can't afford a license for the partitioning option and you're willing to accept the reduced functionality and extra maintenance required to use partitioned views. The documentation on partitioned views will pretty much all date back to the Oracle 7 days.
In order to use partitioned views, you would define individual tables for each logical partition, create a
Of course, if you use this technique, you have to create a new physical table and rebuild the partitioned view every time you add a new partition which is quite a bit of maintenance. Getting the partitioned view to work correctly and making sure that partition pruning is happening correctly is much, much more challenging than when you're using a partitioned table. Plus you end up with a ton of separate tables with very similar names polluting your namespace.