Re: Compatible parameter
From: Subodh Deshpande <subodh_deshpande_at_yahoo.com>
Date: Wed, 15 Jul 2009 08:06:13 -0700 (PDT)
Message-ID: <236463.61592.qm_at_web31107.mail.mud.yahoo.com>
Date: Wed, 15 Jul 2009 08:06:13 -0700 (PDT)
Message-ID: <236463.61592.qm_at_web31107.mail.mud.yahoo.com>
hi sarah, just a doubt..are you sure in pfile you have set the compatibility paramter to desired value. thanks and take care..subodh ________________________________ From: "Satterthwaite, Sarah" <sarah.satterthwaite_at_fiserv.com> To: oracle-l_at_freelists.org Sent: Wednesday, 15 July, 2009 19:49:43 Subject: Compatible parameter My databases are version 10.2.0.4.x, but some of them still have compatible set to 10.2.0.3.0. I want to know what restricted features will become available if I raise the value of compatible. The following is probably from version 7, but I have not found a similar view in Oracle 10: Type ID Release Updated Description -------- ------------ ------------ ----------------------------------- BOOTSTRP 7.0.10.0.0 7.0.12.0.0 bootstrap$ COMPATSG 7.0.11.0.0 7.0.12.0.0 Compatibility segment DATAFILE 7.0.11.0.0 Data file structure KCBCICT 7.1.5.0.0 Cache cross-instance protocol LOGSTRUC 7.2.0.0.0 Log structure TRUNCFIX 7.2.0.0.0 truncate bug fix CONTROLF 7.3.0.0.0 Control file RCVREDO 7.3.0.0.0 Recovery redo REDODATA 7.3.0.0.0 Redo contents TEMPTS 7.3.0.0.0 7.3.0.0.0 Temporary tablespace TRUNCNT 7.3.0.0.0 7.3.0.0.0 truncation count UNDODATA 7.3.0.0.0 7.3.0.0.0 Undo contents UNLMTEXT 7.3.0.0.0 7.3.0.0.0 unlimited extents DISLOCK 0.0.0.0.0 Alter Table Disable Table Lock FORCEVSN 0.0.0.0.0 Force undo/redo versions to exist HASHEXP 0.0.0.0.0 Hash expressions in hash clusters IMPHSHFN 0.0.0.0.0 Improved hash function KDIBIX 0.0.0.0.0 bitmap indexes KDINFB 0.0.0.0.0 index support for freelist groups LOCKING 0.0.0.0.0 Instance locking protocol MULTTRIG 0.0.0.0.0 Multiple Triggers Per Type RDONLYTS 0.0.0.0.0 Read only tablespace REDOORDR 0.0.0.0.0 Redo order by SCN RESZDAFL 0.0.0.0.0 Resizable data files REUSEBRB 0.0.0.0.0 reuse index branch blocks UPDSNAP 0.0.0.0.0 Updatable Snapshots I am quite sure that it was generated using the following SQL: col type_id format a8 head 'Type ID' col release format a12 head 'Release' col description format a40 head 'Description' word col updated format a12 head 'Updated' word col implemented noprint break on implemented skip 2 spool compatib.rep select decode (c.release, '0.0.0.0.0', '2,', '1') implemented, c.type_id, c.release, s.updated, c.description from v$compatibility c, v$compatseg s where c.type_id = s.type_id (+) and c.release = s.release (+) order by decode (c.release, '0.0.0.0.0', '2,', '1'), c.release, c.type_id, s.updated / Can someone point me to similar information in Oracle 10? Thanks, Sarah _______________________________ Sarah Satterthwaite Database Administrator Loan Fulfillment Solutions Fiserv Fax: 617-498-0959 www.fiserv.com P Please consider the environment before printing this e-mail
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 15 2009 - 10:06:13 CDT