this view need to be granted from DBA. SELECT SUBSTR (GLOBAL_NAME, 1, INSTR (GLOBAL_NAME, '.') - 1) FROM GLOBAL_NAME ;