Oracle Database Discussions

Hi All,

After a DB upgrade from Oracle 8.1.7 on Sun Sparc to Oracle 9.2.0.8 on Sun Sparc , the following error message popup .


SQL> select * from DBA_TEMP_FILES
where file_name like '/idea_03%'

ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-01187: cannot read from file 230 because it failed verification tests
ORA-01110: data file 230: '/idea_03/oradata/idea/IBI_ENTERPRISE_TMP41.dbf'

Even for Alter system command

SQL> Alter system set Undo_retension=900 scope=spfile;
Alter system set Undo_retension=900 scope=spfile
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-02065: illegal option for ALTER SYSTEM

It seems my Dictionary views is having a problem. But unable to find out exact problem. Seek your help on this.

Cheers
Kanchana.