idx_rebuild_diff_idx_l.sql

1.

set echo on feedback on set timing on set time on set pagesize 1000 set linesize 150

spool 02_do_index_idx_l.log

@/testdb/change/env/env_test.sql

connect &V_test_UN/&V_test_PW

alter session set sort_area_size=40000000;

alter index test.t2    rebuild tablespace IDX_L online;

 

 

2.

set echo on feedback on set timing on set time on set pagesize 1000 set linesize 150

spool 03_idx_rebuild_diff_idx_m_s_spt.log

@/test/change/env/env_test.sql

connect &V_test_UN/&V_test_PW

alter session set sort_area_size=40000000;

alter index test.T1        rebuild tablespace IDX_M online;