topic Re: NOT able to copy from Oracle library to BASE SAS library? in SAS Enterprise Guide

NOT able to copy from Oracle library to BASE SAS library?

sasanuru — Fri, 04 Dec 2015 14:20:42 GMT

Hi All,

The sasdemo user created and not able to copy from Oracle library to BASE SAS library?

What securtiy will be applied to user and library level at source and target level?

Many thanks in avance for your assistance and resolve the issue.

BR,

Kumar

Re: NOT able to copy from Oracle library to BASE SAS library?

Reeza — Fri, 04 Dec 2015 15:13:56 GMT

Your question is unclear.

Re: NOT able to copy from Oracle library to BASE SAS library?

sasanuru — Sat, 05 Dec 2015 08:18:53 GMT

Hi Reeza,

Thanks for asking ...

We have two libraries names as Andrew to Test_Lib which are presendted in SEG.

Test_Lib library created in Management Console then same library reflected in SEG as well.

I am using SASDemo user which is already part of SAS Admin group.

I have attached error screenshot ...

Please let me know if you have any queries to resolve the issue.

Thanks in advance for great help.

BR,

Kumar

Re: NOT able to copy from Oracle library to BASE SAS library?

ChrisHemedinger — Sat, 05 Dec 2015 20:32:41 GMT

You might need to have the library definition changed in SAS Management Console to "Pre-assigned", which will then use the native Base engine instead of the META engine that's used by default.

Details are in the paper linked from here: What SAS administrators should know about libraries, metadata, and SAS Enterprise Guide.

Chris