Kbase P35388: When dropping a column via the delta.sql utility, why does Progress create a view?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
When dropping a column via the delta.sql utility, why does Progress create a view?
GOAL:
Why Generate Delta.sql Progress to Oracle utility creates a view in the .sql file when a column or field is dropped from a table from Progress?
FACT(s) (Environment):
Progress 9.1x
Oracle DataServer
FIX:
When the delta.df for Progress contains DROP FIELD statements, after running through delta SQL progress to Oracle utility, a view is created. The view suppresses the fields that were to be deleted. In the schema holder we define the view to be the representation of the modified table.
This is because Dataserver for Oracle version 9.1X still supports Oracle 7, Oracle 7 does not have "alter table drop column" support. This is an Oracle limitation.