So, the big question is: how much downtime can you afford on the current Oracle DB?
Yes, you should investigate the most efficient way to transfer data, but with TBs it will still be significant time. If
youcan afford the down time, great--kill all other connections to Oracle and go for it. If not, that's more complicated
sinceyou'll have to figure out a way to track and apply changes that happen during the copy...
