Re: ORACLE Data Partitioning?

In article <3lc1a9$5q1_at_usenet.rpi.edu>, hoffma_at_rpi.edu (Adam Hoffman) writes:
|> 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.

i do not know of a way in which oracle will currently do this type of partitioning for you. you can however strip your tablespace across n disks and use the parallel loader to load the individual files. indexed access would then achieve what you are looking for. i think that oracle is going to continue to improve in this area. it is only going to get better. we have done quite alot of work in this area - 714 has some "features" that will be enhanced in 716 and 72x.

-- 

Thanks,
-------------------------------------------------------
Joe Minnich                  jminnich_at_bugaboo.ssnet.com
System Administrator         302-791-8662
Electronic Payment Services