When trying to create or alter a table Toad gives the message:
"Invalid Specification - When specifying a system default value of SESSION USER, the datatype column for column CRETD_BY_ID must support character data with a minimum length of 128. "
or
Table script sample:
CREATE TABLE "DUMMY" (
"DUMMY_ID" INTEGER NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20,
NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),
"CRETD_BY_ID" VARCHAR(8) DEFAULT USER,
"CRETD_BY_TS" TIMESTAMP DEFAULT ,
"MDFYD_BY_ID" VARCHAR(8),
"MDFYD_BY_TS" TIMESTAMP
)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center