Re: dbms_space problem

Sorry to follow up my own message. As soon as I posted I saw my error. Sorry for the wasted bandwidth...

That's what I get for trying a procedure from a book ;-)

Carol

Carol L. Stimmel wrote:
>
> 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
 

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