关于使用SHOW_SPACE()

Yong Huang

原帖由 doi17 于 2008-7-29 01:33 发表
39楼出现的这个Operation not allowed on this segment这个报错


SQL>  exec show_space('TEST');
BEGIN show_space('TEST'); END;

*
ERROR 位于第 1 行:
ORA-10618: Operation not allowed on this segment
ORA-06512: 在 "SYS.DBMS_SPACE", line 152
ORA-06512: 在 "TEST.SHOW_SPACE", line 22
ORA-06512: 在 line 1

怎么解决啊？！？

http://yong321.freeshell.org/oranotes/Dbms_Space.txt

SQL> select segment_space_management from dba_tablespaces where tablespace_name =
  2  (select tablespace_name from user_tables where table_name = 'TEST');

SEGMEN
------
MANUAL  <-- AUTO would cause dbms_space.free_blocks to throw ORA-10618 (Operation not allowed on this segment)
        If AUTO, use dbms_space.space_usage instead to get space usage below HWM.

Yong Huang

Orasource

mark 一下

听海★蓝心梦

谢谢啊，真是太及时 了

radwimps

[]\EWAJKLX

丢勒嘚记忆

赞一个先，正好要用到高水位的东西