%USED, %FREE in TABLESPACES

From: <cava123_at_noos.fr>
Date: Wed, 18 Sep 2002 00:29:57 +0200
Message-ID: <3d87a8e7$0$7454$79c14f64@nan-newsreader-03.noos.net>

Hi all,
I need informations about the volume of data in my base and how the data are distributed in their assigned space
(I mean only users data not system, sys)
Suppose that I have DATA_1 (default TS for user scott tables) and INDEX_1
(tablespace which scott create indexes).

The purpose is to know how data is grow up in the database : For know I need to extract the informations in day 1 and apply the same sql script for (day + 15)

USER          TS NAME         SIZE            USED         FREE
-------        --------------      ---------      --------       ---------
SCOTT          DATA_1        200 MB        170 MB      30 MB
SCOTT          INDEX_1        100 MB       60               40 MB

Any help.
Thank You

Yhab Abiad
yhab.abiad-sica_at_renault.com Received on Tue Sep 17 2002 - 17:29:57 CDT