To see the structure of table and index in oracle

select
dbms_metadata.get_ddl('TABLE','TABLE_NAME','SCHEMA_NAME') 
from dual;

select
dbms_metadata.get_ddl(INDEX,'INDEX_NAME','SCHEMA_NAME')
from dual;