■ 사용자별 객체 보유 현황 조회하기

----------------------------------------------------------------------------------------------------

SELECT OBJECT_NAME, OBJECT_TYPE

FROM   DBA_OBJECTS

WHERE  OWNER = 'SYSTEM'

ORDER BY OBJECT_NAME ASC;

----------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG