Kbase P9601: Can schema changes be made in multi-user mode?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/12/2008 |
|
Status: Verified
GOAL:
Can schema changes be made in multi-user mode?
GOAL:
What changes can be made to a database while running in multi-user mode?
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
OpenEdge Category: Database
FIX:
IMPORTANT NOTE: Always backup the database and verify the backup before performing any schema changing tasks.
The following actions may be performed in multi user mode (online):
1. PROUTIL tablemove and indexmove albeit at a significant performance cost.
2. Adding and deleting tables and fields provided that no other user is using the database. Only one user can update any part of the schema at a given time.
3. Using the Data Dictionary, the Data Definition files (.df) may also be dumped and loaded.