demo08.sql

Expert Oracle Database Architecture 9i and 10g sql源码

 select data_object_id, count(*)
   from dba_objects
  where data_object_id is not null
  group by data_object_id
 having count(*) > 1;