Urgent!!! Materialized view in 9i
I have created a materialized view in oracle 220.127.116.11.0, which the master table is in oracle 7.3.4. And there are other materialized view created from this materialized view in other database. Then I add a field in th master table and want to re-create the materialized view. However, after I have dropped the materialized view and re-create it, error "end of file communcation" occurs. And the following is the trace file details:
Oracle9i Release 18.104.22.168.0 - 64bit Production
JServer Release 22.214.171.124.0 - Production
ORACLE_HOME = /opt/oracle
System name: SunOS
Redo thread mounted by this instance: 1
Oracle process number: 10
*** 2003-11-03 14:23:22.944
*** SESSION ID:(9.692) 2003-11-03 14:23:22.926
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1018d9964, 00000001018D9964]
*** 2003-11-03 14:23:22.947
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [00000001018D9964] [SIGSEGV] [Address not mapped to object] [0x000000000]  
Does anyone knows what happen?
Thank you very much!
try upgrading to 126.96.36.199 .
There was a bug fixed in first release of 9.2 - Dump on CREATE SNAPSHOT/MVIEW with ROWID for remote table.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
Click Here to Expand Forum to Full Width