|
-
Urgent!!! Materialized view in 9i
Dear all,
I have created a materialized view in oracle 9.0.1.1.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 9.0.1.1.0 - 64bit Production
JServer Release 9.0.1.1.0 - Production
ORACLE_HOME = /opt/oracle
System name: SunOS
release: 5.8
Version: Generic_108528-11
Machine: sun4u
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!
_____________________________
Loren
-
try upgrading to 9.2.0.4 .
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote