Oracle 表的objn和objd的变化
<DIV><P>objn: object name id</P>
<P>objd: object data id</P>
<P></P>
<P>objd会因表的turncate操作而发生变化</P>
<P>
<DIV class="dp-highlighter nogutter bg_c-sharp:nogutter:nocontrols">
<DIV class=bar></DIV>
<OL class=dp-c>
<LI class=alt><SPAN><SPAN>SQL> select object_id,object_name from user_objects where object_name=</SPAN><SPAN class=string>'TEST_USER'</SPAN><SPAN>; </SPAN></SPAN></LI>
<LI><SPAN>OBJECT_ID </SPAN></LI>
<LI class=alt><SPAN>---------- </SPAN></LI>
<LI><SPAN>OBJECT_NAME </SPAN></LI>
<LI class=alt><SPAN>-------------------------------------------------------------------------------- </SPAN></LI>
<LI><SPAN>71329 </SPAN></LI>
<LI class=alt><SPAN>TEST_USER </SPAN></LI>
<LI><SPAN>SQL> select name,obj#,dataobj# from obj$ where obj#=71329; </SPAN></LI>
<LI class=alt><SPAN>NAME OBJ# DATAOBJ# </SPAN></LI>
<LI><SPAN>------------------------------ ---------- ---------- </SPAN></LI>
<LI class=alt><SPAN>TEST_USER 71329 71329 </SPAN></LI>
<LI><SPAN>SQL> truncate table test_user; </SPAN></LI>
<LI class=alt><SPAN>Table truncated. </SPAN></LI>
<LI><SPAN>SQL> select name,obj#,dataobj# from obj$ where obj#=71329; </SPAN></LI>
<LI class=alt><SPAN>NAME OBJ# DATAOBJ# </SPAN></LI>
<LI><SPAN>------------------------------ ---------- ---------- </SPAN></LI>
<LI class=alt><SPAN>TEST_USER 71329 71828 </SPAN></LI></OL></DIV></DIV>
页:
[1]