Skip to Content
avatar image
Former Member

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

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 26, 2012 at 03:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded