p_manage_01 in parallel: Z95_ID: "name is already used by an existing object"
- Article Type: General
- Product: Aleph
- Product Version: 16.02
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:
I see that you have 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.
- Article last edited: 10/8/2013