Re: Help please - View as union of multiple small tables

Well, then partitioned view will be your only other choice. I have not used it since partitioning became available. Not sure if it is still being supported. I seem to recall you need to set the init parameter partitioned_view or something like that to true.

• Jusung Yang

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0305300601.352057b_at_posting.google.com>...
> Hi,
> more specifically my oracle version is oracle 8i (8.1.7.4). Yes
> partitioned tables is better/right way to go as opposed to partition
> views.
> But i guess the parititioned tables is available only in Oracle
> Enterprise edition. If one were to stick with 8.1.7.4 standard, then
> where to look for????
> (EE is costly and especially when one wants to distribute and
> scale..additional licenses will boost up the price)
>
>
>
>
>
> JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0305291720.59ee190_at_posting.google.com>...
> > avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0305291400.2d4a1038@posting.google.com>...
> > > Hi oracle gurus,
> > >
> > > Let me admit first this. I dont much of oracle except using it do some
> > > DDL and DML.
> > > GOAL :I have a very large table and have to split into multiple
> > > smaller tables (so that writes can speed up). Now for reporting
> > > purposes, I cannot expose all these tables. So I decided to create a
> > > View which is UnionAll of these multiple small tables. Also, in our
> > > case as the data keeps growing and tables get added dynamically.
> > >
> > > How do i go about doing this while ensuring at any time only one small
> > > table is scanned as opposed to all tables ???
> > >
> > > I dont know what is an EXPLAIN PLAN ??? what is tkprof etc... to know
> > > what oracle is doing when a query on the full view is done ????
> > >
> > > I am using Oracle 8i.
> > >
> > > Any help in this regard is appreciated. Actually i read couple of
> > > articles in google about partition views but i got lost.
> > >
> > > Can Any body who can explain me in simple terms ???
> > >
> > > -thanks in advance,
> > > avsrk
> >
> > Partitioning is what you really need.
> >
> > - Jusung Yang
Received on Fri May 30 2003 - 20:40:06 CEST