RE: 10g & partitioning

Hi

As pointed out by other repliers the partitioning option is only an = enterprise edition option, i.e. you have to pay for it if you want to = use it. But, be careful, in 10g the partition option is always = installed, even in the standard edition! Why? Because Oracle uses it to = manage the AWR repository...

You can check this by executing the following query (in this particular = system the partitioning option is only used for system purposes, i.e. = for AWR):

SQL> SELECT name, detected_usages
  2 FROM dba_feature_usage_statistics
  3 WHERE name LIKE 'Parti%';

NAME                                     DETECTED_USAGES
---------------------------------------- ---------------
Partitioning (system)                                  3
Partitioning (user)                                    0

Just my 2 cents,
Chris

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sol beach
>Sent: 08 April 2005 21:59
>To: Oracle-L Freelists
>Subject: 10g & partitioning
>
>I feel as though I'm looking for a needle in haystack on =
http://otn.oracle.com
>
>Is partitioning included in the 10g Standard Edition?
>
>TIA!
>--
>http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l