Yeah, this partition simulation is very chip and works fine, but don't forget that it is not supported by Oracle any more and brings an overhead when DML operations are extensively used on the table.
Thanks, -- Alisher Yuldashev Senior Oracle DBA www.pythian.com
In light of dishing out a ton of $$$ for the partitioning option, there are known ways to simulate partitioning through the use of check constraints + views + a little custom coding.Chris
