Re: Oracle Table Spanning

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 25 Jan 2004 07:40:43 -0800
Message-ID: <1075045180.3210@yasure>

Jim Kennedy wrote:

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

If you are correct a 256K or 1M stripe solves the problem meaning it isn't even an Oracle issue. But then again ... so does hash partitioning so I still get to hang on to my 'knee-jerk' response.

I suspect the OP is long gone ... asked the question and just disappeared.

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

Received on Sun Jan 25 2004 - 09:40:43 CST