SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name) FROM USER_INDEXES u where u.table_name = 'SHOP_PD';