Pages

Tuesday, April 7, 2020

Move table from one tablespace to another using BRTOOLS


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.

No comments:

Post a Comment