SQL : informations about occupied data/index

From: cava123 <cava123_at_noos.fr>
Date: Thu, 19 Sep 2002 22:40:58 +0200
Message-ID: <3D8A365A.D3C90100_at_noos.fr>

Hi all,
[Quoted] [Quoted] I create a table T_STATS (with User SCOTT) and want to store [Quoted] informations about occupied data/index in TS like this :

USER TS NAME SIZE (MB) USED FREE STATS_DATE

-------      --------------      ---------      ----------
-------       --------------
SCOTT        DATA_1          200 MB        50 MB        150 MB
24/04/2000
SCOTT        INDEX_1        100 MB         40  MB       60 MB
24/04/2000
SCOTT        DATA_1          200 MB        100 MB      50 MB
24/04/2001
SCOTT        INDEX_1        100 MB         60   MB      40 MB
24/04/2001
SCOTT        DATA_1          200 MB        170 MB       30 MB
24/04/2002
SCOTT        INDEX_1        100 MB          60 MB        40 MB

24/04/2002

Someting look like :
INSERT INTO SCOTT.T_STATS VALUES (SELECT .............., sysdate from xxx where ....) ;

I dont know how to write the request.
Thanks for help.
I'm simple user in the database and have no grants for dba_% or V$%,

Yhab
yhab.abiad-sica_at_renault.com Received on Thu Sep 19 2002 - 22:40:58 CEST