Transferring big table
Hello Team,
I am in a scenario where i have 2.2TB of a single table and have to transfer it to remote database with 100Mb/s bandwidth. What will be the feasible method to transfer this big table? I tried with few options but getting the error below everytime after 12 Hours - 15 Hours.
ORA-12801: error signaled in parallel query
server P005, instance sourcedb.domain.net:racinst1 (1)
ORA-01555: snapshot
too old: rollback segment number 309 with name "_SYSSMU309_3220109816$"
too small
The source database is transactional. What could be the best approach to transfer this big table? The error i am getting is common but in my case, increasing the undo retention for this long can affect other client sessions.
0