How to move table from one tablespace to another using brtools
How to move table from one tablespace to another using brtools.
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, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp:
BR0663I Your choice: ‘3’
BR0280I BRTOOLS time stamp:
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, h – help
——————————————————————————-
BR0662I Enter your choice:
1
BRSPACE options for reorganization of tables
1 – BRSPACE profile (profile) …… [initSID.sap]
2 – Database user/password (user) .. [/]
3 ~ Reorganization action (action) . []
4 ~ Tablespace names (tablespace) .. [psapr3]
5 ~ Table owner (owner) ………… [sapsr3]
6 ~ Table names (table) ………… [TANDT]
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) . []
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
——————————————————————————-
List of tables for reorganization
Pos. Owner Table Pt. DgPk. Rows Used[KB] Data[KB:%]
1 – SAPSR3 TANDT NO 1 1200 26592 21423:81
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
BR0280I BRSPACE time stamp:
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp:
BR0657I Input menu 353 – please enter/check input values
——————————————————————————-
Options for reorganization of tables: SAPSR3.TANDT,… (1 table)
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) ……. [ora_proc]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
BR0280I BRSPACE time stamp:
BR0663I Your choice: ‘4’
BR0681I Enter string value for “newts” []:
BR0280I BRSPACE time stamp:
BR0683I New value for “newts”: ‘PSAPSR3702’
BR0280I BRSPACE time stamp:
BR0657I Input menu 353 – please enter/check input values
——————————————————————————-
Options for reorganization of tables: SAPSR3.TANDT,… (1 table)
1 * Reorganization action (action) ………… [reorg]
2 – Reorganization mode (mode) ……………. [online]
3 – Create DDL statements (ddl) …………… [yes]
4 ~ New destination tablespace (newts) …….. [PSAPSR3702]
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) ……. [ora_proc]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
BR0280I BRSPACE time stamp:
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp:
BR1108I Checking tables for reorganization…
BR0280I BRSPACE time stamp:
BR1112I Number of tables selected/skipped for reorganization: 1/0
BR0280I BRSPACE time stamp:
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
BR0280I BRSPACE time stamp:
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
BR0370I Directory /oracle/SID/sapreorg/sepdjek created
BR0280I BRSPACE time stamp:
BR1101I Starting ‘online’ table reorganization…
BR0280I BRSPACE time stamp:
BR1124I Starting ‘online’ reorganization of table SAPSR3.TANDT …
BR0280I BRSPACE time stamp:
BR1105I Table SAPSR3.TANDT reorganized successfully
BR0280I BRSPACE time stamp:
BR1141I 1 of 1 tables processed – 1200 of 1200 rows done
BR0204I Percentage done: 100%, estimated end time: 15:45
BR0001I ****______________________________________________
BR0280I BRSPACE time stamp:
BR1124I Starting ‘online’ reorganization of table SAPSR3.TANDT …
BR0280I BRSPACE time stamp: 2015-01-07 15.43.04
BR1105I Table SAPSR3.TANDT reorganized successfully
BR0280I BRSPACE time stamp:
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 TANDT 1200 0:13
The movement of the table to another tablespace will be completed.
Regards,
Karthik.R
thanks for your help