Re: which edition is Oracle9i Release 9.2.0.1.0

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 13 Feb 2003 20:33:52 -0800
Message-ID: <3E4C71B0.CFA56DDD@exesolutions.com>

SP wrote:

> Does Oracle9i Release 9.2.0.1.0 - Production mean standard edition?
> TIA,
> SP

There is no connection between version number and edition. I am currently working on 9.2.0.1.0 and it is definitely Enterprise Edition as I have partitioned tables.

Run this query:

SELECT object_name
FROM dba_objects
WHERE object_name LIKE '%PARTITION%';

If you find the objects that support partitioning such as ALL_TAB_PARTITIONS and ALL_TAB_SUBPARTITIONS I would guess it is Enterprise Edition ... but this is only a guess as I don't have a copy handy to test it on.

Daniel Morgan Received on Thu Feb 13 2003 - 22:33:52 CST

Re: which edition is Oracle9i Release 9.2.0.1.0 - Production