laptop and a wrench

Bug

Within Oracle RAC environment, pipes are not purged from memory following reset of sequence triggered by truncate.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM082952
SubmittedJuly 20, 2012
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.0
Operating SystemWindows OS
Operating System Version2003
Version FixedN/A
StatusFixed

Workaround

Modify the script to drop the specific pipe for the table in question:DECLARECURSOR pipe_list IS SELECT name FROM v$db_pipes;pipe_result NUMBER;BEGINFOR del_pipes IN pipe_list LOOPpipe_result := DBMS_PIPE.REMOVE_PIPE(del_<a href="http://pipes.name" target="_blank">pipes.name</a>);END LOOP;END;/

Steps to Reproduce

Bug ID: NIM082952

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options