| user quota on tablespace [message #63376] |
Thu, 30 September 2004 03:16  |
Sanjeev Suri
Messages: 11
Registered: September 2004
|
Junior Member |
|
|
Q1. why the dba can alter the quota of a user from 1 m to 1k even if the user has objects having space more then 1k.
Q2. how can dba specify quota for the tablespace to a user even if which is not allocated to the user
|
|
|
|
| Re: user quota on tablespace [message #63380 is a reply to message #63376] |
Thu, 30 September 2004 04:17  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
1)whenever a space is allocated to the user on a tablespace and after that if a user creates any object in that tablespace then server will allocates teh space to that object in form of extents(contigious set of blocks)let us take 10 extents is allocated for a segments when your database block size 4k then your total size will be 10*8192.
now here, whatever the space is allocated for any objects in a tablespace that will remain there itself even a DBA says zero quota on that tablespace, u user can work with objects(insert/update/delete)till the allocated space for those object become full.
after saying zero or 1k to the user quota on a tablespace it means a user cannot create new objects,b.cos from this time no new allocation of extents will be done.
2)allocating tablespace means every created user will have one default tablespace at a time, even though u won't assign the default tablespace to the user server will assign once a user is having default tablespace then if a DBA wants he/she can give a space on other tablespace without assigning him.Assigning is required for default tablespace but not to non-default tablespace
Pls refer to oracle material regarding creating a user topics
Regards
D.Dilip
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
