ORA-00934: group function is not allowed here
Hi,
On 19c, when running:
select TABLESPACE_NAME, sum(bytes/(1024*1024)) , sum(maxbytes/(1024*1024)) ,
round((sum(bytes/(1024*1024))/sum(maxbytes/(1024*1024)))*100) Pourcent_occupe from dba_data_files where autoextensible='YES'
AND ( round((sum(bytes/(1024*1024))/sum(maxbytes/(1024*1024)))*100) > 0.80)
group by TABLESPACE_NAME;
I have:
ORA-00934: group function is not allowed here
00934. 00000 - "group function is not allowed here"
*Cause:
*Action:
Error at Line: 3 Column: 14
Thanks for your help.