Re: formatting rows after data sql*ldr data import

pjam001_at_yahoo.co.uk (Paisa) wrote in message news:<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.

In most cases you don't need to use to_date when loading dates. Just describe your field as date with format in single quotes, like

a date 'MM/DD/YYYY'

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