-
Dear Friend
i am running following progr.
declare
VAR1 number;
VAR2 number;
VAR3 number;
VAR4 number;
VAR5 number;
VAR6 number;
VAR7 number;
begin
dbms_space.unused_space('OPS$CC1','SPACES','TABLE',
VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7);
dbms_output.put_line('OBJECT_NAME = SPACES');
dbms_output.put_line('---------------------------');
dbms_output.put_line('TOTAL_BLOCKS = '||VAR1);
dbms_output.put_line('TOTAL_BYTES = '||VAR2);
dbms_output.put_line('UNUSED_BLOCKS = '||VAR3);
dbms_output.put_line('UNUSED_BYTES = '||VAR4);
dbms_output.put_line('LAST_USED_EXTENT_FILE_ID = '||VAR5);
dbms_output.put_line('LAST_USED_EXTENT_BLOCK_ID = '||VAR6);
dbms_output.put_line('LAST_USED_BLOCK = '||VAR7);
end;
when i am executing above program it is giving following error.
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SPACE", line 40
ORA-06512: at line 10
even i had chekced dba_object view which is showing
dbms_space package with status as a valid.
even i had recompiled the package then also same error
is displaying.
what will be the solution.
Rakesh Sanghvi
-
under which account do you run your program ?
is the table SPACES accessible from the account you use ?
do you have the right to ANALYZE this table ???
