Creating a physicalized view produces ORA-600 [KsmovrFlow], [KKZNXDDL.BEGIN] error solution

In the evening test, the physicalized view is copied. The Master Site in the test environment is Oracle10G, and the MV Site is Oracle9201, and when the quick refresh entity view is created on the MV Site, the ORA-600 error is reported.

SQL> CREATE MATERIZED View Kamus.account2004 Refresh Fast With Primary Key As SELECT * from kamus.account2004@orcl;

Create Materialized View Kamus.account2004 Refresh Fast With Primary Key As SELECT * from Kamus.account2004@orcl

ORA-00600: Internal Error Code, Arguments: [KSMOVRFLOW], [KKZNXDDL.BEGIN], [], [], [], [], [], []

Check MetAlink and found that it is a bug, which only occurs when creating an Oracle8 or 9.

the reason:

The name of the primary key is explicitly specified when creating primary buttons in Oracle10g's master table. as follows

ALTER TABLE TABLE_NAME Add Constraint Primary Key ();

Solution:

Delete this primary key, then create a primary key that does not specify a name, automatically naming it by Oracle, as follows

Alter Table Account2004 Add Primault Key (Occurtime, ACCTID, CURRENCYID);

The primary key name thus generated becomes SYS_CXXXX.

Then be re-created on the MV Site, successful.