Re: Block question
Date: Sat, 28 Feb 2015 08:52:58 +0000
Message-ID: <1235152274.149282.1425113578470.JavaMail.yahoo_at_mail.yahoo.com>
Hi,
The searching block id, can be initial block or with in the range of blocks. - ThanksPavan Kumar N
From: Paul Harrison <cure_at_austin.rr.com> To: 'ORACLE-L' <oracle-l_at_freelists.org> Sent: Saturday, 28 February 2015 1:51 AM Subject: Block question
<!--#yiv3866692616 _filtered #yiv3866692616 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv3866692616 #yiv3866692616 p.yiv3866692616MsoNormal, #yiv3866692616 li.yiv3866692616MsoNormal, #yiv3866692616 div.yiv3866692616MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv3866692616 a:link, #yiv3866692616 span.yiv3866692616MsoHyperlink {color:blue;text-decoration:underline;}#yiv3866692616 a:visited, #yiv3866692616 span.yiv3866692616MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv3866692616 span.yiv3866692616EmailStyle17 {font-family:"Arial", "sans-serif";color:windowtext;}#yiv3866692616 .yiv3866692616MsoChpDefault {font-family:"Calibri", "sans-serif";} _filtered #yiv3866692616 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv3866692616 div.yiv3866692616WordSection1 {}-->Hi Team, I came upon the below on the internet." ( &block_value BETWEEN block_id AND ( block_id + blocks ) )" <-- I don't understand how this comes into the equation. Shouldn't it just be &block_value = <value> ? List an Object and Object Type via a Given File and Block ID. ---- List an Object and Object Type via a Given File and Block ID.-- SET PAUSE ONSET PAUSE 'Press Return to Continue'SET PAGESIZE 60SET LINESIZE 300 COLUMN segment_name FORMAT A24COLUMN segment_type FORMAT A24 SELECT segment_name, segment_type, block_id, blocks FROM dba_extents WHERE file_id = &file_no AND ( &block_value BETWEEN block_id AND ( block_id + blocks ) )/ Thanks,Paul
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 28 2015 - 09:52:58 CET