recreate oracle index

This script will spool out the index create statement with the true size of the index. variable block_size number begin select to_number(value) into :block_size from v$parameter where name = ‘db_block_size’; end; / drop table t_size; create table t_size (owner varchar2(30)