increase index tablespace

[grjohnson]

THis is tag team time...

Right, now one of thoise users needs to have their quota increased on the tablespace INDX.

select username, tablespace_name, bytes from dba_ts_quotas
where tablespace_name = 'INDX';


select owner, sum(bytes/1024/1024) from dba_segments
where owner in ('REP1', 'REP2') and tablespace_name = 'INDX'
group by owner;