Home » RDBMS Server » Server Administration » Quota on tablespace
Quota on tablespace [message #52456] Tue, 23 July 2002 05:29 Go to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
I want to give access to 75% of a tablespace to a user, is this possible ?

My choices are (which I know works)

... quota unlimited on users ...
... quota 500M on users ...

But let's say I have users (1000M) and I want to allocate only 75% of this. Let's say by next year, users becomes 2000M, then still I want to allocate 75%. Is there any command like this that works

... quota 75 percent on users ... ???? (or something close to that).

Just curious.

Report message to a moderator

Re: Quota on tablespace [message #52458 is a reply to message #52456] Tue, 23 July 2002 07:24 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
No. You will have to grant 750M now and when you bump it up to 2G you will have to give 1.5G to the user.

Report message to a moderator

Previous Topic: DBA Password
Next Topic: DBA General questions:: New at this
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 18 21:38:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.