[Progress Communities] [Progress OpenEdge ABL] Forum Post: Using PRROWID and PROGRESS_RECID

Status
Not open for further replies.
V

Valeriy Bashkatov

Guest
Hi all! Pro2Oracle v.5.5.0.2, Unix, OE 11.7.5 The first question - is it possible to change the datatype of PRROWID field on Oracle side from CHAR to NUMBER? The second question - is it possible to generate value of PROGRESS_RECID not by SEQUENCE but as TO_NUMBER(ROWID) or something like that? The goal is to discard the unique index for the string field "PRROWID", instead save the ROWID of the record from OpenEdge as a number in the field PROGRESS_RECID to have only one unique index by PROGRESS_RECID . The problem is that my client wants to partition target tables in Oracle to improve performance. But Oracle experts now claim that this is not possible in the current architecture of tables that Pro2 generates. They claim that the current configuration with which Pro2 works is extremely dangerous for exploitation for big data, when a single target table reaches several terabytes in Oracle. Personally, I strongly doubt this and do not fully understand the position of Oracle experts. I would be grateful for any thoughts and advice!

Continue reading...
 
Status
Not open for further replies.
Top