As the title suggests, I am trying to understand the structure of our Oracle DBs a little more and a little confused by the ALL, DBA & USER Objects.
A quick SQL
select count(*) ALL_OBJS from all_objects where owner = 'XXXX'; select count(*) DBA_OBJS from dba_objects where owner = 'XXXX'; select count(*) USER_OBJS from USER_OBJECTS; (logged on as XXXX)
ALL_OBJS ---------- 1591 DBA_OBJS ---------- 1632 USER_OBJS ---------- 1632
As I presume our user has DBA rights and the USER objects and DBA objects are the same? But what are ALL objects? If you are looking to clear out a User's SCHEMA which would you remove from or would you drop objects from all three?