Return
-
Title
Receiving ORA-01400: cannot insert NULL when reorganizing a table without a unique key, a "NOT NU -
Description
Issue: When reorganizing a table without a unique key, a "NOT NULL" constraint is put on all columns in the table.Error Codes: ORA-01400: cannot insert NULL... -
Cause
Explanation: This is an issue with Space Manager 6.2. When the ROWID method is used in LiveReorg, all the columns will be set to NOT NULL. The program "thinks" that all the columns are the ROWID column (which should be set to NOT NULL). Fortunately, the use of the ROWID method is now very restricted. If there is no suitable index or constraint for replication, LiveReorg will use the "all columns" method and not the ROWID method unless there is a LONG column and the QSA parameter ALLOW_LONG_WO_UNIQUE=NO.
-
Resolution
Pre-requisite: You must be sure that no rows in the table are made unique by the LONG or LOB columns.
update quest_exec_parameter set value='YES' where name = 'ALLOW_LONG_WO_UNIQUE'.Commit;<then generate script>To recap the exception to this workaround:The only problem with this method is when a table has 2 or more rows that are exactly the same without including the Long/Clob value. This situation can cause the wrong row to be updated when using the NONE method