oracle

[samsudhin]

sir,

may have a one doubt

how to copy the records from one table to another table with primary key option......



please do the needful.

[karthickkuchanur]

sir,

may have a one doubt

how to copy the records from one table to another table with primary key option......



please do the needful.

U can try like
update table tablename set column name=(select columnname from old table)

[mafaisal]

Hello

Try This

 Create Table NewTable as (Select * From OldTable)
 

I think Primary key is not copy only table data

Faisal

sir,

may have a one doubt

how to copy the records from one table to another table with primary key option......



please do the needful.

[debasisdas]

try using

insert table_name1 select * from table_name2;

But it will not copy the PK constraint.

You need to add that by altering the table.