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"
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.
Click on the link in Related Information below to download the Service Pack, if necessary. **
Last Published : 5/5/2016
Article ID: 000008210