Kbase P186266: Getting error 1461 after applying incremental .sql to Oracle and .df to schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/20/2011 |
|
Status: Unverified
SYMPTOM(s):
Getting error 1461 after applying incremental .sql to Oracle and .df to schema holder
Schema holder does not match database schema -- file field . (1461)
Generating a Delta.sql file and schema holder .df from Oracle DataServer "Generate Delta.sql OpenEdge to ORACLE" tool
Update/Add table definition causes a new table created appending "-1" after the table name that already exists on the schema holder.
.df from the schema holder shows the new tables? FOREIGN-OWNER as owner-name/password@SQLNET instead of just owner-name
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The ORACLE object owner name is entered incorrectly in the Delta df to Oracle Conversion window. It contains
the Oracle user name as well as a password, for example: user/password@Oracle_sql_net_name
FIX:
Use only the Oracle owner-name for the ORACLE object owner name:
1. In the Data Administration utility select Dataserver>>ORACLE Utilities>>Schema Migration Tools>>Generate Delta.sql OpenEdge to ORACLE
2. In the Delta df to ORACLE conversion window, for ORACLE Object Owner Name, enter only the Oracle owner name.