Skip to Content
0
Former Member
Feb 12, 2009 at 05:13 AM

error when rebuilding the index through brtools.

299 Views

Hi Experts,

We are getting the error (pls check discription as per below) while rebuild the index on our prod server.

Environment :-ECC 5.0 with oracle 9i on WIN 2003 server

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\eccadm>brtools

BR0651I BRTOOLS 6.40 (15)

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.46

BR0656I Choice menu 1 - please make a selection

-


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:

2

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.50

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.50

BR0656I Choice menu 5 - please make a selection

-


Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

b

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.57

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.57

BR0656I Choice menu 1 - please make a selection

-


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: 2009-02-12 11.31.58

BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.58

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 input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.01

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.01

BR0657I Input menu 92 - please check/enter input values

-


BRSPACE options for rebuild of indexes

1 - BRSPACE profile (profile) ...... [initECC.sap]

2 - Database user/password (user) .. [/]

3 ~ Rebuild action (action) ........ []

4 ~ Tablespace names (tablespace) .. []

5 ~ Index owner (owner) ............ []

6 ~ Table names (table) ............ []

7 ~ Index names (index) ............ []

8 - Confirmation mode (confirm) .... [yes]

9 - Scrolling line count (scroll) .. [20]

10 - Message language (language) .... [E]

11 - BRSPACE command line (command) . [-p initECC.sap -s 20 -l E -f idrebuild]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

7

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.13

BR0663I Your choice: '7'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.13

BR0681I Enter string value for "index" []:

SAPECC.CEFORMW~0

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.27

BR0683I New value for "index": 'SAPECC.CEFORMW~0'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.27

BR0657I Input menu 92 - please check/enter input values

-


BRSPACE options for rebuild of indexes

1 - BRSPACE profile (profile) ...... [initECC.sap]

2 - Database user/password (user) .. [/]

3 ~ Rebuild action (action) ........ []

4 ~ Tablespace names (tablespace) .. []

5 ~ Index owner (owner) ............ []

6 ~ Table names (table) ............ []

7 ~ Index names (index) ............ [SAPECC.CEFORMW~0]

8 - Confirmation mode (confirm) .... [yes]

9 - Scrolling line count (scroll) .. [20]

10 - Message language (language) .... [E]

11 - BRSPACE command line (command) . [-p initECC.sap -s 20 -l E -f idrebuild -i

"SAPECC.CEFORMW~0"]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.30

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initECC.sap -s 20 -l E -f idreb

uild -i "SAPECC.CEFORMW~0"'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.30

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.32

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 6.40 (15)

BR1002I Start of BRSPACE processing: sdzxheyq.idr 2009-02-12 11.32.32

BR0280I BRSPACE time stamp: 2009-02-12 11.32.34

BR1009I Name of database instance: ECC

BR1010I BRSPACE action ID: sdzxheyq

BR1011I BRSPACE function ID: idr

BR1012I BRSPACE function: idrebuild

BR0280I BRSPACE time stamp: 2009-02-12 11.32.36

BR1039I Selecting information about tables and indexes...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2009-02-12 11.32.39

BR0814I Number of tables in schema of owner SAPECC: 43103

BR0280I BRSPACE time stamp: 2009-02-12 11.32.42

BR0815I Number of indexes in schema of owner SAPECC: 51463

BR0280I BRSPACE time stamp: 2009-02-12 11.32.42

BR0657I Input menu 356 - please check/enter input values

-


Options for rebuild of indexes: SAPECC.CEFORMW~0 (degree 1)

1 ~ New destination tablespace (newts) . []

2 - Parallel threads (parallel) ........ [1]

3 ~ Index parallel degree (degree) ..... []

4 - SQL command (command) .............. [alter index "SAPECC"."CEFORMW~0" rebu

ild online]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2009-02-12 11.32.49

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-02-12 11.32.49

BR1151I Starting online index rebuilding...

BR0280I BRSPACE time stamp: 2009-02-12 11.32.50

BR0301E SQL error -8120 at location BrSqlExecute-1

ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

BR1017E Execution of SQL statement 'alter index "SAPECC"."CEFORMW~0" rebuild onl

ine' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last actionBR0280I BRSPACE time stamp: 2009-02-12 11.32.50

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Thanks in advance.