dear tom, what could be wrong here? july 24, 2003
reviewer: saminathan seerangan from nj,usa
tom, i am not able to use show_space procedure. please help me out. sql> create user a identified by a; user created. sql> grant create session, create procedure, 2 create table to a; grant succeeded. sql> alter user a quota unlimited on users; user altered. sql> connect a/a connected. sql> @d:\share\oracle\asktom\show_space.sql 51 / procedure created. sql> create table t ( x int ) tablespace users; table created. sql> exec show_space( 't' ) begin show_space( 't' ); end; * error at line 1: ora-10618: operation not allowed on this segment ora-06512: at "sys.dbms_space", line 74 ora-06512: at "a.show_space", line 22 ora-06512: at line 1 sql> desc t name null? type ------------------------------------- -------- -------- x number(38) sql> insert into t values(100); 1 row created. sql> desc dbms_space procedure free_blocks argument name type in/out default? ------------------------------ ----------------------- ------ -------- 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 procedure space_usage argument name type in/out default? ------------------------------ ----------------------- ------ -------- segment_owner varchar2 in segment_name varchar2 in segment_type varchar2 in unformatted_blocks number out unformatted_bytes number out fs1_blocks number out fs1_bytes number out fs2_blocks number out fs2_bytes number out fs3_blocks number out fs3_bytes number out fs4_blocks number out fs4_bytes number out full_blocks number out full_bytes number out partition_name varchar2 in default procedure unused_space argument name type in/out default? ------------------------------ ----------------------- ------ -------- segment_owner varchar2 in segment_name varchar2 in segment_type varchar2 in total_blocks number out total_bytes number out unused_blocks number out unused_bytes number out last_used_extent_file_id number out last_used_extent_block_id number out last_used_block number out partition_name varchar2 in default sql>
| bookmark review | bottom | top |