1 person found this helpful
That error regarding temp space.
Check the value for below query.
SELECT tablespace_name, round(sum(BYTES)/power(2,20)) TOTAL_MB
where TABLESPACE_NAME = 'APPS_TS_ARCHIVE'
group by TABLESPACE_NAME;
If total_mb is less, then increase it. Give atleast 4096 mb.
Also see below docs for reference
Note: 151994.1 - Overview Of ORA-01653: Unable To Extend Table %s.%s By %s In Tablespace %s
Hope this will help you...
Thank you very much Jagadekara,
This is very helpful, I extended the memory and it worked FINE.
I can now log in. thank you so much.