Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> What is logged on insert on identity columns?
Suppose a table defined as:
CREATE TABLE "MYSCHEMA"."T1" (
"ID1" DECIMAL(8,0) NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 INCREMENT BY +1 MINVALUE +1 MAXVALUE +99999999 NO CYCLE CACHE 20 NO ORDER ) ) DATA CAPTURE CHANGES IN "USERSPACE1" ;
db2 insert into myschema.t1 values (default).
Is the real value inserted in the table logged and is it possible to retrieve it with the log analyis API?
Bernard Dhooghe Received on Tue Jun 27 2006 - 06:08:31 CDT