increasing tablespace quota
977650Feb 22 2013 — edited Feb 22 2013Hi
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?