NACHA Errors: ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705
(Doc ID 351123.1)
Last updated on OCTOBER 25, 2024
Applies to:
Oracle HRMS (US) - Version 11.5.10.2 and laterInformation in this document applies to any platform.
ConcurrentProgram:NACHA - NACHA
Symptoms
Problem Statement:
NACHA Process fails with the following error:
SQLERRMC ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705
396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
SQL_NO 1617
TABLE_NAME pay_core_files.write_to_file
APP-PAY-06881: Error ORA-01693: max # extents (505) reached in lob segment
HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
has occurred in table pay_core_files.write_to_file at location 1617
Cause: an oracle error has occurred. The failure was reported on table
pay_core_files.write_to_file at location 1617 with the error text ORA-01693: max # extents (505)
reached in lob segment HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
.
Action: Please contact your support representative.
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705
396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
SQL_NO 1617
TABLE_NAME pay_core_files.write_to_file
APP-PAY-06881: Error ORA-01693: max # extents (505) reached in lob segment
HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
has occurred in table pay_core_files.write_to_file at location 1617
Cause: an oracle error has occurred. The failure was reported on table
pay_core_files.write_to_file at location 1617 with the error text ORA-01693: max # extents (505)
reached in lob segment HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
SQL_NO 1617
TABLE_NAME pay_core_files.write_to_file
APP-PAY-06881: Error ORA-01693: max # extents (505) reached in lob segment
HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
has occurred in table pay_core_files.write_to_file at location 1617
Cause: an oracle error has occurred. The failure was reported on table
pay_core_files.write_to_file at location 1617 with the error text ORA-01693: max # extents (505)
reached in lob segment HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
.
Action: Please contact your support representative.
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705
396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
SQL_NO 1617
TABLE_NAME pay_core_files.write_to_file
APP-PAY-06881: Error ORA-01693: max # extents (505) reached in lob segment
HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
has occurred in table pay_core_files.write_to_file at location 1617
Cause: an oracle error has occurred. The failure was reported on table
pay_core_files.write_to_file at location 1617 with the error text ORA-01693: max # extents (505)
reached in lob segment HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
.
.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |