ORA-00979: not a GROUP BY expression

From: DF Russell <dfr_at_raleigh.ibm.com>
Date: 1996/12/21
Message-ID: <59hn3f$1av2_at_rtpnews.raleigh.ibm.com>#1/1

[Quoted] This is probably a stupid question, but I've looked in a bunch of manuals & FAQS...

Given the following:

select substr(d.tablespace_name, 1, 15) as Table_Space,

    d.file_id as File_ID,
    d.bytes / 1024 / 1024 as Total_MB,
    d.bytes / 4096 as Oracle_Blocks,

    sum (e.blocks) as Blocks_Used,
    round (sum(e.blocks) / (d.bytes / 4096), 4) * 100 as Percent_Used from sys.dba_extents e, sys.dba_data_files d where d.file_id = e.file_id (+)
group by d.tablespace_name, d.bytes;

Why am I getting the ORA-00979: not a GROUP BY expression?

Oracle 7.1

TIA, DFR

-- 
[Quoted] Disclaimer: Views expressed are personal and not necessarily shared by IBM
e-mail: dfr_at_raleigh.ibm.com || (RALVM17)DFR
--------------------------------------------------------------------------
Tiger! Tiger! Burning bright, in the forests of the night. 
What immortal hand or eye, could frame thy fearful symmetry.

Received on Sat Dec 21 1996 - 00:00:00 CET