Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: storage clause help !!!!!

Re: storage clause help !!!!!

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 30 Dec 1999 17:16:30 +0100
Message-ID: <946570665.43.0.pluto.d4ee154e@news.demon.nl>


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
>
>
>
>
Received on Thu Dec 30 1999 - 10:16:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US