Search results for query: *

Hmmmm this really gets me thinking. I am even using external tables with SQL loader driver to insert the data in the database table and takes 2.3 minutes to insert the 1.3 milion records. I cant get why the insert that Dragon does even with an in efficient way takes only small time. Only...

Dear all, I have a table that has 1.3 million records. The full insert of that data using external tables takes 2.3 minutes. Which is really nice time. But when i try and update the full table takes up to 20 minutes. The update takes place every 30 minutes and its updating at least 1 million...

Thank you for the reply mate. That helped to solve the problem. Much apreciated. Once more thank you. Cheers Dan

Greetings all, Is it possible in Oracle 9i to alter a view to point to a different table then the one that it already it points to? I have one view that users will be constantly hitting. It pressents the view of a table that has 2 million records. The update to the table takes over 20 minutes...

Greetings all, Is there a similar way in Oracle to the Bulk Insert Command in SQL Server to bulk load a csv file in Oracle? Something else then the External Table and the SQL*Loader. Sincerely Dan

Dear all I have some problems while using external tables in oracle 9i to load a csv file. The post that explains something similar is in this thread: thread759-1423819 I will explain the scenario: My scenario is as follows: There is a unix box that has the Oracle database. On that box...