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