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

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

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

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

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.
Resolución

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

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 1/29/2010
Última actualización: 5/7/2023

Título