increase index tablespace

[nagarjuna]

hey man, the error is all about user npt having much quota on the tablespace. The error is not because of tablespace not having space.. That's why I was dealing with dba_ts_quotas view. Pls do give me the output.. make it ASAP as my night shift ends now and I may leave as soon as my reliever comes

[ayushsingh]

The out put is
USERNAME TABLESPACE_NAME BYTES
------------------------------ -------------------------- --------
rep1 USERS 419164160
rep2 USERS 423403520
2 rows selected.

[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;

[ayushsingh]

I run this query but i get this

SVRMGR> select username,tablespace_name,bytes from dba_ts_quotas where tablespac
e_name='INDX';
USERNAME TABLESPACE_NAME BYTES
------------------------------ ------------------------------ ----------
0 rows selected.

[ayushsingh]

and the second query also returns o rows

SVRMGR> select owner,bytes from dba_segments where owner in (REP1','REP2') and tablespace_name='INDX';
OWNER BYTES
------------------------------ ----------
0 rows selected.

[ayushsingh]

Hi Nagarjuna,
Sorry I was late yesterday to post the query.
I have posted the query result can you please tell me where the problem is.
Thanks

[ayushsingh]

any body please help
Thanks

[pando]

stop spam would you?

[grjohnson]

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

Just to find what users have already created objects in the INDX tablesapce. Of cousre, this won't be helpful if the user TRYING to create an object has ZERO quote already. Usially when an import is occuring it'll sy "Importing objects... " in the log, you need to see which user is having the problems inmporting. Then take it from there. I.e., changed that user's quota for the INDX tablespace.