Re: storage clause help !!!!!

I'm interpreting the original question as I want to have an overview of all storage clauses I applied to my database.

As he could have applied one storage clause multiple times and an union on dba_tables and dba_indexes probably is to cumbersome, I choose dba_segments and the distinct.

Regards,

--
Sybrand Bakker, Oracle DBA

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:386B3424.274D_at_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 - 13:01:21 CST