dbms_free_space for Oracle 8i (Partitioned Tables/Indexes)

From: Arun Jacob Muthalaly <arun_jacob_at_0racledba.com>
Date: Tue, 24 Oct 2000 02:39:18 -0700 (PDT)
Message-Id: <10659.120024@fatcity.com>

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);
    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 Received on Tue Oct 24 2000 - 04:39:18 CDT