Oracle Reorganization

[Former Member]

Hi Gurus!!

My landscape is an SAP ERP 5.0 on Oracle 11.2.0.3 with Red Hat Enterprise Linux 6 and database size is 1.2 TB. I´m following SAP note 646681 (Reorganization of tables with BRSPACE), Remark 14, to do a reorganization of a SAP Tablespace. This remark has following points:

1-Ensure that the tablespace to be reorganized is "self-contained".

2-Create the help tablespace <aux_tsp>.

3-Move tables (SDBAH,SDBAD,DBAML,DBATL,MLICHECK,TGORA,IGORA,TSORA,TAORA, IAORA,SVERS,DD02L,DD09L,DDNTT,DDART,DARTT

or SAPLIKEY) to the tablespace <aux_tsp> by online reorganization.

4-Export all tables from the <reorg_tsp> tablespace.

5-Delete <reorg_tsp> tablespace including data files.

6-Create a new <reorg_tsp> tablespace.

7-Import the exported tables into the recreated <reorg_tsp> tablespace.

8-Move tables, moved in point 3, into the new <reorg_tsp> tablespace.

9-Delete tablespace <aux_tsp> including data files.

All seems clear!! But, when I try to do point 6, BRTools show the following error:

BR1304E Checking SAP license failed at location BrLicCheck-110

BR0602E No valid SAP license found - please contact SAP

Could you help me?

P.D. I attached some log files.

brspace_log.txt.zip

brspace_trace.txt.zip

[Former Member · Accepted solution]

as per note   541538 - FAQ: Reorganization

• BR0602E No valid SAP license found - please contact SAP

           If this error occurs when you carry out an import during an offline reorganization with BRSPACE, this may be connected to the drop of the license table MLICHECK after the export. The reason for this is that MLICHECK was not moved into a help tablespace in accordance with Note 646681 (14). Apart from an individual manual procedure for reconstructing MLICHECK, the only thing you can do in this case is to restore a backup.

[Former Member · Accepted solution]

Hi.

I have read the note, but had not copied correctly table MLICHECK. Now all works fine!

Thank you very much!!!!