query help

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Tue, 17 Aug 1999 02:46:55 -0400
Message-ID: <37B9055E.612D218B@bigfoot.com>

I'm trying to get a list of tablespaces where the largest chunk of free space is less than
the largest next_extent of objects in the tablespace - I'm trying
SQL> select a.tablespace_name, max(bytes) from dba_free_space a 2 where max(bytes) < (select max(next_extent) from dba_segments b 3 where a.tablespace_name = b.tablespace_name); where max(bytes) < (select max(next_extent) from dba_segments b

*
ERROR at line 2:
ORA-00934: group function is not allowed here

What am I doing wrong?

Received on Tue Aug 17 1999 - 01:46:55 CDT