Kbase P27279: Can you have two different schema holders that connect to th
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/06/2003 |
|
Status: Unverified
GOAL:
Can you have two different schema holders that connect to the same Oracle database using the same UserID?
FIX:
Yes, however it may not be a good idea to do so.
You would have to ensure that any schema table updates to one schema holder does not overwrite tables in the other. For example. If you had a table called "customer" already created in the first schema holder and then added a "customer" table to the second, the "customer" table that existed in the first schema holder will be wiped out.
It is suggested that you have each schema holder connect to the Oracle database as a different user, that way each user has it's own tables and the chances of wiping out each other's tables is greatly reduced.