Linux DB 19.19 ORA-12850 raised in sqlid
Oracle Enterprise Linux 7.9
Oracle Database Enterprise Edition 19.19 Apr/18/2023
alert_mcs1.log has repeated occurrences of ORA-12850
ORA-12850 raised in sqlid=9s8vy5xp8uvkt
-----
--sqlid=9s8vy5xp8uvkt -- PDB: AUX@MARDEV1
SELECT sum(priv),layer_id FROM
(SELECT DISTINCT a.owner,a.table_name,sum(decode(privilege,'SELECT',1, 'INSERT',2,'UPDATE',4,'DELETE',8,NULL)) priv,l.layer_id
FROM (SELECT DISTINCT owner,table_name,privilege
FROM all_tab_privs_recd) a,SDE.LAYERS l WHERE a.owner = REPLACE (l.owner,'"')
AND a.table_name = l.table_name AND a.privilege IN ('SELECT','UPDATE','INSERT','DELETE')
GROUP BY (a.owner,a.table_name,l.layer_id)) GROUP BY owner,table_name,priv,layer_id ORDER BY layer_id