The ddl for the table "log.main" has an error in the default value for the field "timereceived".
This product is shipped with:
-- Table: main
CREATE TABLE main (
messageid VARCHAR2(255) NOT NULL,
is_secure CHAR(1),
ip VARCHAR2(100) NOT NULL,
timereceived TIMESTAMP(3) DEFAULT '2008-08-30 19:56:01.093',
test VARCHAR2(100) NOT NULL,
pass CHAR(1),
CONSTRAINT main_pkey PRIMARY KEY (messageid),
CONSTRAINT main_ip_fkey FOREIGN KEY (ip)
REFERENCES ip (ip)
);
It needs to be changed to:
-- Table: main
CREATE TABLE main (
messageid VARCHAR2(255) NOT NULL,
is_secure CHAR(1),
ip VARCHAR2(100) NOT NULL,
timereceived TIMESTAMP(3) DEFAULT '30-AUG-08 7:56:01.093 PM',
test VARCHAR2(100) NOT NULL,
pass CHAR(1),
CONSTRAINT main_pkey PRIMARY KEY (messageid),
CONSTRAINT main_ip_fkey FOREIGN KEY (ip)
REFERENCES ip (ip)
);
I realize that this issue can be set by modifying the environment, however since we only need to deal with 1 time only (during install) why add the extra step (which most non Oracle dba types will miss) to the process. By fixing the default date format in the ddl it will make the install much simpler.
Regards, Louis.