you should connect to db by sys user.
for example: connect sys/password as sysdba
you run the script,you can get what you want :
SELECT a.owner,a.object_name,a.created,a.last_ddl_time,a. timestamp,a.status
FROM DBA_OBJECTS a
where a.owner in (select distinct owner
from dba_objects
where owner not in ('SYS','SYSTEM'))
order by a.owner desc;
|