Re: sql*loader - load same sequence in 2 columns

Hello Conan

Thanks for your help. I did finally get it to work. I think the trailing nullcols did the trick.

Regards

Paul

In article <TDEA5.4108$Bw1.2257_at_news.indigo.ie>,   "Conan" <conan_at_(no-spam)as-if.com> wrote:
> Hi Paul,
> I got it to work for me on a test file, although I know getting
> something to work on test data on live data are 2 different things.
 One
> thing I had to do was add a Trailing Nullcols statement after the
 delimiter
> statement so you could try that. In the meantime as a workaround you
 could
> do this
>
> create or replace trigger gtregion_insert
> before insert on gtregion
> for each row
> begin
> if :new.A_COUNTRY_ID is null then
> :new.A_COUNTRY_ID := :new.A_REGION_ID ;
> end if;
> end;
>
> and then remove A_COUNTRY_ID from the control file
>
> HTH
>
> Conan
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 13 2000 - 10:26:48 CEST