dbms_space problem

From: Carol L. Stimmel <cstim_at_indra.com>
Date: 1997/08/21
Message-ID: <33FC5E4E.1D2C@advtech.uswest.com>#1/1

Hi,

I'm fairly new to using stored procedures. I have a script that I'm using, but I'm erroring out on my call to the package dbms_space:

I'm not logged in as SYS, but the documentation claims that it is available to PUBLIC. I have verified that the package does exist.

Thanks for any help.

Carol

---

SVRMGR> @ /u/cstimme/oracle/scripts/dba/freespace.sql
SVRMGR> declare
     2>     VAR1 number;
     3>     VAR2 number;
     4>     VAR3 number;
     5>     VAR4 number;
     6>     VAR5 number;
     7>     VAR6 number;
     8>     VAR7 number;
     9>     mod  varchar2(48) := 'freespace';
    10>     act  varchar2(32) := 'unused space';
    11> begin
    12> /*
    13>  Call the Oracle provided package dbms_space
    14> */
    15>   dbms_space.unused_space('OPS$CC1', 'SPACES', 'TABLE',
    16> 			VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7);
    17>   dbms_output.put_line('OBJECT_NAME               = SPACES');
    18>   dbms_output.put_line('----------------------------------');
    19>   dbms_output.put_line('TOTAL BLOCKS              = '||VAR1);
    20>   dbms_output.put_line('TOTAL BYTES               = '||VAR2);
    21>   dbms_output.put_line('UNUSED BLOCKS             = '||VAR3);  
    22>   dbms_output.put_line('UNUSED BYTES              = '||VAR4);
    23>   dbms_output.put_line('LAST_USED_EXTENT_FILE_ID  = '||VAR5);
    24>   dbms_output.put_line('LAST_USED_EXTENT_BLOCK_ID = '||VAR6);
    25>   dbms_output.put_line('LAST_USED_BLOCK           = '||VAR7);
    26> end;
    27> /
ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SPACE", line 37
ORA-06512: at line 15

---

Carol Stimmel

cstimme_at_advtech.uswest.com          	Pager: (303) 234-3059 
U S WEST Advanced Technologies		Phone: (303) 541-6085

Received on Thu Aug 21 1997 - 00:00:00 CDT