System Tablespace QUOTA Exceeded!URGENT!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: System Tablespace QUOTA Exceeded!URGENT!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi All!

    1.My SYSTEM tablespace quota has exceeded.Should I increase the maxextents to rectify the problem!What is the approach for this!Why is this happening!

    2.How do I change the date Formatin Oracle to 2001 as whenever my end users type in D2k Forms Applications date:08-JUL-2001,Oracle accepts it as 08-JUL-001.

    I do not want 001 by 2001 instead.

    Anything I could do with NLS_DATE_FORMAT in INIT.ORA file.

    Any Hints.

    Regards,

    Amitstora.



  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    quota is per user not per tablespace, you probably have some user's default tablespace as system which is not good users except SYS shouldnt use tablespace system

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    Hi

    when you create a user you set up his defoult table space and him defoult temp table space. pando is right, what i want do ad is that i think that in your case, when you created your user you did not set the temp table space as well. check it.


  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    set the NLS DATE to be

    ALTER SYSTEM SET NLS_DATE_FORMAT="DD-MON-YYYY";

    This would alter the date format on your current system. You could then make the changes in the init.ora file. You wouldn't have to restart the system.

    If you would like to keep this local to the session then in the session you could say,

    ALTER SESSION SET NLS_DATE_FORMAT="DD-MON-YYYY";

    As a pando mentioned, quota is local to the user, so you as a dba can alter the quota for the user as

    ALTER USER user-name QUOTA UNLIMITED/new-value ON tablespace-name;


    Hope these would help you.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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