ora-00984

Oracle sqlldr: column not allowed here

Can anyone spot the error in this attempted data load? The '\\N' is because this is an import of an OUTFILE dump from mysql, which puts \N for NULL fields. The decode is to catch cases where the field might be an empty string, or might have \N. Using Oracle 10g on Linux. load data infile objects.txt discardfile objects.dsc truncate in...

oracle error, column not allowed here

I haven't used Oracle for a while so I'm a bit rusty. This is my table: create table calendar( username VARCHAR2(12), content VARCHAR2(100), dateContent DATE, type CHAR(3) CHECK (type IN ('PUB', 'PRV'))); But when I try to insert a value like this: insert into calendar (username, content, dateContent, type) values (chris, assignmen...