Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - EAForum1

Pages: [1]
1
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:
>>>

Pages: [1]