https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628813#M18370 <P>Hi folks,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Any idea why using SAS MC configuration is not displaying the tables?&nbsp;</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 02 Mar 2020 16:06:16 GMT MariaD 2020-03-02T16:06:16Z https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628813#M18370 <P>Hi folks,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Any idea why using SAS MC configuration is not displaying the tables?&nbsp;</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 02 Mar 2020 16:06:16 GMT https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628813#M18370 MariaD 2020-03-02T16:06:16Z https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628883#M18373 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/36451">@MariaD</a>&nbsp;- For Oracle tables to show via a metadata-defined library you must add an Extended Attribute - AssignMode = 2:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="screenshot13.jpg" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/36510iEA5145CDCE050C83/image-size/large?v=v2&amp;px=999" role="button" title="screenshot13.jpg" alt="screenshot13.jpg" /></span></P> Mon, 02 Mar 2020 19:06:03 GMT https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628883#M18373 SASKiwi 2020-03-02T19:06:03Z https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628886#M18374 <P>Thanks&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13976">@SASKiwi</a>&nbsp;!</P> Mon, 02 Mar 2020 19:12:38 GMT https://communities.sas.com/t5/Administration-and-Deployment/Access-to-Oracle-Display-tables/m-p/628886#M18374 MariaD 2020-03-02T19:12:38Z