Re: data move concept

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: ebuddelm@xxxxxxxxx
  • Date: Mon, 24 Aug 2009 12:12:25 +0100

more generally the first 3 considerations at;jsessionid=BHE2JTPS1VAILQE1GHRSKH4ATMY32JVN?articleID=207002081&pgno=1
apply here. I'd generally say, at least start with an automated tool -
complete with error trapping, logging, auditing etc etc (all the
instrumentation people don't normally put into hand-crafted things) - and
then deal with performance as a performance tuning exercise afterwards.
There can of course be rather a large dollar cost to this recommendation.

On 8/24/09, Eric Buddelmeijer <ebuddelm@xxxxxxxxx> wrote:
> Brian,
> If you are really talking about concepts, you could also look into Oracle
> Warehouse Builder (OWB) and/or Oracle Data Integrator (ODI). Underneath both
> will use the techniques described in the other reactions, of course. But if
> you are talking about error trapping and re-runable and not too much coding
> yourself, you could look into one or both of these options.
> regards,
> Eric.
> 2009/8/18 Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>
>>  Hello all,
>>     I have systems that need to take data from other systems like most of
>> you probably have to do.  I need to take from sql server and other oracle
>> systems.  I can do it the old fashion way of creating flat files, ftp and
>> sqlload.  But with the tools of 10g is there a better way?  Something that
>> is reliable, re-runnable, error trapping, etc.....
>> I tested some things like:
>> - DTS from sql server 2000 into a temp table and then ran scripts against
>> the temp table
>> - Created a link to oracle and did a select into
>> - flat file and sqlload
>> Anything else?  I just want to try and use something current and reliable
>> for moving and loading data.  I am open to all kinds of ideas.
>> ciao,
>> Brian
>> This email message may contain legally privileged and/or confidential
>> information. If you are not the intended recipient(s), or the employee or
>> agent responsible for the delivery of this message to the intended
>> recipient(s), you are hereby notified that any disclosure, copying,
>> distribution, or use of this email message is prohibited. If you have
>> received this message in error, please notify the sender immediately by
>> e-mail and delete this email message from your computer. Thank you.

Niall Litchfield
Oracle DBA

Other related posts: