Kbase P102035: Generate Delta SQL Utility generating incorrect SQL when new field is an extent
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Generate Delta SQL Utility generating incorrect SQL when new field is an extent
When loading in SQL to Oracle getting Oracle error 1735
ORA-01735: invalid ALTER TABLE option
First array element syntax to create new field is missing keyword ADD
Generated SQL is:
ALTER TABLE <table name>
glacct##1 VARCHAR2 (40)
ADD glacct##2 VARCHAR2 (40)
ADD glacct##3 VARCHAR2 (40)
ADD glacct##4 VARCHAR2 (40)
ADD glacct##5 VARCHAR2 (40)
ADD glacct##6 VARCHAR2 (40)
ADD glacct##7 VARCHAR2 (40)
;
CAUSE:
Bug# 20050311-015
FIX:
Upgrade to:
Version 9 9.1E or higher
Version 10 10.0B02 or higher
If unable to upgrade at this time, a workaround is to manually modify the SQL file before loading into Oracle and put the ADD keyword before the first extent field.