insertion with quick performence

[sundaralois]

Hi,

I have a lackhs of records in one table. In this table count will be increased automatically daily basis. At this same level I have one more copy table for this one not containing the records, It is empty table, but having the same structure of above.
I would like to insert the first one's date to this one.

How can I insert very fastly the second one.


Regards
Sundar

[r035198x]

Hi,

I have a lackhs of records in one table. In this table count will be increased automatically daily basis. At this same level I have one more copy table for this one not containing the records, It is empty table, but having the same structure of above.
I would like to insert the first one's date to this one.

How can I insert very fastly the second one.


Regards
Sundar

Do you want to insert the date or the data? i.e Do you want to duplicate a table or to copy just one column of a table into another.

[debasisdas]

if u want the second table with exact same structure and record then u can do two things.

1.create table2 as select * from table 1;

or

2.insert into table2 select * from table1;


since u alredy have a table with similar structure use the 2nd method.