User quotas on tablespace
590115Jul 30 2007 — edited Jul 31 2007Hi,
I created a tablespace and made it default to a user. immediateley i issued a command to apply a quota 0m for that user to that tablespace.Now when i am trying to create a table by logging on that newley created user and inserting the table on that tablespace i am able to do that no error. can any one say why it is happening? if i repeated the inserting operation after some time i get the error message of quota full.remember that i have already inserted arround 10000 of rows on that table which has only 2 columns on it.
thx
pradeep