Introspecting Oracle Object which has special characters in Object Names

Introspecting Oracle Object which has special characters in Object Names

book

Article ID: KB0081650

calendar_today

Updated On:

Description

Question/Problem:

 

How to introspect Object/Views in oracle databases with '$' in the name. 
When we introspected the database to add these views in studio, they are not showing up. 

Issue/Introduction

Introspecting Oracle Object which has special characters in Object Names

Resolution

Fix/Solution:

 

In order to introspect all object, we need to turn on "Introspect All Objects" in the configuration UI. i.e. Set this configuration, Studio > Configuration > Data sources > Oracle Data Source > Introspect All Objects = True.
Powered by Wolken Software