Re: Oracle Table Spanning

Serge Rielau wrote:

> Doesn't the use of a partitioned table imply that all these reports in
> different formats first need to be cleansed and then copied into the
> partitioned table?
> From how I read this thread it's not obvious that this is an option.
> Partitioned tables deal with scale but not with heterogeneity.
> If copying the data is not an option and it is a requirement to see all
> the data through one interface then I'd guess that some rather complex
> UNION ALL view may be the only option.
> Smells a lot like an information integration problem (just local on one
> DB).
>
> Cheers
> Serge

We are still back to the unanswered question. What is "table spanning"?

I am guessing that it means creating a lot of tables with an identical structure and putting a bunch of rows from reports into one table and then when reaching some number of rows putting stuff into the second table, and on and on and on. Perhaps I am incorrect ... so far no noe has defined the term so we are all guessing.

But if I am correct ... then partitioning is a viable answer.

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