Can't Load Data "Field not nullable"

[tongkimongki]

Dear experts,

I cant load data into my Oracle SDE because there is error "field not nullable". I've checked all fields, they have property "allow null : Yes" except the geometry field. I have tried to load data which have values for all fields but the error is still the same.
Why ?

Environment: SDE 9.3 sp 1, Oracle 10g R2, Desktop 9.3, Windows 2000 Server

Thanks before

[VinceAngelo]

ArcSDE requires that the geometry column permit NULL values.  Registered
rowid columns are required to be NOT NULL.

- V

[tongkimongki]

Morning Vince,

I just realized that the geometry colums permit NULL values by default. As I said, i have tried to load data with non-empty values but it just wont get loaded... I dont have any null values, why do i get rejected as if i am trying to insert null values into non-null field ?

Thanks again

[VinceAngelo]

ArcSDE isn't generating this message, so I have no idea what is going on.

I'm assuming you're using Desktop to load.  Have you tried a command-line
loading tool with the same data?  Have you tried enabling tracing, and looking
at the sequence of functions?  Have you tried using 'sdetable -o describe' on
the table to see if the attributes agree (the rowid column cannot allow NULLs,
and must be SDE-set for ArcGIS to load it)?

- V

[JoseSanchez]

When I have this problem I just open the database with Oracle SQL DEveloper and change the specific field to accept null values. Do not use ArcCatalog for that.