On Apr 3, 1:52 pm, sybra..._at_hccnet.nl wrote:
> On 3 Apr 2007 09:59:26 -0700, "EdStevens" <quetico_..._at_yahoo.com>
> wrote:
>
> >Interesting distinction that Oracle makes there. We have a very
> >vanilla installation, no partitioning on user tables. But a query of
> >dba_tab_partitions shows a bunch of SYS and SYSTEM tables that are
> >partitioned. Most appear to be associated with the OEM repository
> >tables and logminer tables. So it would appear that, for all
> >practical purposes, the partitioning option must be installed for
> >Oracle's own use, even if not for the customer's.
>
> Actually that seems to be incorrect. I studied the installation code
> (don't remember the name anymore). When partitioning is installed the
> tables will be partitioned. If partitioning isn't installed, they
> won't be partitioned.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Makes sense. I've never had reason to dig that deep. All of my work
installations have mandated partitioning anyway, and private
installations on my desktop have always been 'default' .. which
defaults to include partitioning.
Received on Wed Apr 04 2007 - 07:58:06 CDT
