Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_SPACE error message
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;
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