Tags: 10gr1, 1ora-12801, adstats, adstatssql, database, error, haveerror, launching, line, mysql, oracle, p000ora-01652, parallel, query, server, signaled, sql, upgrading
after upgrading from 9i to 10gR1, launching adstats.sql I have
ERROR at line 1:
ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-06512: at "SYS.DBMS_STATS", line 12440
ORA-06512: at "SYS.DBMS_STATS", line 12766
ORA-06512: at "SYS.DBMS_STATS", line 12842
ORA-06512: at "SYS.DBMS_STATS", line 12802
ORA-06512: at line 3
ORA-06512: at line 16
Would you please help me ?
Leave a comment...
- 3 Comments
- Your temp tablespace is got full. Add more space to it.
Thanks#1; Fri, 22 Feb 2008 16:09:00 GMT
- Thank you. How can I be sure that I have at least 1.5 GB of free default temporary tablespace". ?
Thank you again.#2; Fri, 22 Feb 2008 16:10:00 GMT
- Check in DBA_FREE_SPACE , DBA_TABLESPACES view.
Thanks#3; Fri, 22 Feb 2008 16:11:00 GMT