Sort the table as per the fields of the primary index followed by a reorganization in Oracle DB

[former_member184628]

Hi All,

We have to sort the table as per the fields of the primary index followed by a reorganization of the database using BRTOOLS.

We have done reorganization of oracle table with brspace -u / -f tbreorg -t <tablename> option. But now the requirement is to sort the table as per the fields of primary index. I have found SAP note 1016172 which provides the option -r|-sortind first|<ind_id>|<ind_name> but we are not sure of how to use it.

Thanks,

[paul_power · Accepted solution]

Hello Sharib,

First, check you have the latest brtool version as per the note.

_reorg_sort_col="<key field1>,<key field2>,<key field3>,<key field4>"

is a correct parameter setting in init<DBSID>.sap.

It must be set only once there.

Also check SAP Note 85558     Tables with data sorted by index

regards,

Paul