create [unique] index index_name on table_name(column_name[,columnname2...]) tablespace tab_space;--创建索引 select * from all_indexs;--获取所有索引信息