Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned Views

Re: Partitioned Views

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1998/03/18
Message-ID: <6eq3i6$5gc@bgtnsc02.worldnet.att.net>#1/1

You need to set an INIT.ORA parameter, PARTITION_VIEWS_ENABLED (or some similar name; check the v$parameter view) to TRUE in order to enable partitioned views.

Hope this helps.

Michael Serbanescu



Dennis M Regan wrote:
>
> Help,
>
> I've partitioned a very large table into serveral smaller tables using
> date field criteria as the partition. Next, I created indexes on all the
> partitions for this date field. Then I alter the tables to create the
> check constraint (date_file between ...). I then analyze the tables and
> create the view using union all. When I query the view, I specify a date
> in the where clause, and Oracle does an index range scan on all the
> tables! Why doesn't and isn't Oracle supposed to be able to eliminate
> partitions? What's up?
>
> DR
Received on Wed Mar 18 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US