ORA-40101: ORA-00910: error on Test metrics or Apply activity
886672Sep 7 2011 — edited Sep 7 2011Hi!
I'm try to use SVN(or NB) method for Classification (using ODM tool) on Oracle 11g and recieve this error message (when runing
Test metrics or Apply activity):
*****************************************************************************************
Server task state: error
Server task detail:
ORA-40101: Data Mining System Error ORA-00910: specified length too long for its datatype
ORA-06512: at "SYS.DBMS_DATA_MINING", line 2245
ORA-06512: at "SYS.DBMS_JDM_INTERNAL", line 2001
--
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_JDM_INTERNAL", line 2443
ORA-06512: at line 1
*****************************************************************************************
What does it mean?
My input data structure is:
*****************************************************************************************
CREATE TABLE "DMUSER"."AAA"
( "ID" NUMBER(8,0), --id
"HOUR_OF_DAY" NUMBER(2,0), --values: 0..23, categorical
"DAY_OF_WEEK" NUMBER(1,0), --values: 1..7, categorical
"DAY_OF_MONTH" NUMBER(2,0), --values: 1..31, categorical
"WEEKEND" NUMBER(1,0), --values: 0 or 1, categorical
"HOLIDAY" NUMBER(1,0), --values: 0 or 1, categorical
"PRVALUE" NUMBER(8,0) target, values: 1300 different numbers, categorical
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
*****************************************************************************************
Target presents 1300 different numbers (classes): 0, 200, 400, ...
Records in table is about 8000.
May be classification algorithms limited on class count? Or input values range is invalid?
Thank you!