Oracle OBJN objd__oracle

Objn:object Name ID

Objd:object Data ID

OBJD will change depending on the turncate operation of the table

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