SQL Loader Vs DBLINK to Migrate Data
From: William Ndolo Intertek <william.ndolo_at_intertek.com>
Date: Tue, 1 Nov 2016 13:37:11 +0000
Message-ID: <SN2PR03MB241555275958076CCB1C86ED98A10_at_SN2PR03MB2415.namprd03.prod.outlook.com>
I am setting up a process of moving data from UAT to Test environment and eventually to production. The databases are very small at this time(about 10G each for both Test and UAT). We expect to use the same method in production but the production databases are projected to grow rapidly into hundreds of terabytes. At this point, DBLINK seems to be doing the job but considering sqlloader as an alternative when the databases get large. There are many other tools/methods however, we are looking for something simple that can be automated. Can anyone share their experience with both and other oracle tools? Can anyone point me to Oracle documentation that does that kind of comparison or maybe recommends one as opposed to the other?
CONFIDENTIALITY NOTICE
This e-mail may contain confidential or privileged information, if you are not the intended recipient, or the person responsible for delivering the message to the intended recipient then please notify us by return e-mail immediately. Should you have received this e-mail in error then you should not copy this for any purpose nor disclose its contents to any other person.
Date: Tue, 1 Nov 2016 13:37:11 +0000
Message-ID: <SN2PR03MB241555275958076CCB1C86ED98A10_at_SN2PR03MB2415.namprd03.prod.outlook.com>
I am setting up a process of moving data from UAT to Test environment and eventually to production. The databases are very small at this time(about 10G each for both Test and UAT). We expect to use the same method in production but the production databases are projected to grow rapidly into hundreds of terabytes. At this point, DBLINK seems to be doing the job but considering sqlloader as an alternative when the databases get large. There are many other tools/methods however, we are looking for something simple that can be automated. Can anyone share their experience with both and other oracle tools? Can anyone point me to Oracle documentation that does that kind of comparison or maybe recommends one as opposed to the other?
Thanks and best regards,
Bill
Valued Quality. Delivered.
CONFIDENTIALITY NOTICE
This e-mail may contain confidential or privileged information, if you are not the intended recipient, or the person responsible for delivering the message to the intended recipient then please notify us by return e-mail immediately. Should you have received this e-mail in error then you should not copy this for any purpose nor disclose its contents to any other person.
Intertek is dedicated to Customer Service and welcomes your feedback. Please visit http://www.intertek.com/email-feedback/ to send us your suggestions or comments. We thank you for your time.
Except where explicitly agreed in writing, all work and services performed by Intertek is subject to our Standard Terms and Conditions of Business which can be obtained at our website: http://www.intertek.com/terms/ Should you have any difficulty obtaining these from the web site, please contact us immediately and we will send a copy by return.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 01 2016 - 14:37:11 CET