Consultor Eletrônico



Kbase P129952: Data Dictionary does not Pull Oracle Table Definition When Table Contains Unsupported Data Types
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/31/2008
Status: Unverified

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1B
Oracle DataServer

SYMPTOM(s):

Data dictionary does not pull table definition

The pulling process displays the operation

The resulted dictionary does not contain the intended tables

Permissions for the user are set correctly

Other tables owned by the same user are pulled into dictionary

CAUSE:

There are unsupported data types in the affected table, for example. CLOB

FIX:

Create a view excluding the unsupported data types from the table and pull the view into the dictionary