Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

increasing tablespace quota

977650Feb 22 2013 — edited Feb 22 2013
Hi

i have a requirement in which i need to increase tablespace size for my schema. actually the tablespace that is given to me is shared by many other 'owners' too but i want the datasize just for me to be increased.

SELECT OWNER,TABLESPACE_NAME,SUM(BYTES/1024/1024) "Allocated Size in MB"
FROM DBA_SEGMENTS WHERE TABLESPACE_NAME = 'DATA_TS1'
GROUP BY OWNER,TABLESPACE_NAME ORDER BY OWNER;

will give this result


OWNER | TABLESPACE_NAME| Allocated Size in MB

30026882 | DATA_TS1 | 170.9375
30042534 | DATA_TS1 | 0.1875
myself | DATA_TS1 | 106951.875

now how can i just increase quota for 'myself'?

Can this be done? and if so can you plz provide me with syntax?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2013
Added on Feb 22 2013
4 comments
778 views