OpticTygre wrote:
>
> Hi folks. Does anyone know where I can find any good resources on how to do
> table spanning in Oracle? I have some very large tables which holds data
> reports that come off thousands of machines on a monthly basis. These
> reports are unrelational, and very user-unfriendly, and unfortunately, I'm
> not allowed to manipulate the data. After a short time, there will be
> millions and millions of rows for each of these reports. Is there a way I
> could span the data across multiple tables without interfering too much with
> outside code (ASP) that accesses the database? Is there a better way to
> handle this problem?
>
> If anyone could point me in the right direction, it would be greatly
> appreciated. Thanks in advance.
>
> - J
Are you perhaps thinking of 'Partitioning'? You can get some details
about that at http://otn.oracle.com > Products > Database > Scalability
Received on Fri Jan 23 2004 - 23:06:35 CST
