Kbase P97492: Is it possible to make online field and index changes to an existing table ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/11/2006 |
|
Status: Verified
GOAL:
Is it possible to make online field and index changes to an existing table ?
GOAL:
Can you add new fields and index online?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
In Release 10.1A, you can add new fields and inactive indexes to existing tables while the OpenEdge database remains online. You can add new fields and inactive indexes even if another user is accessing or modifying records in the table you are updating.
This feature is implemented via the Data Administration tool. Select Admin Load Data And Definitions Data Definitions (.df file) option. In previous releases, the New Objects option allowed you to add a new table to an online database. In Release 10.1A, it now allows the addition of new fields and inactive indexes to existing tables.
Note that adding new fields to a table causes an update to the cyclic redundancy check (CRC) for the table, so any client connecting to the database after the change will cache the table with the new CRC. Therefore, you must recompile any existing applications that access tables to which you have added new fields.