Oracle 表的objn和objd的变化

scb0814

objn: object name id

objd: object data id

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

1. SQL> select object_id,object_name from user_objects where object_name='TEST_USER';
2. OBJECT_ID
3. ----------
4. OBJECT_NAME
5. --------------------------------------------------------------------------------
6. 71329
7. TEST_USER
8. SQL> select name,obj#,dataobj# from obj$ where obj#=71329;
9. NAME OBJ# DATAOBJ#
10. ------------------------------ ---------- ----------
11. TEST_USER 71329 71329
12. SQL> truncate table test_user;
13. Table truncated.
14. SQL> select name,obj#,dataobj# from obj$ where obj#=71329;
15. NAME OBJ# DATAOBJ#
16. ------------------------------ ---------- ----------
17. TEST_USER 71329 71828