DBMS_SPACE error message

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 22 Nov 1999 01:43:21 GMT
Message-ID: <38399ce2.3763075@172.16.7.5>

Hello all,
I have an error message during executing DBMS_SPACE package

I log on database with SQL*Plus by SCOTT / TIGER Execute following scripts:

SQL > set serveroutput on
SQL > declare

                total_blocks              number;
                total_bytes               number;
                unused_blocks             number;
                unused_bytes              number;
                last_used_extent_file_id  number;
                last_used_extent_block_id number;
                last_used_block           number;
            begin

dbms_space.unused_space('SCOTT','EMP','TABLE',total_blocks,total_bytes,

unused_blocks,unused_bytes,last_used_extent_file_id,

last_used_extent_block_id,last_used_block);
               dbms_output.put_line(total_blocks);
               dbms_output.put_line(total_bytes);
           end;

SQL > /
BUT return the error :

ORA-03200: the segment type specification is invalid

But EMP is a table,and I tried an INDEX segment,returned the same error. Does anybody know why?

Thanks for any tips.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Sun Nov 21 1999 - 19:43:21 CST