Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DanDanAUS
  • Content: Threads
  • Order by date
  1. DanDanAUS

    Speed up an update statement on a big table

    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...
  2. DanDanAUS

    Alter a view to point to a new table?

    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...
  3. DanDanAUS

    Bulk Inserting a CSV file in Oracle9i using stored procedure?

    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
  4. DanDanAUS

    Problems with external tables in loading csv file

    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...

Part and Inventory Search

Back
Top