Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table_1(c1, c2) as
  select level, level+1
    from dual
 connect by level < 5;

4 rows affected

 select * from table_1;


C1
C2


1
2

2
3

3
4

4
5


create table table_2( c1 primary key, c2) as
  select * from table_1;
4 rows affected

select * from table_2; 


C1
C2


1
2

2
3

3
4

4
5


select constraint_name
      , table_name
      , constraint_type
    from user_constraints


CONSTRAINT_NAME
TABLE_NAME
CONSTRAINT_TYPE


SYS_C0057537
TABLE_2
P