Oracle Database INTERVAL Partitioning and Virtual Columns

I bumped into this issue recently which prevents you INSERTING a date of 31-12-9999 into an INTERVAL partitioned table due to the fact that the LESS THAN partition value would be larger than an Oracle Date. After speaking with Jeff Moss he mentioned that we might be able to get round the problem by using a virtual

Oracle Database Interval Partition Set Up Script

This script is used to set up the test table for the following blog posts: Oracle Database INTERVAL Partitioning Date Error With 31-12-9999 Oracle Database INTERVAL Partitioning and Virtual Columns [crayon-578913d2a047f830082062/]