DMSYS.DBMS_DATA_MINING not exist
483679Jan 19 2006 — edited Oct 14 2008Dear All,
I am sure I installed oracle data mining option. However, when I tried to export data mining model according to page 40 of dataminingAdmin.pdf I get an error stating that "operation requires Data Mining option to be installed".
Thank you,
Arnold
**** log ****
E:\oracle\product\10.2.0\db_1\RDBMS\demo>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 18 20:57:18 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: dmuser
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
SQL> EXECUTE DBMS_DATA_MINING.EXPORT_MODEL('allmodels.dmp','DMTEST');
BEGIN DBMS_DATA_MINING.EXPORT_MODEL('allmodels.dmp','DMTEST'); END;
*
ERROR at line 1:
ORA-40107: operation requires Data Mining option to be installed
ORA-06512: at "DMSYS.DBMS_DATA_MINING", line 5196
ORA-06512: at line 1