My Oracle Support Banner

Streams Will Not Replicate a Domain Index Type (Doc ID 1296815.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

When using Oracle Streams you may see following errors if you are capturing CREATE INDEX statements for DOMAIN index type only:

At source database alert log file:
knllgobjinfo: MISSING Streams multi-version data dictionary!!!
knlldmm: gdbnm=TST5.WORLD
knlldmm: objn=70308
knlldmm: objv=1
knlldmm: scn=10065596997978

When querying the "objn" given you will see they are tables named as DR$<table_name>_IDX$K and DR$<table_name>_IDX$N, for example:
select object_name, object_type from dba_objects where object_id = 70308;

DR$TEST_IDX$K     TABLE

1 row selected.

At the destination database, when using Streams apply schema or global level rules, you may see following error on dba_apply_error view:
ORA-26687: no instantiation SCN provided for "SCHEMA_TEST"."" in source database "TST5.WORLD"

Note: If you are using apply table level rules, the ORA-26687 will not happen at destination database.

Changes

When capturing CREATE INDEX for a DOMAIN type one.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.