Kbase P56658: DataServer: How to change Oracle index name
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
DataServer: How to change Oracle index name
FACT(s) (Environment):
Oracle DataServer
Progress 9.1x
FIX:
Should you (really) want to change an index name from within Oracle, then you may use the following steps for 9.x DataServer.
1. Within Oracle, drop the existing index
2. Within Oracle, create the same index with another name
3. Within Progress, change for that index the value of _Index._For-Name
Sample for sports2000 database migrated with "protoora".
In Oracle, run
DROP INDEX customer##custnum.
CREATE UNIQUE INDEX custCustnum on customer (custnum);
In Progress, run:
FIND _Index WHERE _Index-Name = "CustNum" AND _For-Name = "CUSTOMER##CUSTNUM". SET _For-Name = "custCustnum".
The above steps might be valid for other versions of Progress Oracle DataServer but you are advised to carefully test.