Kbase P60432: protoora does not create some tables in Oracle database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2010 |
|
Status: Unverified
SYMPTOM(s):
protoora does not create some tables in Oracle database
4 out of 236 tables created in Oracle
The 4 tables are in the middle, the tables are not the last ones
Schema holder created but missing definitions for the 4 missing tables
Able to manually load the SQL generated for these tables into Oracle logging in as the same user as migration
Oracle instance 9.2 on Solaris 64 bit
Original progress database used in migration available
FACT(s) (Environment):
Progress 9.1D
Oracle DataServer
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
1. Load the SQL statements generated by protoora mamually into the oracle database
2. Connect to both schema holder and Oracle, use Add/update table definitions, select the 4 missing table, pull definitions into schema holder
3. Disconnect Oracle database, connect to both schema holder and Original progress database, run "Adjust schema" option