Re: Oracle 10g XE problem

> 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
http://www.oracle.com/pls/db102/portal.portal_db?selected=1, 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.