select table_name
,      tablespace_name
from all_tables
where owner = 'MESUSER';


select index_name
,      index_type
,      table_owner
,      table_name
,      table_type
,      uniqueness
,      tablespace_name
from all_indexes
where owner = 'MESUSER';


select  table_name
,       index_name
,       index_type       
,       leaf_blocks
,       clustering_factor
,       num_rows
,       last_analyzed
from user_indexes
order by table_name asc;


SELECT TABLE_NAME, 'ALTER INDEX ' || INDEX_NAME || ' REBUILD TABLESPACE SIS_ESS_ID;'
FROM USER_INDEXES
WHERE TABLESPACE_NAME = 'USERS';

SELECT TABLE_NAME, 'ALTER TABLE ' || TABLE_NAME || ' MOVE TABLESPACE SIS_ESS_TS;' 
FROM USER_TABLES
WHERE TABLESPACE_NAME = 'USERS';