> With any serious data migration, where serious means having enough
data that
> you're worried about the performance of the one time migration, we
really
> need to consider native tools for doing the migration. Oracle provides a
> loader utility which is much more efficient than loading data through SQL.
You are right, Mike. I'm taking the XML idea back. I remember our last data
migration (from an ACS3-based system to an ACS4-based). Although the
migration was performed completely within Oracle (moving data from one
schema to another using PL/SQL scripts), the full run took abut 12 hours
to complete! I can't imagine how long it would have taken if we dumped
everything in XML and then parsed it again.