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

지금 지원 담당자와 채팅

반품

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

제목

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

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...
원인

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.
해결 방안

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

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

권장 콘텐츠

제목