Hi All,
I have 3.5 billions data are getting generated in one table and My goal is to move the data from One database to other database through DBLINK.
1.The table destination and source tables are partitioned table
2.We are using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
3. This is a daily activity
4.I have already used the following information
1. I have multi threaded(32 threads) the operation with Append hint in the hints- took ~10hr (partitioon to partion insert I am doing)
2.Also used bulk collect -forall insert (partition to partition insert with append hint - tool ~9hr
Can you please suggest any other way,so that the insert can can be faster and will be completed in the range of 1 to 1.5 hr?
Thanks,