Hi

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?

Regards
Anabel