FreddyFrancis
Well Known Member
Hello List,
We have a table with 4 million records. THe table structure is getting changed and hence data needs to be backed up and then put back into the table with the new structure.
the database being Oracle 10g
What options do we have so that we do the process in least possible time.
insert into T2 c1,c4,c2,c3 select c1,0,c2,c3
this can be done if the data is small.. but for the amount of data i menationed above this would take timee.
There are business reason why we are forced to change this table.
Regards,
Freddy
We have a table with 4 million records. THe table structure is getting changed and hence data needs to be backed up and then put back into the table with the new structure.
the database being Oracle 10g
What options do we have so that we do the process in least possible time.
insert into T2 c1,c4,c2,c3 select c1,0,c2,c3
this can be done if the data is small.. but for the amount of data i menationed above this would take timee.
There are business reason why we are forced to change this table.
Regards,
Freddy