I am trying to reorg ALL the tables in one tablespace at once:
brspace -f tbreorg -a reorg -i psapfact2i -m offline -n psapfact2d -s psapfactd -t "*"
I get this back:
BR1001I BRSPACE 7.00 (33)
BR1002I Start of BRSPACE processing: sdxtkjdu.tbr 2008-04-22 11.57.42
BR0484I BRSPACE log file: /oracle/BQA/sapreorg/sdxtkjdu.tbr
BR0280I BRSPACE time stamp: 2008-04-22 11.57.45
BR1009I Name of database instance: BQA
BR1010I BRSPACE action ID: sdxtkjdu
BR1011I BRSPACE function ID: tbr
BR1012I BRSPACE function: tbreorg
BR0280I BRSPACE time stamp: 2008-04-22 11.57.47
BR1039I Selecting information about tables and indexes...
BR0285I This function can take several seconds/minutes - be patient...
BR0280I BRSPACE time stamp: 2008-04-22 11.57.49
BR0814I Number of tables/partitions in schema of owner SAPR3: 15948/1024
BR0280I BRSPACE time stamp: 2008-04-22 11.57.56
BR0815I Number of indexes/partitions in schema of owner SAPR3: 21106/6021
BR0280I BRSPACE time stamp: 2008-04-22 11.57.56
BR0660I List display 352 - no selection possible
-
List of tables for reorganization
Pos. Owner Table Pt. DgPk. Rows Space[KB] Data[KB:%]
1 - SAPR3 /BI0/E0BWTC_C02 NO 1 0 72 0:0
2 - SAPR3 /BI0/E0BWTC_C03 NO 1 0 72 0:0
3 - SAPR3 /BI0/E0BWTC_C04 NO 1 0 72 0:0
4 - SAPR3 /BI0/E0BWTC_C05 NO 1 0 72 0:0
5 - SAPR3 /BI0/E0BWTC_C06 NO 1 0 72 0:0
6 - SAPR3 /BI0/E0BWTC_C07 NO 1 0 72 0:0
7 - SAPR3 /BI0/E0BWTC_C09 NO 1 0 72 0:0
8 - SAPR3 /BI0/E0BWTC_C11 NO 1 0 72 0:0
9 - SAPR3 /BI0/E0PCA_C01 YES 1 0 584 0:0
10 - SAPR3 /BI0/E0PCA_C02 NO 1 0 72 0:0
11 - SAPR3 /BI0/F0BWTC_C02 YES 1 5405 1040 713:69
12 - SAPR3 /BI0/F0BWTC_C03 YES 1 0 72 0:0
13 - SAPR3 /BI0/F0BWTC_C04 YES 1 0 72 0:0
14 - SAPR3 /BI0/F0BWTC_C05 YES 1 128 144 6:4
15 - SAPR3 /BI0/F0BWTC_C06 YES 1 0 72 0:0
16 - SAPR3 /BI0/F0BWTC_C07 YES 1 0 72 0:0
17 - SAPR3 /BI0/F0BWTC_C09 YES 1 0 72 0:0
18 - SAPR3 /BI0/F0BWTC_C11 YES 1 0 72 0:0
19 - SAPR3 /BI0/F0PCA_C01 YES 1 9985560 715472 565588:79
20 - SAPR3 /BI0/F0PCA_C02 YES 1 3964200 144840 100654:69
Press <Rtn> - scroll, 'c' - cont, 'h' - header, 's' - stop ...
21 - SAPR3 /BIC/E100000 NO 1 289140 18440 13836:75
22 - SAPR3 /BIC/E100001 NO 1 147720 9224 7069:77
23 - SAPR3 /BIC/E100002 NO 1 587930 50184 40191:80
24 - SAPR3 /BIC/EMMPUR_C01 NO 1 0 72 0:0
25 - SAPR3 /BIC/EZCO_C50 NO 1 0 72 0:0
26 - SAPR3 /BIC/EZCO_C51 NO 1 0 72 0:0
27 - SAPR3 /BIC/EZECCS_C04 NO 1 0 72 0:0
28 - SAPR3 /BIC/EZMMPURC01 NO 1 0 72 0:0
29 - SAPR3 /BIC/EZPCA_C03 YES 1 0 488 0:0
30 - SAPR3 /BIC/EZPURC001 YES 1 0 2664 0:0
31 - SAPR3 /BIC/EZPURC002 YES 1 0 296 0:0
32 - SAPR3 /BIC/EZQM_C50 YES 1 0 16488 0:0
33 - SAPR3 /BIC/EZRC_C50 NO 1 0 72 0:0
34 - SAPR3 /BIC/EZRC_C51 YES 1 0 488 0:0
35 - SAPR3 /BIC/F100000 YES 1 0 72 0:0
36 - SAPR3 /BIC/F100001 YES 1 0 72 0:0
37 - SAPR3 /BIC/F100002 YES 1 0 72 0:0
38 - SAPR3 /BIC/FMMPUR_C01 YES 1 590150 53328 42648:80
39 - SAPR3 /BIC/FZCO_C50 YES 1 478120 55552 41555:75
40 - SAPR3 /BIC/FZCO_C51 YES 1 32610 4176 2898:69
Press <Rtn> - scroll, 'c' - cont, 'h' - header, 's' - stop ...
41 - SAPR3 /BIC/FZECCS_C04 YES 1 744980 34696 25463:73
42 - SAPR3 /BIC/FZMMPURC01 YES 1 9719 976 655:67
43 - SAPR3 /BIC/FZPCA_C03 YES 1 11251680 741872 593350:80
44 - SAPR3 /BIC/FZPURC001 YES 1 0 72 0:0
45 - SAPR3 /BIC/FZPURC002 YES 1 0 8 0:0
46 - SAPR3 /BIC/FZQM_C50 YES 1 0 72 0:0
47 - SAPR3 /BIC/FZRC_C50 YES 1 62090 4576 1819:40
48 - SAPR3 /BIC/FZRC_C51 YES 1 0 8 0:0
49 - SAPR3 RSDMFACTAB NO 1 0 72 0:0
50 - SAPR3 RSMDMCNVTAB NO 1 0 72 0:0
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2008-04-22 11.58.02
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2008-04-22 11.58.02
BR0657I Input menu 353 - please enter/check input values
-
Options for reorganization of tables: SAPR3./BI0/E0BWTC_C02,... (50 tables)
1 ~ New destination tablespace (newts) ........ [PSAPFACT2D]
2 ~ Separate index tablespace (indts) ......... [PSAPFACT2I]
3 - Parallel threads (parallel) ............... [1]
4 ~ Table/index parallel degree (degree) ...... []
5 # Create DDL statements (ddl) ............... [yes]
6 ~ Category of initial extent size (initial) . []
7 # Sort by fields of index (sortind) ......... []
8 - Table reorganization mode (mode) .......... [offline]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
Why is it only doing 50 of the 353 tables?