Using Oracle 11.2.0.1 on Oracle Linux 5.8 x64
I am trying to install Zabbix http://www.zabbix.com and am using Oracle database as the data store. The supplied schema script below is not working.
CREATE TABLE maintenances (
maintenanceid number(20) NOT NULL,
name nvarchar2(128) DEFAULT '' ,
maintenance_type number(10) DEFAULT '0' NOT NULL,
description nvarchar2(2048) DEFAULT '' ,
active_since number(10) DEFAULT '0' NOT NULL,
active_till number(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (maintenanceid)
);
When I run it, I get
Error at Command Line:5 Column:42
Error report:
SQL Error: ORA-00910: specified length too long for its datatype
00910. 00000 - "specified length too long for its datatype"
*Cause: for datatypes CHAR and RAW, the length specified was > 2000;
otherwise, the length specified was > 4000.
*Action: use a shorter length or switch to a datatype permitting a
longer length such as a VARCHAR2, LONG CHAR, or LONG RAW
According to the oracle documentation the limit for nvarchar2 is 4000. What have I missed here?