Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Archivelog mysteries
Alex,Thanks for the link. I'm browsing through the presenation now, and while it shows there's lots of other information written into the redo, it really isn't all that much.Mike,The table itself is pretty simple:CREATE TABLE "USGS"."SEARCH_TABLE"
( "DEP_ID" NUMBER(12,0) NOT NULL ENABLE,
"XML_CLOB" CLOB NOT NULL ENABLE,
"UPDATE_DATE" DATE DEFAULT sysdate,
CONSTRAINT "SEARCH_TABLE_PK" PRIMARY KEY ("DEP_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USGS_LOB_DATA" ENABLE,
CONSTRAINT "SEARCH_TABLE_FK" FOREIGN KEY ("DEP_ID")
REFERENCES "USGS"."DEPOSITS_BASE" ("DEP_ID") ON DELETE CASCADE ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USGS_LOB_DATA"
LOB ("XML_CLOB") STORE AS (
TABLESPACE "USGS_LOB_DATA" DISABLE STORAGE IN ROW CHUNK 32768 PCTVERSION 10
CACHE
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;