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

Thread: negative entry in max blocks cloumn

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69
    when i executed the following query

    select username, tablespace_name,blocks,max_blocks from dba_ts_quotas;

    i got the following result

    USERNAME TABLESPACE_NAME BLOCKS MAX_BLOCKS
    ----------
    SCOTT SYSTEM 128 512

    ADMIN1 TEMP 0 -1

    ADMIN1 ts_amb 0 640

    in the temp tablespace i ve an entry for max_blocks as -1.
    what does it mean. can anyone explain me.

    thanks in advance.

    regards

    swaminathan

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    It means that the user has UNLIMITED resource on that tablespace
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    -1 means unlimitted quota.

  4. #4
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69

    thanks

    thanks

    swaminathan

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