You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: [email protected] Subject: Question about "Oracle-Clob-Storage-In-Row" setting ** 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"
