Home » RDBMS Server » Enterprise Manager » default quota on tablespace for user (oracle 9i , solaris)
default quota on tablespace for user [message #312679] Wed, 09 April 2008 10:40 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Hi All,

I'm using OEM 9i to create a user with default tablespace USERS without quota on this tablespace.
This new user have only connect GRANT.
When having a look on the quota for this user I notice that
it's none quota on this tablespace( of course) .

So My question is : NONE QUOTA means UNLIMITED QUOTA ?

thanks for Answer.
koff
Re: default quota on tablespace for user [message #312686 is a reply to message #312679] Wed, 09 April 2008 10:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Default quota is 0.
Now what does OEM display, I don't know.
"Those who live by the GUI, die by the GUI."

Query DBA_TS_QUOTAS to know how OEM handles this.

Regards
Michel
Re: default quota on tablespace for user [message #312689 is a reply to message #312686] Wed, 09 April 2008 10:49 Go to previous messageGo to next message
harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles
Junior Member
By default, a user has no quota on any tablespace in the database. If the user has the privilege to create a schema object, you must assign a quota to allow the user to create objects. Minimally, assign users a quota for the default tablespace, and additional quotas for other tablespaces in which they can create objects.

Re: default quota on tablespace for user [message #312713 is a reply to message #312679] Wed, 09 April 2008 11:40 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:

"Those who live by the GUI, die by the GUI."


Thats a nice statement but then why Oracle recommends to use OEM.
Re: default quota on tablespace for user [message #312724 is a reply to message #312713] Wed, 09 April 2008 11:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle recommends what is returning back money not what is best.

The sentence is from Ana (anacedent).

Regards
Michel

[Updated on: Wed, 09 April 2008 11:54]

Report message to a moderator

Re: default quota on tablespace for user [message #312864 is a reply to message #312679] Wed, 09 April 2008 23:52 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
So My question is : NONE QUOTA means UNLIMITED QUOTA ?


None means zero, i.e no quota. And unlimited is no limit.
Previous Topic: emctl start dbconsole fails
Next Topic: Restoration EM after database is restored
Goto Forum:
  


Current Time: Fri Mar 29 01:54:49 CDT 2024