Friday, May 8, 2009

Virtual Column Based PartitioningAs the name suggest oracle allows us to define partitions based on a virtual column of a table. All types of partitioning methods are allowed for virtual columns. The only thing that is not allowed is if the virtual column uses a PL\SQL function in its definition.

SQL> !oerr ora 5402154021, 0000, "Cannot use PL/SQL expressions in partitioning or subpartitioning columns"// *Cause: Attempted to partition a table on a virtual column that contained// PL/SQL expressions.// *Action: This is not supported.