Re: Web Services w/Oracle and lots of data - practical?
Date: 15 Jul 2004 00:33:24 -0700
Message-ID: <81511301.0407142333.3d43d087_at_posting.google.com>
150,000+ records daily ....
with XML, you will:
- have few times (5-20 times) larger files
- have to encode relational data from source into XML and decode XML back into target
- probably cannot use Direct/Parallel Load Inserts
[Quoted] Once we (our dev. team) were forced to use such "STANDARD FORMAT"
(XML) for Oracle to Oracle bulk
loads (data transfer inside of one department of the one company!!!),
we ended up with more coding, more bugs, less flexibility (we had to
split very large XML files into small ones since there were
unmanageable) and unsolved management of the files (which directory,
which permissions, what if file does not exists etc. etc) - we did not
have time for it.
ulrich_at_ulrichandhelvas.com (Roy Zolnoski) wrote in message news:<a419c803.0407140955.28d85e5_at_posting.google.com>...
> Thanks for the replies! I agree that dblink would work best but not
> all source systems are Oracle. I'm interested to know if anyone's
> used Oracle XML flat files to move large amounts of data and how the
> performance compares to old CSV-type files.
Received on Thu Jul 15 2004 - 09:33:24 CEST