Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set "Oracle-Clob-Storage-In-Row: T" in the ar.conf.
My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the "Using Oracle CLOBs with BMC Remedy Action Request System" (March 2009, 89963) white paper it says: "To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement." So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says "STORAGE IN ROW" or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
