-
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.
-
It then uses default tablespace USERS.
Thanks
Kishore Kumar
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|