topic Re: Cleaning up orphan sde logfiles in Data Management Questions https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449636#M25692 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Vince.</SPAN><BR /><BR /><SPAN>Truncate it is!</SPAN></BODY></HTML> Thu, 31 Mar 2011 13:46:44 GMT NickHarrison 2011-03-31T13:46:44Z Cleaning up orphan sde logfiles https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449634#M25690 <HTML><HEAD></HEAD><BODY><SPAN>System - </SPAN><BR /><SPAN>SDE 9.2 SP6, Oracle 10.2.0.4, Versioned geodatabase</SPAN><BR /><BR /><SPAN>I have several hundred records in my SDE_LOGFILES and several hundred thousand in my SDE_LOGFILE_DATA tables that have persisted even though I have no active SDE sessions.</SPAN><BR /><SPAN>According to the user docs these records are supposed to be truncated when the SDE session disconnects. </SPAN><BR /><BR /><A href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=2253&amp;pid=2243&amp;topicname=Log_file_tables_in_a_geodatabase_in_Oracle">http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=2253&amp;pid=2243&amp;topicname=Log_file_tables_in_a_geodatabase_in_Oracle</A><BR /><BR /><SPAN>Is it safe to just delete these records using SQL?</SPAN></BODY></HTML> Wed, 30 Mar 2011 19:56:05 GMT https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449634#M25690 NickHarrison 2011-03-30T19:56:05Z Re: Cleaning up orphan sde logfiles https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449635#M25691 <HTML><HEAD></HEAD><BODY><SPAN>Using DELETE won't free the high-water storage for those tables.&nbsp; You can either TRUNCATE</SPAN><BR /><SPAN>or DROP them (they'll get recreated in either the default tablespace or according to DBTUNE</SPAN><BR /><SPAN>storage rules).</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 31 Mar 2011 01:41:05 GMT https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449635#M25691 VinceAngelo 2011-03-31T01:41:05Z Re: Cleaning up orphan sde logfiles https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449636#M25692 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Vince.</SPAN><BR /><BR /><SPAN>Truncate it is!</SPAN></BODY></HTML> Thu, 31 Mar 2011 13:46:44 GMT https://community.esri.com/t5/data-management-questions/cleaning-up-orphan-sde-logfiles/m-p/449636#M25692 NickHarrison 2011-03-31T13:46:44Z