RE: Simple Quota Question - ignore this

Ok, ignore this.
The user did not have Unlimited tablespace. All is well.

-----Original Message-----

From: Ted Coyle [mailto:oracle-l_at_webthere.com] Sent: Wednesday, November 21, 2007 11:02 AM To: Oracle-L Freelists
Subject: Simple Quota Question

Issue:

1. Every user granted unlimited tablespace 2. No quotas on any user.
2. All defaults are unlimited
3. User creates table in non-default tablespace.
4. Gets ORA-01536: space quota exceeded for tablespace

Fix:
Admin alters user quote unlimited on non-default tablespace No error.

Question:
I'm forgetting, isn't unlimited tablespace supposed to cover this system wide?

Is zero quota assumed if not granted on non-default tablespaces?

Disclaimer:
Yes, simple dumb questions, but it's a holiday week and my brain is already on vacation.

Ted

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 21 2007 - 10:19:37 CST