How long does a query take?
I am trying to load an xml file of 500MB into a database with the command
Load xml local infile ’c:/test.xml’
Into table medarbetare
Rows identified by ‘<medarbetare>’;
I have tried the command on a small part (50 rows) of the file and it worked fine. But when trying it on the whole file ... it was "thinking" for 4 hours, then I started to suspect something was wrong. Now I can´t stop it.
How long is the loading supposed to take (did I try to break it too early?)
Subject
Written By
Posted
How long does a query take?
June 17, 2010 06:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.