Re: storage clause help !!!!!

Cause there may be more than one segment with same storage characteristics in one tablespace? Since the qry retrieves the different storage clauses with no reference to actual segments :-)

Connor McDonald wrote:

> 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."

--

+-------------------------------------+----------------------------+
| Fred Petillot                       |     fpetillo_at_fr.oracle.com |
| Oracle France - Support Technique   |            +33 1 4762 8201 |
| 65, rue des Trois Fontanot          |            +33 6 8089 5135 |
| 92732 Nanterre Cedex                |                            |
+-------------------------------------+----------------------------+