on 03-21-2024 9:39 AM
Für die Reorganisierung der Tabelle muss vorerst die verknüpfte LOB Tabelle über einen SHRINK Befehl verkleinert werden.
Im normalen DBA Umfeld wäre es dieses Kommando:
ALTER TABLE <table> MODIFY LOB(DATEN) (SHRINK SPACE);
Bei SAP Datenbanken soll das BRTOOLS verwendet werden. Die Frage ist, wie das richtig Vorgehen ist, um die LOB Tabelle zu shrinken?
Dear Customer,
With BR*Tools there is no restriction for LOB fields. Only the LONG and LONG RAW fields should be converted into LOB.
You can reorganize the LOB columns with BRSAPCE without shrinking.
Please check below note for more information:
646681 - Reorganization of tables with BRSPACE
Best regards,
SAP Product Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.