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: 456
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: GIS: what should i know..?
Next Topic: RDF, SDO_RDF_MATCH
Goto Forum:
  


Current Time: Wed Sep 17 06:58:36 CDT 2014

Total time taken to generate the page: 0.05705 seconds