ORA-31603: object "FK_TAB2_TAB1" of type REF_CONSTRAINT not found in schema "USER1"
Situation
I Use Privacy and run it using an Oracle database
I get the error:
[DDL retrieval for foreignkey USER1.FK_TAB2_TAB1]
ORA-31603: object "FK_TAB2_TAB1" of type REF_CONSTRAINT not found in schema "USER1"
Explanation
Privacy and Subset requires the SELECT_CATALOG_ROLE permission when reading the objects of another schema.
To repair logon as user with SYS permissions:
grant SELECT_CATALOG_ROLE to USER1