DBMS_SPACE package problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_SPACE package problem

  1. #1
    Join Date
    Jul 2001
    Posts
    52

    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

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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 ???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width