Re: SQL : informations about occupied data/index

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 19 Sep 2002 21:21:42 GMT
Message-ID: <3D8A3FE1.F434A52F_at_exesolutions.com>


cava123 wrote:

> Hi all,
> I create a table T_STATS (with User SCOTT) and want to store
> 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

We don't do other people's homework assignments for them. Do your research work and then we will give you pointers.

Your pointer d'jour is:

SQL> desc user_segments

Daniel Morgan Received on Thu Sep 19 2002 - 23:21:42 CEST

Original text of this message