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
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.