Re: Drop Tablespace

What tablespace create index:

1. select index_name, index_type from all_indexes where tablespace_name = 'DCC_DROP2'; and rebuild index
2. Automation select 'alter index '|| owner || '.' || index_name || ' rebuild tablespace new tablespace;' from all_indexes where tablespace_name = 'DCC_DROP2';