DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DBMS_SPACE package

  1. #1
    Join Date
    Jan 2001
    Posts
    20

    Question

    Dear All,

    I would like to use the DBMS_SPACE package to return information about the position of the high water mark and the amount of unused space in a segment. However, I don't know how to execute the DBMS_SPACE package with sql*plus.
    Could you pls help me out? Thank you!!

    I am facing a problem as below, (login sys/**** as sysdba)
    SQL> execute
    DBMS_SPACE.UNUSED_SPACE
    ('SCOTT', 'EMP', 'TABLE', :total_blocks,
    :total_bytes,:unused_blocks, :unused_bytes);
    Error>
    SP2-0552: Bind variable "UNUSED_BLOCKS" not declared.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to declare variables to handle the results which will pass to :unused_blocks for example

  3. #3
    Join Date
    Jan 2001
    Posts
    20

    Question

    Dear Pando,

    Could you give me an example of that? Thanks a lot!!
    Actually, I am not familiar with the SQL statememt as above.
    I just copy it from the 8.1.7 Doc..... All I am concerned is how to execute the DBMS_SPACE package for specific user's objects.

    Sorry that I am kind of new in this field, thus, I do need your explanation in more details. Thank you!!

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    variable unused_blocks number
    variable .... blah blah

    execute DBMS_SPACE.UNUSED_SPACE ('SCOTT', 'EMP', 'TABLE', :total_blocks, :total_bytes,:unused_blocks, :unused_bytes);

    print unused_blocks shows the value



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