Re: Oracle 10g XE problem

From: HansF <>
Date: Sat, 15 Apr 2006 18:45:52 GMT
Message-Id: <>

On Sat, 15 Apr 2006 09:34:00 -0700, sati_82 wrote:

> Hi!
> I have one question to you, because I've read lately about ODM (Oracle
> Data Mining) tools in Oracle 10g Database. Right now I'm using ORacle 10g
> Express Edition and I heard that if I want to use ODM this following
> SELECT statemant:
> SELECT parameter,value FROM v$option WHERE parameter = 'Data Mining' must
> return TRUE. Unfortunetly in Oracle 10g XE this value is FALSE. So, my
> question is, can I change this value in any way?

Sure, you can change it - buy mucking about ni the data dictionary.

But that will not help you much - in fact, it is dangerous for the sanity of the database - as the Data Mininng is an option for the Enterprise Edition, and 'Enterprise Edition'-only features and options are not available in the Express Edition.

Simply put - people wanted a light-weight version of Oracle, so Oracle eliminated stuff to make it light weight.

Remember that a large number of the data analytic functions that are described in the SQL Reference manual are pure SQL and don't need the OLAP or Data Mining functions. The SQL Reference manual is at, and I heartly recommend looking at the table of contents to get a list of the built-in functions.

If you are simply investigating, download and install the Enterprise Edition. The 'developers license' permits eval and prototyping free of charge.

Hans Forbrich                           
Canada-wide Oracle training and consulting
*** Top posting [replies] guarantees I won't respond. ***
Received on Sat Apr 15 2006 - 20:45:52 CEST

Original text of this message