Re: Oracle Table Spanning

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1074992508.91458_at_yasure...
> 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)
>

From a little research I think table spanning is spreading a table across multiple disks. But since the person who asked the question refuses to tell us what the heck he meant by the term we have no idea if in fact I am correct or not.

If I am correct then Oracle can certainly do that without a problem. (Or course, if I am wrong then Oracle can still do that without a problem.) Jim Received on Sun Jan 25 2004 - 01:00:51 CST