Procedure :
BR*Tools main menu
1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:07
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:07
BR0656I Choice menu 7 - please make a selection
-------------------------------------------------------------------------------
Database segment management
1 = Reorganize tables
2 - Rebuild indexes
3 - Export tables
4 - Import tables
5 - Alter tables
6 - Alter indexes
7 - Additional segment functions
8 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:13
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:13
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables
1 - BRSPACE profile (profile) ...... [initLDD.sap]
2 - Database user/password (user) .. [/]
3 ~ Reorganization action (action) . []
4 ~ Tablespace names (tablespace) .. []
5 ~ Table owner (owner) ............ []
6 ~ Table names (table) ............ []
7 ~ Table partitions (tabpart) ..... []
8 - Confirmation mode (confirm) .... [yes]
9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initLDD.sap -s 20 -l E -f tbreorg]
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:22
BR0663I Your choice: '6'
BR0681I Enter string value for "table" []:
TTREE_FLNK
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:37
BR0683I New value for "table": 'TTREE_FLNK'
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:37
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables
1 - BRSPACE profile (profile) ...... [initLDD.sap]
2 - Database user/password (user) .. [/]
3 ~ Reorganization action (action) . []
4 ~ Tablespace names (tablespace) .. []
5 ~ Table owner (owner) ............ []
6 ~ Table names (table) ............ [TTREE_FLNK]
7 ~ Table partitions (tabpart) ..... []
8 - Confirmation mode (confirm) .... [yes]
9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initLDD.sap -s 20 -l E -f tbreorg -t "TTREE_FLNK"]
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREE_FLNK (degree 1)
1 * Reorganization action (action) ............ [reorg]
2 - Reorganization mode (mode) ................ [online]
3 - Create DDL statements (ddl) ............... [yes]
4 ~ New destination tablespace (newts) ........ []
5 ~ Separate index tablespace (indts) ......... []
6 - Parallel threads (parallel) ............... [1]
7 ~ Table/index parallel degree (degree) ...... []
8 ~ Category of initial extent size (initial) . []
9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... []
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:08
BR0663I Your choice: '4'
BR0681I Enter string value for "newts" []:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:13
BR0683I New value for "newts": 'PSAPSR3740X'
BR0280I BRSPACE time stamp: 2020-04-05 22:10:13
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREE_FLNK (degree 1)
1 * Reorganization action (action) ............ [reorg]
2 - Reorganization mode (mode) ................ [online]
3 - Create DDL statements (ddl) ............... [yes]
4 ~ New destination tablespace (newts) ........ [PSAPSR3740X]
5 ~ Separate index tablespace (indts) ......... []
6 - Parallel threads (parallel) ............... [1]
7 ~ Table/index parallel degree (degree) ...... []
8 ~ Category of initial extent size (initial) . []
9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... []
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR1108I Checking tables for reorganization...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR1112I Number of tables selected/skipLDD for reorganization: 1/0
BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:16
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0370I Directory /oracle/LDD/sapreorg/sfdmwqwt created
BR0280I BRSPACE time stamp: 2020-04-05 22:10:16
BR1101I Starting 'online' table reorganization...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:16
BR1124I Starting 'online' reorganization of table SAPSR3.TTREE_FLNK ...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR1105I Table SAPSR3.TTREE_FLNK reorganized successfully
BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR1141I 1 of 1 table processed - 3373 of 3373 rows done
BR0204I Percentage done: 100.00%, estimated end time: 22:10
BR0001I **************************************************
BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR1102I Number of tables reorganized successfully: 1
BR1142I Tables with the longest duration of reorganization for owner SAPSR3
Pos. Owner Table Rows Duration
[m:s]
1 SAPSR3 TTREE_FLNK 3373 0:01
BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:33
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:33
BR1022I Number of tables processed: 1
BR1003I BRSPACE function 'tbreorg' completed
BR1008I End of BRSPACE processing: sfdmwqwt.tbr 2020-04-05 22:10:33
BR0280I BRSPACE time stamp: 2020-04-05 22:10:33
BR1005I BRSPACE completed successfully
Suggestion :
Always have full successfully backup of the system.
Make sure table your moving should have appropriate TABART association.