Kbase P92257: Does the change on the Oracle instance name of the Oracle database require any change on the DataSer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/08/2004 |
|
Status: Unverified
GOAL:
Does the change on the Oracle instance name of the Oracle database require any change on the DataServer connection or update of the schema holder?
FIX:
No, no change is needed since the Oracle name of the Oracle database instance is not tight up to the connection parameters or to the schema holder information.
But, make sure that the oracle schema is exactly the same as the original Oracle schema. Remember that "exactly the same" means the same object names, same fields and order of fields in the table.
The ORACLE_SID environment variable - which is the identifier for the ORACLE instance you are accessing - is required only before running link scripts.