Bug: Copying data between Oracle tables containing BLOB columns returns ORA-03127 error
** 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"
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.
** 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. **
Last Published : 5/5/2016
Article ID: 000008210
Software: ArcSDE 9.1