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.
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
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.
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.
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width