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.
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.
-1 means unlimitted quota.
Click Here to Expand Forum to Full Width