Home » Server Options » Spatial » Truncate Table
Truncate Table [message #75853] Sun, 05 December 2004 11:55 Go to next message
Mark Day
Messages: 1
Registered: December 2004
Junior Member
Question

I would like to know when you truncate a table, do you need to drop and recreate the index, and if the associated MDSYS tables need to be cleaned.

Reason

I have a tool that inserts a spatial point into a feature. When I moved from the test environment to the live environment I trucated the feature to remove the test data and dropped and recreated the sequence. I then restested and all worked fine.

I then had to restart the server and I now get the error Ora-03113: End of file on communication channel.

I have narrowed this down to where the tool is trying to insert the new ID number and suspect that the feature is out of sink with the index/sequence/mdsys.  
Re: Truncate Table [message #193328 is a reply to message #75853] Fri, 15 September 2006 13:04 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
No If u use truncate the table then the table records will be deleted for ever and you cannot rollback them ...
Previous Topic: AutoDesk Map text to Oracle - 911
Next Topic: Rounding Latitude / Longitude accurately
Goto Forum:
  


Current Time: Tue Aug 22 06:17:24 CDT 2017

Total time taken to generate the page: 0.01832 seconds