Copy a very big table from one database to other
I have to copy a very big table from one database o another database. This table has around 74080422 rows and the AVG_ROW_LEN is 151.
I have tried with export/import but it took 1 hour in the export and the import was running 3 days and it didn't finish.
I have tried to make a create table as select * from cargos@db1.
I mean using a database link but we waited 12 hours and it didn't finish, the temp tablespace was full, this terminate the process. The temp tablespace has 14 gigas.
Does anyone know a different way to copy big tables??
Does anyone have a suggestion?
Click Here to Expand Forum to Full Width