Error at "spacechk_ini" phase with SQL ERROR 942: ORA-00942
Dear support,
I am posting this problem again in upgrade forum as i am still dont have proper answer.
We are performing upgrade from 4.0B (4.0B Ext kernel level 996 , windows 2000 Oracle 9.2.0.5 ) to 4.7 Ext 2.00 SR1. I have upgraded my database from 8.1.7.4 to 9.2.0.5 as prerequisite for upgrade.
While performing Initialization module we got below error
" No DB freespace check possible code -4 "
When i analyzed slog found below error
Phase SPACECHK_INI:
ERROR: Statement: SELECT "TABLESPACE_NAME", "BYTES"/1048576 FROM SYS."DBA_TEMP_FILES" WHERE "BYTES" >= 1048576
ERROR: SQL ERROR 942: ORA-00942: table or view does not exist
ERROR: Statement: SELECT "TABLESPACE_NAME", "BYTES"/1048576 FROM SYS."DBA_TEMP_FILES" WHERE "BYTES" >= 1048576
ERROR: ERROR 256: invalid cursors id
ERROR: SQL ERROR 942: ORA-00942: table or view does not exist
have observed one more thing at my database ( which is now upgraded to 9.2.0.5 as prerequisite for upgrade to 4.7)
select * from dba_temp_files;
no rows selected.
But when i run same querry to my another server which is 4.7 oracle 9.2.0.5 i get output as list of datafiles with PSAPTEMP tablespace.
I think problem might be this fixed tables/view dba_temp_files is showing no rows as PSAPTEMP tablespace.Also we cannot add any value to this table as it is fixed tabel/view.
How we can troubleshoot this?
I would also like to inform in my 40 B database PSAPTEMP tablespace is dictionary managed after upgrade to 9.2.0.5 but
In another server which is 4.7 9.2.0.5 , PSAPTEMP tablespace is locally managed
May be this is the problem why my dba_temp_files showing nothing.
Do i need to perform DMTS to LMTS for psaptemp tablespace.so that my dba_temp_files view will show me psaptemp tablespace under it?
Can anybody suggess something on the same at earliest ?
Best Regards,
AjitR