Re: Default and temp tablespaces

On Thu, 21 Apr 2005 20:34:37 +0100, "J Williams" <NOTjohnwilliams_esq_at_NOThotmail.com> wrote:

>Thanks Kenneth.
>
>I have another couple of questions:
>
>1. How do I determine whether the partitioning option has been installed?
>(Is there a way apart from reading it on the OEM Console - Instance -
>Configuration - General tab?)
>
>2. How do I determine whether the partitioning option has been installed?
>

1. select value from v$option where lower(parameter) = 'partitioning';

OR

2)CREATE TABLE test_part

      ( part number(1) not null)     PARTITION BY RANGE (part)

     (PARTITION kdo_gem0 VALUES LESS THAN (5)
              tablespace users,
           PARTITION kdo_gem9 VALUES LESS THAN (maxvalue)
              tablespace users);

will fail if partitioning option is not installed.

OR

3) connect via sql*plus and get the answer

Forbindelse er oprettet til :
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options
              ^^^^^^^^^
          

• Kenneth Koenraadt