Access to Oracle | Display tables

[MariaD]

Hi folks,

We have the following situation. We defined a Oracle library on SAS Management Console. This library is not pre-assigned. When we assign it on SAS EG (right click and select Assign), the library is assign correctly but doesn't show tables inside it. But if we execute the libname statement (copy the code from SAS MC, right click on library and select "Display libname assignment") directly on SAS EG, library is define fine and we see the list of tables inside it.

Any idea why using SAS MC configuration is not displaying the tables? 

Thanks!

[SASKiwi · Accepted solution]

@MariaD - For Oracle tables to show via a metadata-defined library you must add an Extended Attribute - AssignMode = 2:

[MariaD]

Thanks @SASKiwi !