我正在研究ORACLE数据挖掘那块,就是Data Mining ,
首先我在SQL PLUS中创建用户
1创建永久性表
CREATE TABLESPACE "ODMPERM" DATAFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\odm1.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 20M;
2.使用SQL创建用户 CREATE USER dmuser1 IDENTIFIED BY change_now
DEFAULT TABLESPACE odmperm
TEMPORARY TABLESPACE odmtemp
QUOTA UNLIMITED on odmperm;3.提供权限
GRANT create procedure to DMUSER1
/
GRANT create session to DMUSER1
/
GRANT create table to DMUSER1
/
GRANT create sequence to DMUSER1
/
GRANT create view to DMUSER1
/
GRANT create job to DMUSER1
/
GRANT create type to DMUSER1
/
GRANT create synonym to DMUSER1
/
GRANT execute on ctxsys.ctx_ddl to DMUSER1
/GRANT SELECT ON hr.employees TO DMUSER1;创建数据挖掘用户之后登陆DATA Miner时出先了问题,这是DATA Miner登陆时我填写的内容:
Connection Name : DATA Miner
User: DMUSERS
Password: DMUSERS
HOST: 我的IP
Port: 1521
SID: orcl点击OK没问题
但是连接的时候就报错了:Specified schema is not configured for use with Oracle Data Mining急呀..我用的ORACLE和MINER的版本是10.1
首先我在SQL PLUS中创建用户
1创建永久性表
CREATE TABLESPACE "ODMPERM" DATAFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\odm1.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 20M;
2.使用SQL创建用户 CREATE USER dmuser1 IDENTIFIED BY change_now
DEFAULT TABLESPACE odmperm
TEMPORARY TABLESPACE odmtemp
QUOTA UNLIMITED on odmperm;3.提供权限
GRANT create procedure to DMUSER1
/
GRANT create session to DMUSER1
/
GRANT create table to DMUSER1
/
GRANT create sequence to DMUSER1
/
GRANT create view to DMUSER1
/
GRANT create job to DMUSER1
/
GRANT create type to DMUSER1
/
GRANT create synonym to DMUSER1
/
GRANT execute on ctxsys.ctx_ddl to DMUSER1
/GRANT SELECT ON hr.employees TO DMUSER1;创建数据挖掘用户之后登陆DATA Miner时出先了问题,这是DATA Miner登陆时我填写的内容:
Connection Name : DATA Miner
User: DMUSERS
Password: DMUSERS
HOST: 我的IP
Port: 1521
SID: orcl点击OK没问题
但是连接的时候就报错了:Specified schema is not configured for use with Oracle Data Mining急呀..我用的ORACLE和MINER的版本是10.1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货