Oracle 9i migration help

[Dcicero]

Hi guys!

Windows 2003 Server (VM)
RAM 4GB
Oracle9i

I am trying to migrate data between tables using an xml file. The process works, but it is horribly slow. Its processing about 35 records in 8 hours. I haven't been able to determine why. Other migration have moved considerably faster, maybe 10x faster. I'm at a loss on how I can make this process faster. Any help would be most welcome. If you need more info please ask. Thanks in advance. - David

 

[SantaMufasa]

David,

XML is particularly useful when migrating data between heterogeneous systems (e.g. Oracle <-> SQL Server, et cetera). But if you are transferring data Oracle <-> Oracle, then among the much faster methods is Oracle Export/Data Pump. Is there any reason that you cannot use those options?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[Dcicero]

I suppose not, though we have used xml files for a long time. and there are other migrations taking place using xml files, oracle <-> oracle, and they are pretty fast..much faster than mine.