find list of tables in OIM schema

sqlplus "/as sysdba"

select table_name from DBA_TABLES where owner='DEV_OIM';


SELECT *
  FROM DEV_OIM.USR where USR_LOGIN='XELSYSADM';