Urgent!!! Materialized view in 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Urgent!!! Materialized view in 9i

  1. #1
    Join Date
    Oct 2001
    Posts
    34

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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
  •  


Click Here to Expand Forum to Full Width