Skip to Content

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply