Alter Index Rebuild Fails with 'SQL Error: ORA-01422: exact fetch returns more than requested number of rows' for FB Index Selecting from a Table with VPD Policy

(Doc ID 2161325.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.1.0.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Healthcare Translational Research (TRC) 3.1.0.2 version,

When attempting to perform the steps from "Oracle Health Sciences Omics Data Bank
Programmer’s Guide" Release 3.1, E66523-01 document, section 2.6 "Migrating CDM Data
to ODB" in order to sync the CDM and ODB data, the following error occurs.

ERROR
-----------------------

    Make sure that the source table has VPD policy enabled.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms