Kbase P79975: How to make online schema changes to the Database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/11/2009 |
|
Status: Verified
GOAL:
How to make online schema changes to the Database?
GOAL:
Can I add a table with the database online?
GOAL:
How to add new tables with it's fields and indices to the Database while it is up and running?
GOAL:
How to add new sequences when the Database is up and running?
GOAL:
Is it possible to apply incremental .df files to a Database in multi-user (online) mode?
GOAL:
Can I load .df files into the Database while it is in use in multi-user?
GOAL:
Can I modify schema on-line using SQL?
GOAL:
Can I drop a table online using SQL?
GOAL:
What kind of schema changes can be made on-line
GOAL:
How to activate an index online?
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
FIX:
Yes, it is possible to make some schema changes to a Progress Database while it is in multi-user mode.
This can be achieved via the load definition utility in the Data Administration/Dictionary.
The following online schema changes can be made:
(first introduced in 10.0A)
- Add New Sequences
- Add New Tables
- Make sure that all objects associated to the table are made in the same transaction, including add any fields, indexes or database triggers belonging to the new table.
(first introduced in 10.1A)
- Add new fields to an existing table, but no Assign triggers.
- Add new inactive indexes to an existing table.
To activate the indexes added use information from solution P16490, "How to reactivate a deactivated index when the database is offline?"
The following SQL commands can be executed against an online database:
* ALTER TABLE ADD COLUMN
* CREATE INDEX
* CREATE SEQUENCE
* CREATE STORED PROCEDURE
* CREATE SYNONYM
* CREATE TABLE
* CREATE TRIGGER
* CREATE VIEW
* DROP SYNONYM
* DROP VIEW
* GRANT
* REVOKE
These are the steps to be performed to apply an incremental .df file to an online Database using the Graphical Interface client:
1- Open Progress Data Administration Tool
2- Connect the database
3- From the Admin -> Load Data and Definitions menu, select Data Definitions (.df file)...
4- On the Load Data Definitions Dialog, turn on the "Add new objects on-line" toggle-box and choose the Ok button to load online schema changes into the Database