关于dbms_space.free_blocks?

Question

我想用这个包可是报错?
PLS-00306: ?? 'FREE_BLOCKS' ??????????
   16
PL/SQL: Statement ignored
   23
PLS-00306: ?? 'UNUSED_SPACE' ??????????
   23
PL/SQL: Statement ignored

Answer 1

1、看看你有没有 EXECUTE 权限2、确定你提供的输入、输出参数没有问题
PROCEDURE FREE_BLOCKS
参数名称                       类型                    输入/输出默认值？
------------------------------ ----------------------- ------ --------
 SEGMENT_OWNER                  VARCHAR2                IN
 SEGMENT_NAME                   VARCHAR2                IN
 SEGMENT_TYPE                   VARCHAR2                IN
 FREELIST_GROUP_ID              NUMBER                  IN
 FREE_BLKS                      NUMBER                  OUT
 SCAN_LIMIT                     NUMBER                  IN     DEFAULT
 PARTITION_NAME                 VARCHAR2                IN     DEFAULT