formatting rows after data sql*ldr data import

From: Paisa <pjam001_at_yahoo.co.uk>
Date: 16 Sep 2002 04:47:32 -0700
Message-ID: <3af71835.0209160347.4ff98b76_at_posting.google.com>

I need to load about 800Mb worth of data into a table daily, using sql*ldr.
If i use the to_date function to format data as it goes into the table, sql*ldr uses conventional path load which takes ages, so I decided to keep the date as CHAR, so that it will use direct path load.

Is there any way of converting the data quickly, after it has been loaded, without using an INSERT statement for each row? Received on Mon Sep 16 2002 - 13:47:32 CEST

This message: [ Message body ]
Next message: David: "Select from a today_table_name"
Previous message: |Rens| 0: "username/password generation with a trigger"
Next in thread: Alex Filonov: "Re: formatting rows after data sql*ldr data import"
Reply: Alex Filonov: "Re: formatting rows after data sql*ldr data import"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message