English

Bug: Copying data between Oracle tables containing BLOB columns returns ORA-03127 error

Description

** This issue is addressed in ArcSDE 9.1 Service Pack 1 (SP1) **

The following Oracle error occurs randomly when copying data between two ArcSDE Oracle tables that contain a BLOB column:

"ORA-03127: no new operations allowed until the active operation ends"

Cause



This is a known issue.



A transmission buffer size set too low causes BLOB data to fill the transmission buffer. The BLOB fetch is then incomplete, preventing further operations and returning the error.

Workaround

** This issue is addressed in ArcSDE 9.1 Service Pack 1 (SP1).

Click on the link in Related Information below to download the Service Pack, if necessary. **



    Related Information