increase index tablespace - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: increase index tablespace

  1. #11
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    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
    -nagarjuna

  2. #12
    Join Date
    Dec 2002
    Posts
    62
    The out put is
    USERNAME TABLESPACE_NAME BYTES
    ------------------------------ -------------------------- --------
    rep1 USERS 419164160
    rep2 USERS 423403520
    2 rows selected.

  3. #13
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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;
    Last edited by grjohnson; 12-10-2002 at 11:03 PM.
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #14
    Join Date
    Dec 2002
    Posts
    62
    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.

  5. #15
    Join Date
    Dec 2002
    Posts
    62
    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.

  6. #16
    Join Date
    Dec 2002
    Posts
    62
    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

  7. #17
    Join Date
    Dec 2002
    Posts
    62
    any body please help
    Thanks

  8. #18
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    stop spam would you?

  9. #19
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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.
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width