Create a materialized view to produce ORA-600 [Ksmovrflow], [Kkznxddl.begin] Error resolution

Create | error | resolve | view
Nightly test materialized view replication, the master site in the test environment is ORACLE10G,MV site is Oracle9201, and when creating a quick-refreshed materialized view on MV site, the report ORA-600 error.

Sql> CREATE materialized 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, found to be a bug, this bug only occurs when you create a materialized view based on oracle10g in Oracle8 or 9.

Reason:

The name of the primary key was explicitly specified when the primary key was created in ORACLE10G's master table. As follows

ALTER TABLE TABLE_NAME ADD CONSTRAINT < constraint name> primary KEY (< col>);

Workaround:

Delete this primary key, and then create a primary key that does not specify the name, which is automatically named by Oracle, as follows

ALTER TABLE ACCOUNT2004 add primary key (Occurtime, Acctid, CurrencyID);

The resulting primary key name becomes sys_cxxxx.

Then recreate the materialized view on MV site, successful.