on 03-15-2009 2:12 PM
Hi,
while rebuliding index using RSANAOR it was taking more time, so I have canceled it.
when again trying to rebuild using BRTools for same index, it is giving below error:
Options for rebuild of indexes: SAPR3P.ZAPO_ORDERS~0 (degree 1)
1 ~ New destination tablespace (newts) ........ []
2 - Parallel threads (parallel) ............... [1]
3 ~ Index parallel degree (degree) ............ []
4 ~ Category of initial extent size (initial) . []
5 - Index rebuild mode (mode) ................. [online]
6 - SQL command (command) ..................... [alter index "SAPR3P"."ZAPO_ORDERS~0" rebuild online]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2009-03-15 18.14.01
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2009-03-15 18.14.01
BR1151I Starting online index rebuilding...
BR0280I BRSPACE time stamp: 2009-03-15 18.14.01
BR0301E SQL error -8104 at location BrSqlExecute-1, SQL statement:
'/* BRSPACE */ alter index "SAPR3P"."ZAPO_ORDERS~0" rebuild online'
ORA-08104: this index object 113478 is being online built or rebuilt
BR1017E Execution of SQL statement 'alter index "SAPR3P"."ZAPO_ORDERS~0" rebuild online' failed
BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action
BR0280I BRSPACE time stamp: 2009-03-15 18.14.01
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:
============================================
I have gone thro' Note 682926 :
the script;
set serveroutput on
begin
if dbms_repair.online_index_clean() then
dbms_output.put_line('All fragments cleaned');
else
dbms_output.put_line('DML Locks on some tables.');
dbms_output.put_line('Not all fragments cleaned. ');
dbms_output.put_line('Try again later');
end if;
end;
/
kindly suggest for necessary action.
can i run the script on prodution server without taking in mount state.
Regards,
Gokul Chitode
Hi Gokul,
Refer SAP note 682926.
Regards,
Sachin Rane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.