Skip to Content
0
Sep 26, 2012 at 02:12 PM

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

65 Views

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,