Harvinder,
Are these valid dates? Some clearly aren't ( "0"). I can think of at least
two ways to get this loaded:
1. Use a column expression (http://tinyurl.com/29k93m) within your
Sqlloader control file to convert the data into a valid date.
2. Load the data into a staging table that has this column defined as a
VARCHAR2. Then write a PL/SQL procedure that moves the data from the
staging table to the real table. The procedure should include the necessary
logic to convert this column into a recognized Oracle date format.
On 10/3/07, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote:
>
> Hi,
>
> We have a flat file that contains a column and the values are stored as:
> 991123
> 421
> 60823
> 0
> 70930
>
> Now we are moving data from flat file to table and this column will be
> inserted into Date dataype column, What is the way to insert into this
> table and avoid "ORA-01821: date format not recognized" errors.
>
> Thanks
> --Harvinder
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Rumpi Gravenstein
