Re: Oracle Table Spanning

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

By "table spanning" are you approaching Oracle with a Microsoft-centric concern that big tables are bad? That millions of rows is an issue? That you need to load a single set into multiple tables? That you have a justification for denormalizing an object-relational database?

BTW: We appreciate knowing the Oracle version and edition.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)