DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001

    Urgent!!! Materialized view in 9i

    Dear all,
    I have created a materialized view in oracle, 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 - 64bit Production
    JServer Release - 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!

  2. #2
    Join Date
    Nov 2000
    try upgrading to .
    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

Click Here to Expand Forum to Full Width