Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What is logged on insert on identity columns?

What is logged on insert on identity columns?

From: Bernard Dhooghe <dhoogheb_at_yahoo.com>
Date: 27 Jun 2006 04:08:31 -0700
Message-ID: <1151406511.199029.282520@i40g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US