/*********************查询表是否有索引******************************************************************/ Select table_owner,table_name,index_name,column_name FROM dba_ind_columns Where table_owner=upper('migrate') AND table_name='';