How to introspect the Oracle data source tables and columns that have '/' (slash) in their name?
Article ID: KB0071418
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
If an Oracle database contains tables/columns with '/' (slash) in their name, they do not appear in TIBCO Data Virtualization (TDV) introspection panel when we try to introspect the database.
For example: "/bci/matter_abc000" is table name in Oracle.
For example: "/bci/matter_abc000" is table name in Oracle.
Issue/Introduction
How to introspect the Oracle data source tables and columns that have '/' (slash) in their name?
Resolution
(i) Navigate to the below path:
TDV Studio -> Administration -> Configuration -> Data Sources -> Oracle Sources -> Introspect All Objects
(ii) Set the above configuration to TRUE
(iii) Introspect the Oracle data source again.
TDV Studio -> Administration -> Configuration -> Data Sources -> Oracle Sources -> Introspect All Objects
(ii) Set the above configuration to TRUE
(iii) Introspect the Oracle data source again.
Feedback
Yes
No
Powered by
