Article - CS428541
Import of dump data into new Oracle schema fails with ORA-20000 in Codebamer
Modified: 08-Oct-2024
Applies To
- Codebeamer 22.10 to 2.2
- Oracle Database
Description
- Import of dump data into new Oracle schema fails with ORA-20000
- Error messages look something like:
CBROOT.PERM_OBJECT_USER_MAPPING_AK : sqlerrm = ORA-20000: Unable to set values for index PERM_OBJECT_USER_MAPPING_AK: does not exist or insufficient privileges CBROOT.TASK_UUID_U : sqlerrm = ORA-20000: Unable to set values for index TASK_UUID_U: does not exist or insufficient privileges CBROOT.SYS_C007519 : sqlerrm = ORA-20000: Unable to set values for index SYS_C007519: does not exist or insufficient privileges CBROOT.SYS_C007479 : sqlerrm = ORA-20000: Unable to set values for index SYS_C007479: does not exist or insufficient privileges CBROOT.SYS_C007531 : sqlerrm = ORA-20000: Unable to set values for index SYS_C007531: does not exist or insufficient privileges CBROOT.SYS_C007850 : sqlerrm = ORA-20000: Unable to set values for index SYS_C007850: does not exist or insufficient privileges CBROOT.LOCK_KEY_UN : sqlerrm = ORA-20000: Unable to set values for index LOCK_KEY_UN: does not exist or insufficient privileges CBROOT.ARTIFACT_UUID_U : sqlerrm = ORA-20000: Unable to set values for index ARTIFACT_UUID_U: does not exist or insufficient privileges Importing statistics failed for 8 object(s); Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 10 error(s) at Tue Oct 8 11:01:10 2024 elapsed 0 00:05:01
This is a printer-friendly version of Article 428541 and may be out of date. For the latest version click CS428541