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 FEBRUARY 04, 2019

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

	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

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

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)

Applies to:

Symptoms

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!