I have seen that error quite a few times unfortunately. As none of the MV were created with '*' and used only column names, that fix would not have helped much. The only fix was going to Patch Level 15+ IIRC. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com On Tue, Dec 22, 2009 at 7:04 AM, Pankaj Jain <pjain@xxxxxxxxxx> wrote: > replace the "select * " from the MV and the queries with the actual > column name. and you will not receive the 7445 error again , this is a > reported bug and tar is available on metalink. I think it is restricted and > not available to all. > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Balakrishna Y > *Sent:* Tuesday, December 22, 2009 4:55 AM > *To:* dennis@xxxxxxxxxx > *Cc:* oracle-l@xxxxxxxxxxxxx > *Subject:* Re: ORA-07445: exception encountered: core dump > [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x77E7F348] [ADDR:0x7D44] > [UNABLE_TO_WRITE] [] > > Hi, > > Yes i have seen there is some DLL file .. in the trace files but what do > with that .. Thats the question . > > Regards > > Bala > > On Tue, Dec 22, 2009 at 3:16 PM, Dennis Yurichev <dennis@xxxxxxxxxx>wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Balakrishna Y wrote: >> > I have Oracle 10g(10.2.0.4) on my local machine (Windows XP) . when ever >> > i start the database on my machine it start throwing this Error. >> > >> > ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] >> > [unable_to_trans_pc] [PC:0x77E7F348] [ADDR:0x7D44] [UNABLE_TO_WRITE] [] >> > >> > >> > Even metalink does'nt have much supporting documents on this issue. Does >> > any one came across this problem.I appreciate your comments on this. >> >> "unable_to_trans_pc" mean "unable to translate PC (program counter)" >> mean that address (0x77E7F348 in your case) cannot be resolved to >> function name. >> >> Look at trace files, Oracle dump there loaded win32 modules at the >> moment of exception. Address 0x77E7F348 cannot be in oracle.exe, it >> should be in some DLL. >> >> >> >> - -- >> My PGP public key: http://yurichev.com/dennis.yurichev.asc >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.4.8 (MingW32) >> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ >> >> iEYEARECAAYFAkswlYEACgkQ1YPmFmJG++NJPwCbBrUXLv3TJfdbJoazlIy1Vnhp >> amMAmweuRYu2kwz2scUPiTnL6H8E5VnW >> =zkws >> -----END PGP SIGNATURE----- >> > >