on 09-26-2012 3:12 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.