Solution for "Maximum blob size exceeded" prompt when copying and pasting element classes (including BLOB)

A user problem today

User Environment: Oracle 11.1.0.6 arcsde9.3.1

Problem description: The user's data contains the Blob field. It is estimated that the data stored in this blob is large or small. If you copy and paste the data through arccatalog or load the data, it will report

Failed to paste layer name
Table not registered username. layer name
Maximum blob size exceeded

The key error is that the Blob size exceeds the maximum. We can analyze the problem by checking the ArcSDE parameter.

The ArcSDE parameter has two parameters that involve blob.

========================================================== ======

Parameter Name: maxblobsize
Description: The maximum size (in bytes) of the User-Defined blob)
Default Value:-1 (se_unlimited_blobsize), default parameter of arcsde10

Note: From ArcGIS 10, this parameter is set to-1 (se_unlimited_blobsize ). All new and upgraded geographic databases will be set as unrestricted.

========================================================== ======

Parameter Name: blobmem
Description: When storing BLOB, the server must accumulate blob segments sent by applications over the network. If the Blob size is greater than blobmem, the server will write the BLOB data to the disk file before it is stored in the database. If the Blob size is smaller than blobmem, the server accumulates the Blob into the memory. If blobmem is a negative value, the server will always use the memory instead of the Blob size.
Default Value: 1,000,000 bytes

========================================================== ======

Because the user's version is arcsde9.3.1, The maxblobsize parameter of ArcSDE is still the default 1000000 byte (1 m), that is, the maximum blob storage size is limited to 1 MB, if the value is greater than 1 MB, the following error is reported (the figure shows the test result)

To solve the problem in arcsde9.3.1, you only need to modify the maxblobsize parameter to 1000000000 and add a few more zeros.

 

PS: I have tested it. No more arcsde9.3.1 can directly change this value to-1 se_unlimited_blobsize.

 

Note: The above error is the arcsde9.3.1 error, and the image is the arcsde10 error, which may be different.