Hello,
I'm working on a migration of the test environment of a customer running on version 12.3.9HF2 to version 24.4.0HF2. During the step PCK.AUTOMIC_UTF-8.MIG-STEP05.COPY.INIT.DATA.NOILM.DST from the latest available UTF8 migration package we are facing the following issue:
2025-05-08 22:47:00 - U02000005 Job 'PCK.AUTOMIC_UTF-8.MIG-STEP05.COPY.INIT.DATA.NOILM.DST' with RunID '188611380' started.
2025-05-08 22:47:00 - U02012001 Successfully established connection to 'xxx.xxx.xxx.xxx:1521/DATABASENAME' with user 'uc4adm'.
2025-05-08 22:47:00 Oracle
2025-05-08 22:47:00 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
2025-05-08 22:47:00 Version 19.25.0.0.0
2025-05-08 22:47:00 - U02012014 JDBC Driver version: 18.3.0.0.0
2025-05-08 22:47:00 insert /*+ APPEND */ into RH NOLOGGING select * from RH@uc4source where RH_AH_Idnr between 1081716 and 188080042
2025-05-08 22:47:04 - U02012003 1809559 row(s) affected
2025-05-08 22:47:04 commit
2025-05-08 22:47:04 insert /*+ APPEND */ into RT NOLOGGING select * from RT@uc4source where RT_AH_Idnr between 1081716 and 188080042
2025-05-09 03:59:23 ORA-24801: Unzulässiger Parameterwert in OCI-LOB-Funktion
ORA-02063: vorherige line von UC4SOURCE
ORA-30036: Segment kann nicht um 8 in Undo Tablespace 'UNDOTBS1' erweitert werden
2025-05-09 03:59:23 - U02004025 Job-script execution was aborted.
2025-05-09 03:59:23 - U02012006 SQL Rollback executed
What might be the problem with "ORA-24801: Unzulässiger Parameterwert in OCI-LOB-Funktion" or is the issue that unsufficient Tablespace 'UNDOTBS1' only?
Any help appreciated, thanks in advance.
------------------------------
kind regards
Peter
------------------------------