Kbase P53772: Migration to Oracle: index names become [table]##<index>
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
ProtoOra: Index name convention
GOAL:
Migration to Oracle: index names become <table>##<index>
FACT(s) (Environment):
Oracle DataServer
FIX:
Within Progress you may have an index of the same name for each table but that is not allowed within Oracle. Therefore it was needed to make unique index names within Oracle when migrating a Progress database (ProtoOra).
The index name within Oracle will be <table>##<index>.
While migrating sports2000, you will have for example the following Oracle indexes:
CUSTOMER##CUST_NUM
INVOICE##CUST_NUM
REF_CALL##CUST_NUM.