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

Thread: tablespace quota

  1. #1
    Join Date
    Dec 2000
    Posts
    9
    How are users able to create records when their tablespace quota is set to none ? I had thought that maybe they used the quota of the schema owner, but I changed that user's quota to none and records could still be created by other users.


  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    It then uses default tablespace USERS.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quotas setting for user A inserting into table of user B is irrelevant. As long as user B has not filled up his quota user A will be able to insert into B's tables.

    If you revoke B's quota, his objects allready created in that tablespace are not affected. As long as there is free space in them all users will be able to insert into them. But once the table fills up, it has to allocate a new extent the next time someone wants to insert a new record. But as there is no quota available for user B, the insert will fail with some ORA error ("... insuficient quota in tablespace ....")

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Dec 2000
    Posts
    9
    Thanks for the help. I could not find any resource which explains this.

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