2 Replies Latest reply: Dec 13, 2012 11:03 AM by hitgon RSS

    copy indexes also while creating table

      is there any way i can take exact structure of table including indexes and create another table. i don't need the data.
      create table emp_copy as select * from emp where 1=2.
      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.