Home » RDBMS Server » Server Utilities » control file enhancement in sql loader.
control file enhancement in sql loader. [message #247909] Wed, 27 June 2007 08:38
libra_1975
Messages: 1
Registered: June 2007
Junior Member
Hi,
I normally get a csv having data as
column1 ;columnb;columnc;
13 ; 12 ; 13 ;
11 ;13 ;33;
as the table where it needs to go is say table
xys( a number, b number , c number).
so the control file is fairly simple ...

But from now I need to restrict data entry if the change in format happens in the csv

say if it is like
column2;column1;column3,
12,13;12;
11;13;14;

or say the csv like
column1;column2;column3;column4;
11;13;14;15;
111;134;14;12;

in both cases sql loader should not run and throw the error saying the reason in the log.

how do i manage it in the control file `???

any ideas???

regards
Previous Topic: Oracle 8i import problem
Next Topic: Export issues
Goto Forum:
  


Current Time: Sun Dec 11 02:25:42 CST 2016

Total time taken to generate the page: 0.09876 seconds