Oracle alle User selectieren
ora.jpg
alle User

select * from dba_users;
    

Kopieren

ohne system, sysaux, tools

select * from dba_users
where lower(default_tablespace) <> 'system'
and lower(default_tablespace) <> 'sysaux'
and lower(default_tablespace) <> 'tools';
    

Kopieren