Re: SQL : informations about occupied data/index
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