Does anyone out there know if any version of ORACLE can physically
partition a single table into seperate disks based on a data rule?
Example:
A very large table which contains 4 fiscal years worth of transactions
would be partitioned onto 4 seperate disks based on fiscal year
with the current fiscal year on the fastest one. When a query is
made against this table using the fiscal year, only the disk where
the applicable fiscal year resides is accessed.
I know that DB2 can do this but I would like to know if ORACLE can?
Any comments would be appreciated. Thanks.