Re: Block question
- From: pavan kumar <pavan_843@xxxxxxxxxxx>
- To: "cure@xxxxxxxxxxxxx" <cure@xxxxxxxxxxxxx>, 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 28 Feb 2015 08:52:58 +0000 (UTC)
Hi,
The searching block id, can be initial block or with in the range of blocks.
- ThanksPavan Kumar N
From: Paul Harrison <cure@xxxxxxxxxxxxx>
To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
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
Other related posts:
