Re: storage clause help !!!!!

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 30 Dec 1999 18:29:56 +0800
Message-ID: <386B3424.274D@yahoo.com>

Sybrand Bakker wrote:
>
> select distinct tablespace_name, initial_extent, next_extent, pct_increase,
> pct_free
> from dba_segments
>
> should do the trick.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Serge Nantel <snantel_at_sympatico.ca> wrote in message
> news:386BAAF9.F8C10500_at_sympatico.ca...
> > Help I need a script to retrieve all the storage clause from a Oracle
> > database 7.3.x can some one help me with this!
> >
> > Thank you kindly
> > snantel_at_sympatico.ca
> >
> >
> >
> >

I'm curious - why the distinct ?
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 30 1999 - 04:29:56 CST