9 lines
273 B
Plaintext
Executable File
9 lines
273 B
Plaintext
Executable File
set lines 256 pages 0
|
|
|
|
select 'alter index "'|| owner || '"."' || index_name || '" rebuild online compute statistics;'
|
|
from
|
|
dba_indexes
|
|
where
|
|
owner='DRIVE' and
|
|
table_name in ('FUEL_INTERIM_TRANS_HEADERS', 'FUEL_INTERIM_TRANS_DETAILS', 'FUEL_TRANSACTION_ERRORS');
|
|
|