PL/SQL (MOSC)

MOSC Banner

ORA-00934: group function is not allowed here

in PL/SQL (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center