Receiving ORA-01400: cannot insert NULL when reorganizing a table without a unique key, a "NOT NU (4286652)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Receiving ORA-01400: cannot insert NULL when reorganizing a table without a unique key, a "NOT NU
Beschreibung

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...
Ursache

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.
Lösung

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

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel