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 03, 2019
Applies to:
Oracle Healthcare Translational Research - Version 3.1.0.2 and laterInformation 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
Symptoms |
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. |