Home » RDBMS Server » Server Administration » user quota issue (2 Merged) (11.2.0.1 windows xp)
user quota issue (2 Merged) [message #530704] Wed, 09 November 2011 21:33 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I was confused by the quota of user,if i set the user quota 1m on test,does it the user can only use 1m space in tablespace test.


Alter User hxl quota 1m on test

Report message to a moderator

Re: user quota issue [message #530706 is a reply to message #530704] Wed, 09 November 2011 22:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
why should I write here when already written at URL below?

please Read The Fine Manual

http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/statements_4003.htm#i2058207

Report message to a moderator

Re: user quota issue (2 Merged) [message #530707 is a reply to message #530704] Wed, 09 November 2011 23:02 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
andy huang wrote on Thu, 10 November 2011 04:33
Dear all,
I was confused by the quota of user,if i set the user quota 1m on test,does it the user can only use 1m space in tablespace test.


Alter User hxl quota 1m on test


Assuming you read the documentation, is this not a kind of silly question?

Regards
Michel

Report message to a moderator

Previous Topic: problem in creating view
Next Topic: Gather schema statistics
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 03:29:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.