| 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
![]() |
![]() |