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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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.
Résolution

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

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 1/29/2010
Dernière mise à jour le : 5/7/2023

Titre