Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    35

    Unanswered: can i use the list tablespaces command in a procedure

    i need to find the total free spaces in MB in a tablespace.
    can i use the list tablespaces command in a store procedure, or is their a query i can use instead?

    10x
    Ronen

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I don't think you can execute LIST TABLESPACES from a procedure. However, you can query SYSCAT.TABLESPACES to retrieve the information you need.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you are on Version 8 , you can use the SNAPSHOT_TBS_CFG table function
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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