| Monu |
Posted: Jun 07, 2008 03:04:29 AM |
Total Post: 26
Joined: Jan, 2008
|
Hi all,
How can i release space allocated to users. One user is assigned 6GB space and he is utilizing only 300m of that. I altered the quota using for that user using
alter user abc quota 2048m on users;
but this is not releasing the space at all.
can anyone suggest me what to do?
Waiting for reply..... |
|
|
 fozturk |
| Posted: Jun 08, 2008 03:55:14 PM |  |
|
Total Post: 69
Joined: Sep, 2007
|
as i understand frmo your message, you watnt o decrease the size of one of the datafiles in your db, if i m right, you need to use shrink command otherwise oracle wont release the space allocated already. google the "shrink" command...
|
|
|
|
|
| positive |
| Posted: Jun 26, 2008 03:53:31 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
sql>select tablespace_name,username,bytes from dba_ts_quotas where username='username';
to get details on tablespace quota
Enable row movement:
sql>alter table tablename enable row movement;
sql> alter user username quota 500m on tablespace;
Get the details on the objects owned by user:
sql>select * from dba_objects where username='username';
get the list and shrink the objects using:
sql>alter table/index/materialized view <object-name> shrink spacee;
|
|
|
|
|
| positive |
| Posted: Jun 26, 2008 03:54:05 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
Hi,
refer the link below for more details:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.htm#ADMIN10161
|
|
|
|
|
| Monu |
| Posted: Jun 26, 2008 10:14:12 PM | |
|
Total Post: 26
Joined: Jan, 2008
|
|
|
|
|
| positive |
| Posted: Aug 11, 2008 08:49:17 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
