Skip to Content
Author's profile photo Former Member

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Fuso Andrea
      Fuso Andrea

      thanks for your help