select pct_used
from all_tables
where owner = 'TABLE_OWNER'
and table_name = 'TABLE_NAME'
;
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ilia Bashtanov
iliab_at_mmc.ru
phone +7 (095) 974 30 30
fax +7 (095) 974 30 20
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thomas Kremer <Thomas.Kremer_at_orechem.NOSPAM.com> wrote in article
<334e7a93.10558081_at_news.superlink.net>...
> Hi,
>
> how can I display the value of PCTUSED of a table in oracle. I know
> how to set it, but I would like to know how to see the actual value?
>
> Thanks a lot
>
Received on Mon Apr 14 1997 - 00:00:00 CDT
