Consultor Eletrônico



Kbase P156089: Error when trying to pull Schema information from Oracle DB
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/20/2009
Status: Unverified

SYMPTOM(s):

Error when trying to pull Schema information from Oracle DB

There are no objects in the ORACLE database that satisfy the selected criteria

FACT(s) (Environment):

Windows Server 2003
OpenEdge 10.x
Oracle DataServer
User that was being used to pull the Schema Holder was not the owner of the Objects.

Oracle 10g

CAUSE:

The owner being used for the Schema Pull was not the owner of the Objects, he only has read privileges.


FIX:

Use the user who is the actual Owner of the Objects and thus has the appropriate privileges when trying to pull the Schema information.