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
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: 22839
Registered: January 2009
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
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: 59289
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
Previous Topic: problem in creating view
Next Topic: Gather schema statistics
Goto Forum:
  


Current Time: Wed Oct 01 06:56:33 CDT 2014

Total time taken to generate the page: 0.09412 seconds