Description: Running a parallel indexing p_manage_01, we see the following message in the $aleph_scratch p_manage_01 log: SQL-ALEPH_ADMIN> 14:21:23 SQL-ALEPH_ADMIN> CREATE UNIQUE INDEX ABC07.Z95_ID ON ABC07.Z95 (Z95_DOC_NUMBER ASC) * ERROR at line 1: ORA-00955: name is already used by an existing object This message in the $data_scratch z95_dmp_ora.log.5: Record 1: Rejected - Error on table ABC07.Z95. ORA-00001: unique constraint (ABC07.Z95_ID) violated And there is a z95.bad file in $data_scratch which has a non-zero length. (It should be zero.) Resolution: We see these lines in the ABC07 file_list: LS z95 ABC02 LS z97 ABC02 LS z970 ABC02 LS z98 ABC02 LS z980 ABC02 If you are running p_manage_01 to regenerate the Z9n files for ABC07, then the Z9n tables and indexes need to be defined in the ABC07 file_list -- not LS'ed. |