Skip to Content
0
Former Member
Jul 10, 2007 at 10:28 AM

Error at "spacechk_ini" phase with SQL ERROR 942: ORA-00942

21 Views

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

  1. 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