Re: Oracle Table Spanning

Andrey wrote:

> Dear Sybrand. Though purpose you comments is clear to me - you want to make
> answer as strict and corresponding to official Oracle documentation as
> possible - in this particular case it is excessive.
>
> Man who questioned stated that he can not change application AND database
> design ("I'm not allowed to manipulate data"). This "and" in aggregate with
> obvious newbie character of question proves he asked about very general
> concept of Oracle capabilities. So, I proposed to turn attention to
> optimization theme, surely good way to questioner to start learning Oracle
> without actually breaking into it.

You are absolutely incorrect in your statements. If he can span data across tables ... whatever that is supposed to mean ... he can certainly span data across partitions which doesn't require writing a single line of code.

To say the EE and partitioning are excessive given the quantities of data to be stored ... billions of rows ... is equally incorrect.

I suspect Sybrand feels as I do that you don't understand the OP's question ... as I suspect we really don't either.

Until someone defines "table spanning" this is all pure speculation.

-- 
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)