NOT NULL in Table creation

[Maarten]

After comparing schemes I get this output:

[Tom Harris]

Hi there,

apologies for the delay in getting back to you. This one had us bamboozled for a while. Our theory is that the constraint is probably DEFERRED which means you can insert nulls into that column as long as they are not there when the transaction finishes. This causes Oracle to report that the column can accept nulls. Could you please run the following SQL to confirm if this is what is happening?

Regards, Tom

Tom Harris, Red Gate Software

SELECT
c.owner,
c.table_name,
c.qualified_col_name AS column_name,
c.nullable
FROM all_tab_cols c
WHERE c.owner = 'MARC' AND c.table_name = 'DESTDETT'
ORDER BY owner, c.table_name, c.column_id;


SELECT
c.owner,
c.constraint_name,
c.table_name,
cc.column_name,
c.search_condition,
c.deferrable,
c.deferred
FROM
all_constraints c
LEFT JOIN all_cons_columns cc ON c.owner = cc.owner
AND c.constraint_name = cc.constraint_name
WHERE c.owner = 'MARC' AND c.table_name = 'DESTDETT'
AND c.constraint_type IN ('P', 'U', 'C', 'V', 'O')
ORDER BY owner, c.constraint_name, cc.position, cc.column_name

[Maarten]

First query:

[Tom Harris]

Hi there,

we believe that we have now fixed this issue. Please drop an email to productsupport@redgate.com so that we can send you out a new build to try.

Kind regards, Tom

Tom Harris, Red Gate Software

[Maarten]

Hi Tom,

I've send you an email

[Tom Harris]

Hi there,

the fix for the issue is now incorporated into the Red Gate Oracle tools download. You can grab the latest version from

http://www.red-gate.com/products/oracle-development/

Kind regards, Tom

Tom Harris, Red Gate