Hi,
Can someone from logdigger team please help me configuring store with oracle db. I am getting below error and have posted the same in your side but not getting any answer.
Please let me know if oracle is supported or not.
CREATE
TABLE "logdigger_errorlog" ("id" VARCHAR2(255) PRIMARY KEY NOT NULL ,
"time" TIMESTAMP NOT NULL , "prj" VARCHAR2(255) , "host" VARCHAR2(255) ,
"url" LONG , "err" INTEGER , "type" VARCHAR2(255) , "message" LONG ,
"st" LONG , "user" VARCHAR2(255) , "snip" LONG , "applog" LONG RAW ,
"ctx" LONG RAW , "cv0" VARCHAR2(255) , "cs0" VARCHAR2(255) , "cv1"
VARCHAR2(255) , "cs1" VARCHAR2(255) , "cv2" VARCHAR2(255) , "cs2"
VARCHAR2(255) , "cv3" VARCHAR2(255) , "cs3" VARCHAR2(255) , "cv4"
VARCHAR2(255) , "cs4" VARCHAR2(255) , PRIMARY KEY ("id") )
Error at Command Line:3 Column:203
Error report:
SQL Error: ORA-01754: a table may contain only one column of type LONG
01754. 00000 - "a table may contain only one column of type LONG"
*Cause: An attempt was made to add a LONG column to a table which already
had a LONG column. Note that even if the LONG column currently
in the table has already been marked unused, another LONG column
may not be added until the unused columns are dropped.
*Action: Remove the LONG column currently in the table by using the ALTER
TABLE command.
Thanks
Prabhat