-
Copy a very big table from one database to other
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|