This discussion is archived
3 Replies Latest reply: Jan 25, 2013 1:25 PM by rp0428 RSS

Create table from another table including constraints

user621430 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points