Consultor Eletrônico



Kbase P43302: If I change logical name in schema holder, do I need to chan
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   9/19/2003
Status: Unverified

GOAL:

If I change logical name in schema holder, do I need to change ORACLE_SID?

FACT(s) (Environment):

Oracle

FACT(s) (Environment):

Oracle DataServer

FIX:

No, ORACLE_SID does not relate to logical name in schema holder, thus does not need to be changed.

The logical name in schema holder is relevant to 4GL program, 4GL programs need to be recompiled against the new logical name after it is changed; ORACLE_SID is for dataserver to make connections to local Oracle instance.