My Oracle Support Banner

ORA-12801, ORA-01630, ORA-1658 Occurs Running The 'Synchronize WF LOCAL tables' Concurrent Program (Doc ID 837663.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Workflow - Version 11.5.10.2 to 12.2.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
 


Symptoms

On 11.5.9 in Development:
Concurrent Program "Synchronize WF Local tables" fails with the following error in the request log file when submitted with the following parameter values:

Orig System - ALL
Parallel Processes - 0
Logging Mode - NOLOGGING
Temporary Tablespace - NULL

ERROR
ORA-12801: error signaled in parallel query server P001
ORA-01630: max # extents (505) reached in temp segment in tablespace APPLSYSD

OR

ORA-12801: error signaled in parallel query server P000
ORA-1658: unable to create INITIAL extent for segment in tablespace APPLSYSD



STEPS
1. Log in to Oracle Applications.
2. Submit the Concurrent Program "Synchronize WF Local tables" with the following parameter values:
Orig System - ALL
Parallel Processes - 0
Logging Mode - NOLOGGING
Temporary Tablespace - NULL
3. Request fails with the ORA-01630 error in the request log file.

EXPECTED BEHAVIOR
When submitted, Concurrent Program "Synchronize WF Local tables" should complete successfully.

Changes

None.

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
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.