This content has been marked as final. Show 2 replies
this query creates only structure. how to copy indexes of emp also. Emp table has lot of indexes,unique indexes and functional based indexes. how can i take them to empy_copy. iPlease advice the query to copy indexes too.
create table emp_copy as select * from emp where 1=2.