Re: dbms_free_space for Oracle 8i (Partitioned Tables/Indexes)

From: Suhen Pather <PatherS5_at_telkom.co.za>
Date: Tue, 24 Oct 2000 12:25:49 +0200
Message-Id: <10659.120025@fatcity.com>

Hi Arun

For partitioned tables you need to put in the partition name after the last variable (OUT)(7th).

desc dbms_space
This will give you the input parameters.

HTH
Suhen

>>> arun_jacob_at_0racledba.com 10/24/00 12:40PM >>>
Hi,

Could you please tell me how to modify the following script for Oracle 8i (Partitioned Tables/Indexes).

Cheers

Arun J

declare

         VAR1 number;
         VAR2 number;
         VAR3 number;
         VAR4 number;
         VAR5 number;
         VAR6 number;
         VAR7 number;

begin
dbms_space.unused_space('OPS$CC1','SPACES','TABLE',

VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7,PARTITION_NAME);

    dbms_output.put_line('OBJECT_NAME       = SPACES');
    dbms_output.put_line('---------------------------');
    dbms_output.put_line('TOTAL_BLOCKS      = '||VAR1);
    dbms_output.put_line('TOTAL_BYTES       = '||VAR2);
    dbms_output.put_line('UNUSED_BLOCKS     = '||VAR3);
    dbms_output.put_line('UNUSED_BYTES      = '||VAR4);
    dbms_output.put_line('LAST_USED_EXTENT_FILE_ID  = '||VAR5);
    dbms_output.put_line('LAST_USED_EXTENT_BLOCK_ID = '||VAR6);
    dbms_output.put_line('LAST_USED_BLOCK   = '||VAR7);

end;

Be someone_at_0racledba.com - get your free mail from Oriole Corporation http://www.oriolecorp.com - Performance tools for Oracle DBAs

Get email for your site ---> http://www.everyone.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Arun Jacob Muthalaly
  INET: arun_jacob_at_0racledba.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 24 2000 - 05:25:49 CDT