BookmarkSubscribeRSS Feed

[SAS 활용 FAQ] tnanames.ora 파일을 생성하지 않고 Oracle에 연결할 수 있나요?

Started ‎09-29-2021 by
Modified ‎09-29-2021 by
Views 404

아래 예시에서 보시듯이, tnanames.ora 파일에 기록되어야 할 정보를 SAS libname 구문에 지정해서 Oracle library를 만들 수 있습니다.

 

[예시]

libname oralib1 oracle path="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = ora01- cluster.company.com)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME=exadat12c)))" user=myuser password=mypasswd;.

Contributors
Version history
Last update:
‎09-29-2021 10:30 PM
Updated by:

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Article Labels
Article Tags