如何根据DBA号来获取数据的对象信息
一个对象的其中一个数据块的DBA号为382524589,那如何根据这个号码来获取到该对象的信息:<BR><TABLE style="BORDER-BOTTOM: rgb(153,153,153) 1px solid; BORDER-LEFT: rgb(153,153,153) 1px solid; BACKGROUND-COLOR: rgb(172,172,172); WIDTH: 100%; FONT-SIZE: 12px; BORDER-TOP: rgb(153,153,153) 1px solid; BORDER-RIGHT: rgb(153,153,153) 1px solid" align=center>
<TBODY>
<TR>
<TD><P>DBV-00201: Block, DBA 382524589, marked corrupt for invalid redo application</P><P>SQL> select DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(382524589) from dual;</P><P>DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(382524592)<BR>------------------------------------------------<BR> 797193</P><P>SQL> select DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(382524589) from dual;</P><P>DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(382524592)<BR>-----------------------------------------------<BR> 91<BR>SQL> SELECT tablespace_name, segment_type, owner, segment_name<BR>2FROM dba_extents<BR>WHERE file_id = 91 and &BL between block_id AND block_id + blocks - 1;3 <BR>Enter value for bl: 797193<BR>old 3: WHERE file_id = 91 and &BL between block_id AND block_id + blocks - 1<BR>new 3: WHERE file_id = 91 and 797193 between block_id AND block_id + blocks - 1</P><P>TABLESPACE_NAME<BR>------------------------------<BR>SEGMENT_TYPE<BR>------------------------------------------------------<BR>OWNER<BR>------------------------------<BR>SEGMENT_NAME<BR>--------------------------------------------------------------------------------<BR>PSINDEX<BR>INDEX<BR>SYSADM<BR>PS_Z_PI_P2010M</P><P> </P></TD></TR></TBODY></TABLE>
<P></P>
<P>主要是调用了DBMS_UTILITY 包的对象来进行转换。<BR></P>
页:
[1]