[OAUGNetDBA]-ORA-600 [kkzdgdefq] While Compiling Materialized View

["Plesa, Carol" <Carol.Plesa@Garlock.com>]

Has anyone seen this error message before (ORA-600 [kkzdgdefq] While
Compiling Materialized View)?   The situation at our company is we are
running a 10g (10.1.2) application server with version 10.1.0.4.2
database running discoverer and portal application on Linux, with
numerous materialized view refreshes across a database link connecting
to our 9.2.0.3 oracle applications database running on IBM AIX.    There
is one materialized view we can create just fine, but the next day when
the data attempts to automatically refresh we see the following error in
our alert log: "ORA-00600: internal error code, arguments: [kkzdgdefq],
[5], [2224], [67760], [], [], [], []".  When you view the job it appears
that it's still trying to run.

	Oracle support says we are running into note 300382.1 where the
materialized view refresh definition is greater than 64k.  This is a
large query; what's confusing is we're running the same query
successfully on a 9.0.4.1 application server version with a 9.0.1.5
database with a database link connecting to same 9.2.0.3 database.
Oracle support can't really explain why it works today but won't run
successfully on 10g.  They believe it might be the characterset.  The
characterset in 9.0.1.5 is WE8MSWIN1252, in 9.2.0.3 it's UTF8, and 10g
database it's AL32UTF8.  Oracle is suggesting that I convert the 10g
database to same characterset as the existing 9.0.1.5 if it's
doable/allowable (and depending on the data we're storing) to see if I
can get around the problem.
	Oracle's best recommendation is to reduce the size of the
materialized view to less than 64k.
	 
	Has anyone experienced this problem before?  Does anyone have a
better theory as to why the query might be working today and it doesn't
in 10g version?  Could it be caused by the difference in charactersets?
Any help or explanation to this would be greatly appreciated.  Thank
you.
	 
	Carol Plesa
	carol.plesa@garlock.com <mailto:carol.plesa@garlock.com> 
	Garlock Sealing Technologies LLC 


----------Legal Disclaimer----------
The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee.  No other person is authorized to access, copy or re-use this message (or any information contained herein).  If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>