Hello,
Trying to run the database repository creation script Oracle_EASchema.sql on an Oracle 11.2 instance, I get the error detailed below.
I suspect this may have to do with the bit <<<"LASTUPDATE" VARCHAR2(19) DEFAULT SYSDATE>>>, since SYSDATE is of datatype date, not latching the column type (VARCHAR2)?
Has this issue been encountered by others already?
Thank you,
Didier
Error details:
<<<
Error starting at line : 917 in command -
CREATE TABLE "T_OBJECTREQUIRES"
(
"REQID" NUMBER(10,0),
"OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL,
"REQUIREMENT" VARCHAR2(255),
"REQTYPE" VARCHAR2(255),
"STATUS" VARCHAR2(50),
"NOTES" CLOB,
"STABILITY" VARCHAR2(50),
"DIFFICULTY" VARCHAR2(50),
"PRIORITY" VARCHAR2(50),
"LASTUPDATE" VARCHAR2(19) DEFAULT SYSDATE,
CONSTRAINT "PK_OBJECTREQUIRES" PRIMARY KEY ("REQID")
)
Error report -
SQL Error: ORA-01401: inserted value too large for column
01401. 00000 - "inserted value too large for column"
*Cause: The value inserted was too large for the given column.
*Action: Do not insert a value greater than what the column can hold.
Error starting at line : 932 in command -
CREATE INDEX "IX_OBJREQ_OBJECTID" ON "T_OBJECTREQUIRES" ("OBJECT_ID")
Error report -
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error starting at line : 934 in command -
CREATE INDEX "IX_OBJREQ_REQ" ON "T_OBJECTREQUIRES" ("REQUIREMENT")
Error report -
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
>>>
