Kbase P22502: How to sync Oracle with schema holder changing the fields length ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/15/2007 |
|
Status: Unverified
GOAL:
How to sync Oracle with schema holder changing the fields length ?
FACT(s) (Environment):
Progress 9.x
Oracle 8.x
Oracle DataServer
FIX:
There is no Progress admin utility which will sync Oracle database based on schema holder.
However for changing the length of the fields Oracle 8 allows to alter the table definitions without dropping the fields.
The following SQL command changes the length of name column in customer table to 30 characters.
ALTER TABLE "SCOTT"."CUSTOMER"
MODIFY( "NAME" VARCHAR(30))