Change from Oracle to SAS Library

[Mushy]

Hello,

I have an Oracle library where I have 2 tables. I use those tables in DI jobs.

The same tables are now in sas server as sas datasets.

Is it possible to change the library definition of the Oracle lib to point to sas datasets?

Mushy

[Kurt_Bremser]

You can replace the Oracle library with a SAS Base library of the same name, but this means you lose your Oracle access, at least temporarily.

[Mushy]

Hi Kurt,

Thansk for the response . But I already have registered tables from oracle.

I dont want to lose the table metadata as it is used across programs.

Mushy

[Kurt_Bremser · Accepted solution]

Then you must use the SAS library in your code in place of the Oracle library.