8.1.6 cloned with 8.1.7 database; v$ views and tables missing or corrupt
Posted on 2004-04-17
We have 2 environments DEV and PROD.
DEV (target) was accidentally cloned with PROD (source). Now DEV's database is in a mess. I cannot run catalog.sql or catproc.sql to fix the system tables/views. They just hang. My questions:
1. Is there a way to fix system's tables/views ?
I tried to run hcheck diagnostic script and I get the following error:
SQL> execute hcheck.full
BEGIN hcheck.full; END;
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: , , , , , , ,
ORA-06553: PLS-801: internal error 
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.HOUT", line 18
ORA-06512: at "SYS.HCHECK", line 1078
ORA-06512: at line 1
2. Is there a way I can copy/clone DEV again or can I just replace DEV's DB files with PROD's ?
I just want to fix DEV database so that I can upgrade the application from 11.5.3 to 11.5.7.