Error in WHERE ...= (SELECT ... ORDER ...)

[DaPi]

Or is this what you want:

select  obj#, owner#, ctime 
from
(select obj#, owner#, ctime, 
 max(ctime) over (partition by owner#) mct 
 from   sys.obj$)
where ctime=mct