| SH schema in Oracle 10g [message #171867] |
Thu, 11 May 2006 19:34  |
orcl_developer
Messages: 15
Registered: March 2005
|
Junior Member |
|
|
I installed Oracle 10g Release 2 on a Windows environment to start work on Oracle Data Mining. I followed a regular install and created a simple database called ORCL with the option of Oracle Data Mining set to true. It did not create the SH schema. I googled to get information on manual creation and data load for SH schema. One of the hits said I need to run the SH_main.sql script under demo/schemas/Sales_history. I do not see anything under that folder.
Please advise.
Thanks
Orcl_developer
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10771/installation002.htm
|
|
|
|
|
|
| Re: SH schema in Oracle 10g [message #172478 is a reply to message #171867] |
Tue, 16 May 2006 15:31  |
orcl_developer
Messages: 15
Registered: March 2005
|
Junior Member |
|
|
Thanks for the info.
I was able to create the schema but get the following error now when i try to run the model.
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
Suggested resolution
On Windows, you can invoke Oracle Universal Installer and select 'installed product', choose 'Data Mining Scoring Engine' option and click 'remove' button there.
Check v$option value for 'Data Mining' option. If the value is TRUE, you are all set.
I tried that but was unable to locate the Data Mining Scoring Engine in the Installed products. I was wondering if someone knew any other name it is listed under.
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
