topic Re: Change from Oracle to SAS Library in Administration and Deployment

Change from Oracle to SAS Library

Mushy — Fri, 22 Dec 2023 07:17:21 GMT

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 — Fri, 22 Dec 2023 07:56:36 GMT

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 — Fri, 22 Dec 2023 08:30:49 GMT

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 — Fri, 22 Dec 2023 08:33:32 GMT

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