3 Replies Latest reply: Jan 25, 2013 3:25 PM by rp0428 RSS

    Create table from another table including constraints

    user621430
      Hi,

      Is there a way to create a table from another table including constraints.

      CREATE TABLE COPY_EMP
      as
      SELECT *
      FROM EMP
      WHERE 1 =2 ;

      This creates the table, but the constraints are not copied over.

      I was reading about DBMS_REDEFINITION - can that be used for this scenario ?

      Thanks!
      Anand