SQL Loader and new not null columns.

From: akush <Berlin3010_at_web.de>
Date: Fri, 13 Aug 2004 12:03:28 +0200
Message-ID: <2o3hvnF6e71lU1@uni-berlin.de>

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 Received on Fri Aug 13 2004 - 05:03:28 CDT