Data Foundation cannot see PUBLIC schema

Dec 06, 2016 at 10:04 PM


avatar image
Former Member

While creating data foundation in Universe in Information design Tool (IDT), the option Insert table does not show any of the PUBLIC schema synonyms or tables. Parameter "Include Synonyms" has been set to "True" at client and server level. User used for connection has been tested with other tools (TOAD, SQL Plus) and not problems accessing the PUBLIC schema there.

Any idea of what can be the problem with IDT?

We are BO 4.2 SPS 2 Patch 6 conecting to Oracle 11g.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manikandan Elumalai Dec 07, 2016 at 10:33 PM

Can we make sure we have created Public synonyms at oracle level . If not the private synonym should have been created by the user who owns the connection.



10 |10000 characters needed characters left characters exceeded
Skip to Content