If you don't have access to dba_logs, use user_lobs instead: select table_name , column_name , in_row from user_lobs /
Axton Grams On Mon, Feb 13, 2012 at 2:33 PM, Axton <[email protected]> wrote: > You can see the current state using the Oracle data dictionary: > > select owner > , table_name > , column_name > , in_row > from dba_lobs > / > > Axton Grams > > On Mon, Feb 13, 2012 at 2:25 PM, Thad Esser <[email protected]> wrote: >> ** >> >> I was just testing that scenario as you responded. I created a new regular >> form, adding a character field with db length 8000 before the first save. >> >> This is what showed in the logs (clipped for brevity) when I did save it: >> >> CREATE TABLE T2011 (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) >> OK >> CREATE UNIQUE INDEX IT2011 ON T2011 (C1) >> OK >> CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 >> varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) >> NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 >> number(15,0) NULL,U4 varchar(254) NULL) >> OK >> >> ... >> <creates H, T, B tables and views> >> ... >> >> ALTER TABLE T2011 ADD (C536870913 clob NULL) >> >> >> Still no indication that it is accounting for the storage in row. I'm sure >> it's there, I would just like to "see" it happening or be able to verify it >> somehow. >> >> Thanks, >> Thad >> >> On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W >> <[email protected]> wrote: >>> >>> 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" >> >> >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
