oracle objn objd

objn: object name id

objd: object data id

 

objd会因表的turncate操作而发生变化

SQL> select object_id,object_name from user_objects where object_name='TEST_USER'; OBJECT_ID ---------- OBJECT_NAME -------------------------------------------------------------------------------- 71329 TEST_USER SQL> select name,obj#,dataobj# from obj$ where obj#=71329; NAME OBJ# DATAOBJ# ------------------------------ ---------- ---------- TEST_USER 71329 71329 SQL> truncate table test_user; Table truncated. SQL> select name,obj#,dataobj# from obj$ where obj#=71329; NAME OBJ# DATAOBJ# ------------------------------ ---------- ---------- TEST_USER 71329 71828