PR_OTHER_IDX table regarding
We are upgrading PEGA application DB from DB2 to Oracle. While upgrading DBA team has mentioned that PR_OTHER_IDX is a custom table.
I have found from PDN website (https://docs-previous.pega.com/qa-session-whats-new-pegarules-process-commander-v54-webinar-27-feb-08) stating that New Indexed properties are added to the pr_other_idx table. If the user does not have access to update the DB, the DDL scripts will be presented to the user for download. You can alter the table mapping by updating the Data-Admin-DB-Table record as well. Kindly advise us on the impact of PR_OTHER_IDX table.
***Updated by Moderator: Vidyaranjan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***Tagged SRexists***
***Updated by moderator: Marissa to update categories***
Accepted Solution
Incessant Technologies
IN
Dont think PR_OTHER_IDX is OOTB table. I get it checked in my local set up. In this case you need to export the table from one DB to another DB using export option provided in most DB admin tool. One such option I found in SQL Developer which generates all required DDL and DML to export the table to another DB.
Natwest Group
IN
Hi Rajesh,
Thanks for the response!!!
Below is the response from DBA team, Table PR_OTHER_IDX looks like custom table inherited from PR_OTHER. Since it is custom table DBAs need to create DDLs and install it separately on Oracle.
Whether PR_OTHER_IDX is a Cutom Table?
Accepted Solution
Incessant Technologies
IN
Dont think PR_OTHER_IDX is OOTB table. I get it checked in my local set up. In this case you need to export the table from one DB to another DB using export option provided in most DB admin tool. One such option I found in SQL Developer which generates all required DDL and DML to export the table to another DB.