How to Transfer huge datas between 2 databases
170574Nov 3 2003 — edited Nov 5 2003We have 2 oracle databases phyiscally located in 2
different places(Far). Basically we need to extract data
from source database & load into target database. It
is approximately 50 Million records of 8-10 tables.
The structure of tables are same for both source &
target tables. These data transfer will be every week.
I explored on 3 options.
1. Select & Insert using DBlinks
2. Generate the flat file at source DB , Move to FTP
server & load into target database using SQL Loader.
3. Export using Query option (Since I need to
partially extract from source tables)
Option 1 is depend on network speed & Its going to be
slow.
Option 2 is generating flat file & moving into ftp
server , Its time Consumption.
Option 3, I feel this is better option.
I need your valuable Input/suggestion from DB gurus.
Please advise me.