Re: query help

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Tue, 17 Aug 1999 14:58:12 -0400
Message-ID: <37B9B0C4.27CEEBB7@bigfoot.com>

Thanks for your replies...

What's a good method for doing the opposite? In other words, what if I want to
be a real stinge on space and would rather reduce the max_extent to fit with what
I have? What's a good analysis?

Doug Cowles wrote:

> 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?
>
> - Dc.
Received on Tue Aug 17 1999 - 13:58:12 CDT