Creating Bitmap Index

scott>create bitmap index bit_ind on dept(deptno);
scott>select a.table_name,a.index_name,a.index_type,b.column_name from user_indexes a,user_ind_columns b where a.table_name=b.table_name;