Re: SQL Loader and new not null columns.

akush wrote:

> Hi,
>
> i want to migrate a database from centura to oracle with the SQL
> Loader. The new Schema on Oracle has now on some tables a new Column
> that has "not null" values. Is it possible to tell the SQL Loader that
> there should be inserte default values and not a null value? I thougth
> that if i define the column with a default value that the SQL Loader
> will take this value, but that seems not to be.
>
>
> The controlfile:
>
> LOAD DATA
> INFILE '/LinuxDBMigration/Data.bulk'
> BADFILE '/LinuxDBMigration/Data.bad'
> DISCARDFILE '/LinuxDBMigration/Data.dis'
> APPEND INTO TABLE usr.xsession
> FIELDS TERMINATED BY ','
> ("SESSIONID","XSTART" DATE(20) "dd.MM.yyyy HH24.MI.SS","XEND" DATE(20))
>
> Thx for help
> akush

Yes. Look up SQL Loader at http://tahiti.oracle.com

There are several ways to do it. One way is to use NVL in your control file.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)